Getting recursive error while retriving data
Summary
Getting recursive error while retriving dataContent
Hi All,
I need help in developing formula for a dynamic calc member in ASO cube.
My requirement is as follows.
Account-- A1,A2, A3
Entity-- E1(Childs--E11,E12,E13),E2,E3
My requirement is when I retrieve data for A2 with E1 as the combination my output should be E1=E11, but when I retrieve data for A1,A3,etc with E1 as the combination my output should be E1=E11+E12+E13 .
I have developed below member formula for E1 but getting error.
Case
WHEN [Account].CurrentMember IS[A2]
Then
0