Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Apparently this feature was available in previous versions but has now been removed.

What are some alternatives?

share|improve this question
2  
You could try using Excel. This will let you open a pivot table over an OLAP data source. It will inherit subtotals from calculations in the cube. –  ConcernedOfTunbridgeWells Jan 15 '13 at 13:21

1 Answer 1

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.