You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BSO Member Formula to ASO MDX

Received Response
18
Views
3
Comments
edited Aug 2, 2018 2:36AM in Essbase 3 comments

Summary

BSO Member Formula to ASO MDX

Content

Hello Experts

I have an ASO cube that is an actuals reporting cube based out of my BSO Cube.

I am converting BSO member formulas to MDX.

What I have noticed is my MDX Script works for the zero/month level but not at the upper levels of qtr1,qtr2...Full Year.

PLEASE ADVISE

Q1-April,May,June
Q2-July,august,September.

BSO FORMULA

IF(@ISMBR(April_2010))"CDN DS CHG"/.1;
endif;
IF(@ISMBR(May))"DS DTIP"/.2;
endif;
IF(@ISMBR(June))"DS DTIP"/.3;
endif;
IF(@ISMBR(July))"DS DTIP"/.4;
endif;
IF(@ISMBR(August))"DS

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!