Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Need help on MDX - Essbase ASO

edited Aug 2, 2018 2:36AM in Essbase 8 comments

Summary

Need help on MDX - Essbase ASO

Content

Hi,

I've a member formula to copy FY15, Aug, 10100, TBTot value to FY16, Sep, ABC, DEF. I tried the below scripts.

The first script worked, but it was copying for all the years. I tried the second script. It was validated successfully but was not copying the numbers.

Could you please help me to correct the script to achieve the requirement?

Case When ([Period].CurrentMember is [Sep]) then ([FY15],[Aug],[10100],[TBTot]).Value End - Worked

Case When ([Period].CurrentMember is [Sep] and [Years].CurrentMember is [FY15]) then ([FY15],[Aug],[10100],[TBTot]).Value End

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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