Need help optimizing Essbase calc script to AGG sparse dimension
Hello,
We have an Essbase database with a large Products hierarchy dimension. It's a fairly ragged dimension but all the members are just stored and aggregate as + to the next level. So the nightly default calc script use this syntax to AGG the sparse dimensions:
Set FRMLBOTTOMUP ON;
AGG ("Products");
Set FRMLBOTTOMUP OFF;
This works fine but we've started to add an alternate hierarchy within the Products dimension. The AGG also rolls up the alternate hierarchy fine, but I have these "other" members that need to be calculated as a plug for each category. So I use this code after the first AGG: