Absolute reference to hidden row in special calculations
My calculation
sum(0, @"[P&L].[Resultat før skat].[10400: Turnover service items]"(l(3)), m1)
does not work when my hierarchy is collapsed. Is it possible to modify the fomula to find the value when hidden in a collapsed hierachy in any way?
0
Comments
Hi Jonas,
TARGIT client based calculations generally require data, upon which they are based, to be present in the object.
Hiding values with visibility settings or with visibility agents are ok - values will still be available for calculations.
But collapsing a hierarchy will perform a new data query, and data on the collapsed levels will no longer be available for calculations.
BR / Ole
Hi Ole,
That requires we work around with a hidden user dimension for that specific calculation, I suppose?
Regards,
Jonas
Please sign in to leave a comment.