2 Replies Latest reply: Jun 7, 2013 6:42 AM by 975040 RSS

    Calc Script to MDX member formula

    975040
      Hello ASO brain trust

      I am trying to move a calc script to ASO member formulas. Many of the pieces of the calc script are UDA driven.
      BSO

      ELSEIF(@ISMBR(@UDA("Entity","NR_U41110")))     
           "U41110"=@SUMRANGE("R41100",@UDA("Entity","S_U41110"))
           + @SUMRANGE("R41200",@UDA("Entity","S_U41110"))

      ASO
      iif (
      IsUDA ([Entity].CurrentMember,"[NR_U41110]"),
      Sum(CrossJoin({"[R41100]"},{UDA([Entity], "[S_U41110]")}))+
      Sum(CrossJoin({"[R41210]"},{UDA([Entity], "[S_U41110]")})),
      0
      )


      This looks good but it won't parse.

      Any ideas how to get around the fact that the UDA function does not work well with CrossJoin or Sum. Assuming it's formatted properly.

      Thanks