Another trick to retrieve dimension data into an Excel table based on my previous posting.
with member [measures].[rowcount] as '1'
select [measures].[rowcount] on 0, [<Dimension>].[<LevelName>].members on 1
from [$<MyDimension>]
Substitute with the dimension you would like to pull data from.
No comments:
Post a Comment