BSO formula to ASO

@ISMBR(

Summary

BSO formula to ASO

Content

Hi

Can someone help me to convert bso formula to ASO (mdx) formula.We have a dynamic calc member in BSO cube and it works fine there. however we need a siliar formula for ASO cube.

IF (@ISMBR(@IDESCENDANTS("Balance Sheet Accounts")))

    IF(@ismbr("Jan"))

        IF    (@ISDESC("Budget Scenarios"))

            IF    (@ismbr(@member(@substring(@name(@currmbr(Scenario)),6))) )

                @prior("Closing Balance"->&LFScenario->"Dec",1,@levmbrs("Years",0));

            ELSE

                @prior("Closing Balance"->"Dec",1,@levmbrs("Years",0));

            ENDIF

        ELSEIF (@ismbr("Forecast"))

            @prior("Closing Balance"->"Actual"->"Dec",1,@levmbrs("Years",0)) ;

        ELSE

            @prior("Closing Balance"->"Dec",1,@levmbrs("Years",0));

        ENDIF