DRILLTHROUGH for non empty measures

Topics: User Forum
Nov 4, 2015 at 1:48 AM
Hello,

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.
'DRILLTHROUGH MAXROWS 500 SELECT NON EMPTY{(' 
+ ASSP.CurrentCellAttributes() 
+ ')} on 0 from [IDS Analytic]'
Coordinator
Nov 6, 2015 at 5: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.
https://asstoredprocedures.codeplex.com/wikipage?title=Drillthrough&referringTitle=Home