Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
We have a requirement, where in the expression, we have to ignore the dimension in the cyclic group in set analysis expression.
Suppose, the expression is sum({<dim1=>}vol), where the dim1 is present in cycle1.
So, we need something like -
sum({<GetCurrentField([cycle1])=>}vol)
We need it as there are around 6 dimensions, can anyone pls suggest.
Thanks & Regards,
MK
try with
sum({ $ <cycle1=>}vol)
nope, doesn't work...
I tried sum({ $ <cycle1=>}vol)
sum({ $ <[cycle1]=>}vol)
sum({ $ <(cycle1)=>}vol)
nothing work....
Hi
Try with '$' sign in set analysis as suggested by Alexandros17
can you please provide link for same...
Hi
Can you share sample application.
And you want to ignore dimensions in cyclic group ???
Your requirement is unclear for me .Can you please elaborate
Thanks
sum({<[$(=GetCurrentField([cycle1]))]>}vol)
try,
=sum({<$(vExclude)>}Sales2)
where vExclude = getcurrentfield([YourCyclicGroupName])
This might work
Try this(replace group field with yours) -
=Sum({<$(=GetCurrentField(Year_Month))=>}Sales)