This project has moved and is read-only. For the latest updates, please go here.

DRILLTHROUGH for non empty measures

Topics: User Forum
Nov 4, 2015 at 2:48 AM

I have several measures containing null values, and I want to build a custom action that drillthrough vs. the current measure filtering rows with null value.

I tried the following but it does filter as expected.

Likely basic syntax issue, please note I am beginner with MDX.
+ ASSP.CurrentCellAttributes() 
+ ')} on 0 from [IDS Analytic]'
Nov 6, 2015 at 6:32 AM
Do you have a dimension you can filter by that would filter out nulls? If so tweak your current expression to add a parameter hard coding that filter:

ASSP.CurrentCellAttributes(([Your dimension].[Your attribute].&[Whatever key will filter out nulls]))

If not you will need to follow the very last example on the following page constructing a custom MDX query and including any attributes on rows you want to display as columns.