Hello,
I created a cube, and when I show the dimensions using the PivotTable control and Excel 2007, I would like to be able to show the dimensions groupped in Folder as we can do with attributes, and measures.
Does SQL Server 2005 analysis services support that ? or some suggest how could i do it?
I hope you can help me....
Thank you!
Sorry, but this can't be done. Dimensions are a top level object.
If you are using the Enterprise Edition and you have lots of dimensions, you could use the perspectives feature to create different perspectives with sub sets of the dimensions. The only problem with this is that perspectives appear to a lot of client applications like separate cubes and as such it is not always easy to swap between them with these applications.
|||Hello Darren,
I'll read about Perspectives.
Thanks for the TIP 
No comments:
Post a Comment