Log in  ::  Register  ::  Not logged in

 Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 Convert Essbase formulas to MSAS MDX Rate Topic Display Mode Topic Options
Author
 Message
 Posted Thursday, March 21, 2013 9:46 AM
 Forum Newbie Group: General Forum Members Last Login: Monday, April 22, 2013 12:06 PM Points: 2, Visits: 5
 Folks,I have a cube in Essbase that need to be converted to MSAS - all structure works fine in AS but I have problems to convert Essbase formulas to MDX.This is my Essbase formula:IF (@ISLEV(BCK,0) and @ISLEV(LTV,0) and @ISLEV(MOB,0) and @ISLEV(SCR,0) and @ISLEV("Total Product",0) and @ISLEV("ClassID",0) and @ISLEV("Status",0))C_ENR_BAL+C_BSL_CCF_FNL*C_TOT_UNUSD;ELSE@SUM (@CHILDREN (@CURRMBR (BCK)));@SUM (@CHILDREN (@CURRMBR (LTV)));@SUM (@CHILDREN (@CURRMBR (MOB)));@SUM (@CHILDREN (@CURRMBR (SCR)));@SUM (@CHILDREN (@CURRMBR ("Total Product")));@SUM (@CHILDREN (@CURRMBR ("ClassID")));@SUM (@CHILDREN (@CURRMBR ("Status")));ENDIF;I´ve tried to convert without success:IIF ([BCK].CURRENTMEMBER.level = 0 and [LTV].level.ordinal = 0 and [MOB].level.ordinal = 0 and [SCR].level.ordinal = 0 and [Total Product].level = 0 and [Class ID].level = 0 and [Status].level = 0, ([Measures].[C ENR BAL]+[Measures].[C BSL CCF FNL])*[Measures].[C TOT UNUSD], SUM({[BCK].children, [LTV].children, [MOB].children, [SCR].children, [Total Product].children, [Class ID].children, [Status].children}) )Can anyone help me?Thanks in advance,Gustavo
Post #1433876

 Permissions