March 21, 2013 at 9:46 am
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
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply