Help me to create a dynamic subset.

[initm1]

Hi everyone, in a CubeViewer Perspectives I am trying to create a subset where [measure dimension name].[element name] = 'x'.
If this is possible please guide me.

thanks!

[qml]

Why do you need this subset to be dynamic? If the selection criteria are that the element name is 'x' then surely a static subset should be enough?

[declanr]

I assume the OP means when the contents of a cube cell is X for the given measure, in which case something like below will do it:

Code: Select all

{Filter({[MyDimName].members},[cubename].([dim1].[element1],[dim2].[element2],...,[measuresdim].[measureelement])="X")}

[initm1]

thanks for quick reply. Do I need to use this function/syntax in TI or Excel Viewer Subset editor.

[initm1]

Why do you need this subset to be dynamic? If the selection criteria are that the element name is 'x' then surely a static subset should be enough?

Well I don't have option to manually filter element because this is measure dimension with children.