Anyone here who can help me optimize my Essbase Olap Cube? Its taking quite sometime to calculate...what seems to be the problem??? 4 hours of calculation and only loading 40,000 records. Need your help badly and A.S.A.P.
The aggregation time depends on number of dimensions, number of levels in each hierarchy. You can reduce aggregation time by using dynamic calc. But from my experience for ESS 4 ours is a good time. Also read the "Optimizing Calculations" topic in "Database Administrator's Guide" (HYPERION_DIR/Essbase/Docs/DBAG/dba_html.htm)