Essbase Olap Server [Archive]

ken_ken

05-27-02, 06:57

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.

thanks

vitbel

06-30-02, 09:40

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)