SSAS Articles 
Data Mining Unwinding MDX Flattening Semantics with DMX
Data Mining Unwinding MDX Flattening Semantics with DMX
| Unwinding MDX Flattening Semantics with DMX |
| Written by Jamie MacLennan |
| Monday, 17 March 2008 00:26 |
|
When issuing an MDX statement in code, you have the option of requesting either a multidimensional set or a relational rowset as the result set. If you are familiar with MDX and multidimensional concepts, the multidimensional result is the obvious choice. However, if your application is more suited to dealing with tabular data, such as Reporting Services, it may be more convenient to request the rowset result. One issue is that it's not always obvious how the MDX flattening semantics will translate the multidimensional set into a flattened rowset. Read more... |
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
- Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
- Handling Multiple Calendars with a M2M Scenario
- Passing MDX parameters in Reporting Services reports
- Using UserName to Control Data Access and Default Member in SSAS 2K5 (Carrie Williams)
- SSAS Tutorial: SQL Server 2005 Analysis Services Tutorial by Accelebrate
