Essbase variables are slower than direct reference
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
1