Retrieving data from the dim tables of a data model in a flat table

[LucaA]

Hi,

i have a "star scheme" data model and i would like to extract the full database and send it as a flat table.

I have selected in a pivot (connected to the data model) information coming from several dim tables and when i did the drill-down i expected to see also the fields (In columns) from dim tables selected but in the tables i only found fields coming from the fact table. 

How i can retrieve the fields coming from the supporting tables in a full flat table?

thanks

Luca

[LucaA]

Up. Please someone can help? is not possibile to not be able to retrieve info from dim tables in a flat table i suppose (hope)

[daxer-almighty]

In SSAS you could use the DETAILROWS function that is a property of a measure, I think. In there you could define which columns you want to retrieve if a user double-clicks a measure in Excel. Not sure if this helps, though...