Hyperion Essbase (MOSC)

MOSC Banner

Need help optimizing Essbase calc script to AGG sparse dimension

edited Mar 31, 2016 4:08PM in Hyperion Essbase (MOSC) 15 commentsAnswered

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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center