SSAS Articles 
MDX MDX ratio of "current parent" issue
MDX MDX ratio of "current parent" issue
| MDX ratio of "current parent" issue |
| Written by Darren Gosbell |
| Saturday, 26 July 2008 16:27 |
|
Every now and then on the SSAS MSDN forum, the issue of doing a generic "ratio to parent" calculation comes up. Unfortunately there are a number of problems with the premise of giving users a generic "ratio to parent" measure. The first is that the concept of "parent", by definition, requires a hierarchy and SSAS 2005 supports multiple hierarchies. Consider this query: Read more... |
Tags: 2005, article, mdx
Latest Author Articles
- SSAS: Creating a Rowset action with the ExecuteSQL .Net stored procedure
- SSAS: Executing Arbitrary SQL queries
- SSAS: Powershell to replace a group member in a role
- SSAS: T-SQL Equivalent for a Many-to-Many relationship
- SSAS: There is no such thing as an Attribute in MDX!
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Passing MDX parameters in Reporting Services reports
- SSAS Tutorial: SQL Server 2005 Analysis Services Tutorial by Accelebrate
- SQL Server Data Warehouse Cribsheet
- Using AS Data Mining to Add Forecast Values to a Cube
- Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
- Using UserName to Control Data Access and Default Member in SSAS 2K5 (Carrie Williams)
