Convert Essbase formulas to MSAS MDX

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » SQL Server Newbies » Convert Essbase formulas to MSAS MDX

Convert Essbase formulas to MSAS MDX

Rate Topic

Display Mode

Topic Options

Author

Message

santade

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

« Prev Topic | Next Topic »

Permissions