13 Replies Latest reply on Sep 3, 2010 1:24 PM by garycris

    Can I do a self reference of an Account dim member in MDX member Formula ??

    781502
      My problem is :

      I need to do a self reference of an account member.
      and the track is:
      - 11.1.1.3 Essbase ASO Cube.
      -Accounts Dimension has a level 0 member called "Balancesheet"

      The hierarchy structure is:
      Account
      -level2(+)
      -level1(+)
      -Balancesheet(+)

      I am trying to put the below MDX member formule on "Balancesheet"
      --------------
      CASE ([year].CurrentMember)
      WHEN [FY10]
      Then
      Case ([Period].CurrentMember)
      When [JAN]
      Then
      <Some logic here, pulling some other member here and is working fine>
      ELSE
      ([Balancesheet],[Period].CurrentMember.PrevMember) /* this also is working fine*/
      END
      ELSE
      [Balancesheet] _/* ERROR*/ /* THIS IS WHERE IT IS FAILING AND MAKING THE VALUES '0' for and year other than FY10 */_
      END
      -----------------


      Basically what I am trying o achieve is that I want ASO to workup the logic I am writing above ONLY for FY10 and do nothing for any other year.
      When I dont write the last 'else' part, it makes the values zero for any year other than FY10. so, I tried putting the above logic in the last 'else' part, but it is also failing and giving me "Recursive limit [31] reached error"

      Any help on this greatly appreciated.

      thanks,
      Ankit