View OLAP cube details in Excel

Is there a way to view the 开发者_StackOverflow中文版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?

Try doubleclicking the aggregate cell that you want to see the breakdown.