Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

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

3 posters

Go down

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

Post  rahm0277 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

Back to top Go down

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

Post  hang 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

Back to top Go down

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

Post  KeithL 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

Back to top Go down

Excel as an OLAP viewer - How to view OLAP details (the grain) in excel Empty 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

Back to top

- Similar topics

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