Is it possible to access dynamic parent level in calculation?
Gents,
We would like to implement our own "extended measure"
What we need is to able to access parent level of currently being evaluated level.
Example:
WeekSharesP [day_recalc]
On day level:
WeekSharesP = WeekSharesP / WeekSharesP.level([clnd].[week])
On week level:
WeekSharesP = WeekSharesP / WeekSharesP.level([clnd].[mnth])
On month level
WeekSharesP = WeekSharesP / WeekSharesP.level([clnd].[qrtr])
(...)
So basically we want expression like:
WeekSharesP = WeekSharesP / WeekSharesP.level([clnd].**UP** / current+1)
How we can achieve it?
One solution is using multisource but it is very dirty solution and requires creating a lot of unnecessary temporary measures at different levels.
Regards
Piotr