Excel as an OLAP viewer - How to view OLAP details (the grain) in excel

View previous topic View next topic Go down

Excel as an OLAP viewer - How to view OLAP details (the grain) in excel

Post  rahm0277 on Tue Apr 26, 2011 12:00 am

Is there a way to view the details (the grain) in an OLAP cube in excel? I know excel can already show the measures that are aggregrated, but the users want to see the details... ie the individual grain. So, in my case, the fact table contains order information (order number, the dollar amount, etc). The measures are all aggregrated, but once the user sees an aggregration, they want to be able to see the details of that aggregration. Anyway to do this?

rahm0277

Posts : 6
Join date : 2011-04-24

View user profile

Back to top Go down

Re: Excel as an OLAP viewer - How to view OLAP details (the grain) in excel

Post  hang on Sat May 07, 2011 9:10 am

You should be able to show details if you feed the atomic fact data to the cube and let the cube do all levels of aggregations.

hang

Posts : 528
Join date : 2010-05-07
Location : Brisbane, Australia

View user profile

Back to top Go down

Excel help

Post  KeithL on Sat May 07, 2011 9:31 am

When you are working in Excel with a cube you are working in a pivot table.

To see the lowest grain, they must apply all dimensions associated with the fact table. It is theoretically still aggregated but its aggregating only the grain (lowest level or one fact).

KeithL

Posts : 6
Join date : 2011-05-07

View user profile

Back to top Go down

Re: Excel as an OLAP viewer - How to view OLAP details (the grain) in excel

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum