 |
| |
|
|
|
 |
|
|
MDX
Javier Guillen posted on July 08, 2011 23:48
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...]
William E. Pearson III posted on November 11, 2010 07:27
BI Architect Bill Pearson continues an extended examination of parameterization within Analysis Services reports. In this, Part 3 of the article, we continue to get hands-on practice creating a parameter within the graphical user interface, and then examine the construction that Reporting Services 2005/ 2008 / 2008 R2 performs behind the scenes.
[Read the rest of this article...]
William E. Pearson III posted on November 07, 2010 19:36
BI Architect Bill Pearson continues an extended examination of parameterization within Analysis Services reports. In this, Part 2 of the article, we continue to get hands-on practice creating a parameter within the graphical user interface, and then examine the construction that Reporting Services 2005/ 2008 / 2008 R2 performs behind the scenes.
[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 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 September 07, 2010 14:50
PowerPivot and DAX are a powerful technologies, but there is still a good amount of work that can be done with traditional cube functions. In its current version, PowerPivot lacks the concept of dimension hierarchies; however very customized Excel reports that leverage cube hierarchies can still be built using MDX enabled cube functions. This approach goes beyond the limiting nature of traditional pivot tables by enabling power users to transverse dimensions using custom formulas that are a mix of MDX with traditional Excel functionality.
[Read the rest of this article...]
William E. Pearson III posted on May 07, 2010 08:18
Support conditional formatting for enterprise reports from the Analysis Services layer of the integrated Microsoft business intelligence solution. BI Architect Bill Pearson leads hands-on practice with the steps involved.
[Read the rest of this article...]
|
|
|
|
|
|
| |
|
|