Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

New to OLAP & Pivot Tables(Excel)

New to OLAP & Pivot Tables(Excel)

New to OLAP & Pivot Tables(Excel)

I currently have a 1/2 doz spreadsheets - containing 1 to multiple pivot tables included.

The Problem is that their current datasource is an ODBC link to MS Access Database.  I was wonder if I was to change the datasource to OLAP CUBE, what problems could I expect.  I do not want to modify the pivot table's layout - they can be very complex.

I am new to OLAP and I am confused to they replace and act as a query woul for an ODBC connected datasource.

Or should I do a data dump into an Excel wksht and would that affect my current pivot table layout?



RE: New to OLAP & Pivot Tables(Excel)

Think of the OLAP cube as a type of database.  THe main difference is that rather than tables and columns you Have Dimensions and Facts, and hierarchies within the dimensions.  

I doubt it would be as simple as changing your datasource to be an OLAP cube.  THe main reason for this is that the MDX query language is used to query the cubes and is generated when you slice and dice in pivot tables.

Shoot Me! Shoot Me NOW!!!
                           - Daffy Duck

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close