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

    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.

    thanks

  2. #2
    Join Date
    Jun 2002
    Posts
    4
    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
  •