 |
| |
|
|
|
 |
|
|
Blog
Javier Guillen posted on September 10, 2011 21:03
PowerPivot currently has no programmatic interface, so there is really no automated way to leverage its capabilities (other than those provided by Pow...
[Read the rest of this article...]
Javier Guillen posted on July 12, 2011 23:14
Javier Guillen posted on July 08, 2011 23:48
Javier Guillen posted on July 03, 2011 22:49
How to calculate median over a PowerPivot measure
[Read the rest of this article...]
Javier Guillen posted on July 02, 2011 00:14
A common calculation required in business is moving averages. How can we create it in DAX? Lets walk through the calculation.
Imagine we have t...
[Read the rest of this article...]
Wayne Snyder posted on May 26, 2011 10:25
You just upgraded to SSRS 2008 R2 and some reports are hanging up, while others seem to work fine. How do you debug for this, and what is the fix?
[Read the rest of this article...]
Wayne Snyder posted on May 26, 2011 08:55
You install or upgrade to SSRS 2008R2 Gold, and get the following error "SSRS SystemOverflowexception: Value was either too large or too small for an Int32". Here is what is going on....
[Read the rest of this article...]
Javier Guillen posted on May 01, 2011 16:13
Presentation slides for PASS VC webinar on PowerPivot and DAX
[Read the rest of this article...]
Javier Guillen posted on April 28, 2011 14:42
PowerPivot can be a really powerful tool for prototyping Business Intelligence projects.
[Read the rest of this article...]
Javier Guillen posted on April 28, 2011 14:34
I will be speaking tomorrow for the Professional Association for SQL Server (PASS) Business Intelligence Virtual Chapter; my topic will be...
[Read the rest of this article...]
Javier Guillen posted on April 03, 2011 21:41
Slicer values in PowerPivot calculation: Restricting DAX filter context to values in query context
[Read the rest of this article...]
Javier Guillen posted on March 30, 2011 09:53
How to re-enable the PowerPivot add-in in case Excel removes it from the ribbon
[Read the rest of this article...]
Javier Guillen posted on March 04, 2011 09:20
Recently, I encountered a situation that required the use of SUMX as part of a DAX measure. Interestingly, SUMX seemed to only be taking in the ...
[Read the rest of this article...]
John L. Hall posted on March 09, 2011 15:05
How to determine the room you have left in a record to store more column data.
[Read the rest of this article...]
Javier Guillen posted on March 03, 2011 11:53
On March 19, I will be speaking about DAX Evaluation Context at SQL Saturday # 70 in Columbia, SC. As part of the presentation, I will comp...
[Read the rest of this article...]
Javier Guillen posted on February 24, 2011 22:06
One of the interesting DAX Time Intelligence functions is the TOTALYTD, which can define a measure calculation over a year in a cumulative way.
The ...
[Read the rest of this article...]
Javier Guillen posted on February 12, 2011 21:32
When building PowerPivot-based custom reports, authors can use DAX measures on Cube formulas, just as they have been able to do with traditional SSAS OLAP measures. MDX can also be applied over Vertipaq dimension attributes in order to create custom sets that can be reused over the custom report.
[Read the rest of this article...]
Wayne Snyder posted on January 27, 2011 13:58
One of my friends and co-workers has been working on an SSRS in Sharepoint Integrated mode problem. Melissa Coates has an excellent blog pos...
[Read the rest of this article...]
John L. Hall posted on January 13, 2011 19:21
Applies to SSAS 2008 and Excel 2007.
Also see this blog entry: OLAP Reporting with Excel 2007: Use Member Properties!! at http://blog.davyknuysen.be...
[Read the rest of this article...]
Javier Guillen posted on December 19, 2010 22:59 
How to use multiple slicer selected values in an Excel cube formula
[Read the rest of this article...]
Javier Guillen posted on November 16, 2010 22:12
Cube formulas can be used to query DAX measures
[Read the rest of this article...]
Posted in: SSAS, MDX, Blog
Javier Guillen posted on October 28, 2010 21:12
PowerPivot and Excel Cube functions can work together to create highly customized reports
[Read the rest of this article...]
John L. Hall posted on October 29, 2010 12:29
Annotation tables and the fact that SSAS formula engine allows non numeric measures can be a very powerful tool to show just about anything as a measu...
[Read the rest of this article...]
Javier Guillen posted on September 28, 2010 21:48
The new SSAS database architecture used in PowerPivot offer some exciting advantages for BI applications
[Read the rest of this article...]
Javier Guillen posted on September 08, 2010 13:10
One of the things I am fascinated with is how familiar data manipulation tools like Excel can be powerful BI enablers. While tradi...
[Read the rest of this article...]
John L. Hall posted on October 02, 2010 16:05
I recently was getting unexplained #Error when trying to replace a null with 0 on a SSRS report when the data source was a Analysis Service database.&...
[Read the rest of this article...]
Wayne Snyder posted on September 29, 2010 07:35
This morning I got an email from Craig Ellis with a picture of us at PASS ( probably 2009 or 2008). It was titled "Me and the Prez". Craig is one...
[Read the rest of this article...]
Wayne Snyder posted on September 28, 2010 08:07
I recently read a research report from the ITIC which which studied the number of security flaws reported against different databases since 2002. The ...
[Read the rest of this article...]
Wayne Snyder posted on September 27, 2010 14:24
Right now I am looking at rolling out SQL Server 2008R2 SSRS in a large enterprise and thinking about the developer's desktop software and how th...
[Read the rest of this article...]
Wayne Snyder posted on September 24, 2010 10:16
It feels strange that my first blog post will not be technical. Technical will come soon. I work for a great company Mariner, based in Charlotte...
[Read the rest of this article...]
|
|
|
|
|
|
| |
|
|