Need help on MDX - Essbase ASO
Summary
Need help on MDX - Essbase ASOContent
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
0