SSAS 2008 AS2008 MDX: subselects and CREATE SUBCUBE in non-visual mode
| AS2008 MDX: subselects and CREATE SUBCUBE in non-visual mode |
| Written by Mosha Pasumansky |
| Tuesday, 04 November 2008 23:56 |
|
There were not very many changes to MDX syntax in AS2008, and Vidas Matelis described most of them in his blog here (for his list of all changes in AS2008 check this blog entry). I just noticed that there is at least one more change which Vidas didn’t include, but which is somewhat important: ability to define CREATE SUBCUBE and subselects in non visual mode. To understand this, we need to understand what CREATE SUBCUBE does. It really does two things: 1. Implicit Exists between the set in CREATE SUBCUBE and query axis, query named sets including top level set functions (for more details see blog "Slicer and axis interaction in MDX Part 2 - Implicit Exists" – even though it talks about WHERE clause, everything from that entry equally applies to subselects and CREATE SUBCUBE as well) 2. Applies visual totals to the values of physical measures even within expressions if there are no coordinate overwrites. Let’s look into this deeper. Consider the following example: Read more...
|
Tags: 2008, article, subcube, visual totals
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Using AS Data Mining to Add Forecast Values to a Cube
- 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)
