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

MDX help - Sum of prior quarters

edited Aug 2, 2018 2:36AM in Essbase 1 comment

Summary

MDX help - Sum of prior quarters

Content

Hi All,

Could you please light on the below ASO member formula request.

Need a formula which should be a sum of @idescendants (Accoun1) in Q2 - sum of @idescendants (Account 1) in Q1 (previous quarter).

Currently I have tried the below formula on "ACCOUNT 2" but its taking more than 6 mins when executing from smartview (validation sheet contains quarters for 2 years, ie 8 quarters).

Also I have used a higher Solver Order for Account 2 as 20 which is the highest in the current outline. Also "Account 1" is just a Parent for shared account members under it.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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