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

Essbase variables are slower than direct reference

edited Mar 25, 2024 9:27AM in Planning 9 comments

Hi All,

Can some one examine my two scripts carefully and help me understand why using Essbase variable is slower than direct reference of the cross dimension.

Please note that "Rates_CrossDim" is combination of default members from each dimension. For simplicity, I've denoted it as "Rates_CrossDim". In this scripts my currency dimension is a sparse dimension, where users input data in USD_Constant, and the rest of the currencies are calculated based on this. To perform this calculation, I've employed techniques such as fixing source members, fix statements, and writing calculation logic on the left-hand side of the equation in a dense block. This approach was suggested by

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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