Page 1 of 1
Help me to create a dynamic subset.
Posted: Fri Jul 01, 2016 12:42 pm
by 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!
Re: Help me to create a dynamic subset.
Posted: Fri Jul 01, 2016 2:42 pm
by 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?
Re: Help me to create a dynamic subset.
Posted: Fri Jul 01, 2016 3:24 pm
by 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")}
Re: Help me to create a dynamic subset.
Posted: Fri Jul 01, 2016 3:59 pm
by initm1
thanks for quick reply. Do I need to use this function/syntax in TI or Excel Viewer Subset editor.
Re: Help me to create a dynamic subset.
Posted: Fri Jul 01, 2016 4:48 pm
by initm1
qml wrote: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.