Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Show properties in excel report from a tabular report Expand / Collapse
Author
Message
Posted Friday, April 05, 2013 1:38 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 4:07 AM
Points: 849, Visits: 768
Hi guys, I have created some of our OLAP cubes in a tabular model. One of the things we need is to be able to show the properties of a 'dimension' in a pivot table in excel. How do I get it to show these properties?

Ian Cockcroft
MCITP BI Specialist
Post #1439120
Posted Tuesday, October 29, 2013 12:37 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 29, 2013 12:57 PM
Points: 1, Visits: 1
Ian,

Did you find an answer to your question? I am dealing with this same issue.

I rebuilt an old multidimensional cube using a tabular model, and I can't figure how to add properties in Excel pivottables or in the pivottable tooltips.

Please share if you have work around.

Thanks,

Scott Nei
Post #1509532
Posted Tuesday, October 29, 2013 1:35 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 4:07 AM
Points: 849, Visits: 768
hI SCOTT, no, afraid not.
canned tabular.
sorry


Ian Cockcroft
MCITP BI Specialist
Post #1509549
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse