MDX Queries - Misc

I have always find it difficult to have some examples ready to query using MDX. Here are some examples and will be adding more:

To get the leaf level members:

SELECT 

             {[Time].levels(0).members} 

ON ROWS

To get all members of one dimension:

SELECT 

             {[Time].members} 

ON ROWS

To get asymmetric columns:

SELECT {

([Dim1 Member1],[ Dim2 Member1]),

([Dim1 Member2], Dim2 Member2)

} ON COLUMNS

Calculation Manager: Enable Parallel Execution - Bug and Trick

When creating new Ruleset Designer there is an option to execute rules in parallel as given in the following screenshot.

However, as soon as you add / assign Rules under this ruleset, it disappears.

Note that this option is only available when the ruleset is selected and not the individual rule. So, you need to select / click on the ruleset to get this feature.

I believe this to be as a bug however there are at least two ways to get this option back.

• Save and close the ruleset and reopen.
• Another option is go to another tab in workspace and come back to this ruleset and you will see the option visible / enabled.