Convert Essbase formulas to MSAS MDX

• santade

  SSC Enthusiast

  Points: 144

  More actions

  March 21, 2013 at 9:46 am

  #275412

  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