Excel as an OLAP viewer - How to view OLAP details (the grain) in excel
3 posters
Page 1 of 1
Excel as an OLAP viewer - How to view OLAP details (the grain) in excel
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
Re: Excel as an OLAP viewer - How to view OLAP details (the grain) in excel
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
Excel help
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).
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
Similar topics
» duplicated facts against multpile dimensions in MS OLAP control (excel/SSMS)
» Data Integration and ETL is Shifting to the End-User
» Load Complex Excel Sheet
» Deny Excel access to cube
» View or materialized view?
» Data Integration and ETL is Shifting to the End-User
» Load Complex Excel Sheet
» Deny Excel access to cube
» View or materialized view?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|