Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Convert Essbase formulas to MSAS MDX Expand / Collapse
Author
Message
Posted Thursday, March 21, 2013 9:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse