snippetMinor
How do I display subtotals in cube browser in SSAS 2012 (Sql Server Data Tools)?
Viewed 0 times
2012sqlbrowsersubtotalstoolscubehowserverdisplaydata
Problem
Apparently this feature was available in previous versions but has now been removed.
What are some alternatives?
What are some alternatives?
Solution
That's right. The cube browser control within SSDT is completely different to the one that used to exist in BIDS2008 or lower. This had me going at first too. The best way i found to get around this was to launch into excel, which can be done from the cube browser tab.
I believe it even creates a temporary connection file for you too so you don't have to create that yourself. Then all you need to do is create a pivot table to display the data how you want.
I believe it even creates a temporary connection file for you too so you don't have to create that yourself. Then all you need to do is create a pivot table to display the data how you want.
Context
StackExchange Database Administrators Q#30259, answer score: 3
Revisions (0)
No revisions yet.