Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002

    Unanswered: Essbase Olap Server

    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.


  2. #2
    Join Date
    Jun 2002
    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)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts