Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Posts
    7

    Question Unanswered: Difference between olap cube and Pivot tbl?

    Could someone explain for me the difference between an olap cube and a pivot table ? Are they not both the same type of mechanism for representing/viewing multi-dimentional data ?

    Thank you,
    Warren.

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091

    Re: Difference between olap cube and Pivot tbl?

    Originally posted by warba
    Could someone explain for me the difference between an olap cube and a pivot table ? Are they not both the same type of mechanism for representing/viewing multi-dimentional data ?

    Thank you,
    Warren.
    Not really. OLAP databases organize the data into dimensions and levels (rather than rows and columns) within the server, summarizing first, then sending the summary values to your computer. Excel saves the info from the database locally in files called OLAP cubes, which then becomes the source for a PivotTable. Thus, you can think of OLAP cubes as an intermediary between the original data and the resulting PivotTable. BTW, the PivotTable operates differently with OLAP data and Excel lists (or non-OLAP databases).
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Nov 2003
    Posts
    7

    Smile

    That makes sense. Thanks.

  4. #4
    Join Date
    Oct 2003
    Location
    Boston, Mass. USA
    Posts
    81
    So ... this sounds like ... if you have a huge database and you want summaries it sounds like the OLAP method is better (faster) as it does the summarizing (sum, count, etc.) on the server side rather than dragging all the data across the network to the local machine before doing any summary math?

  5. #5
    Join Date
    Aug 2003
    Posts
    29

Posting Permissions

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