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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

What are some alternatives?

share|improve this question
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

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


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.