How I can drill down an aggregate member?

Hi, I'm quite new using SQL Server Integration and Analysis services. I'm using a Dashboard in Performance point. There's a column that is an aggregate member and sums 4 other members but when I tried to drill down to this 4 members I can't. Is there I way I can do this? Do I have to create a new hierarchy? Thank you.

more ▼

asked Apr 28, 2010 at 12:03 PM in Default

avatar image

3 1 1 2

The Main problem was that calculated members cannot be drill down, but it helped a lot the answer.

May 05, 2010 at 04:13 PM Yuzu
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Hi, If you can, try creating a drill through action in ssas cube side and see if you can show it in the performance point dashboard.

Check out, http://msdn.microsoft.com/en-us/library/ms178458(SQL.90).aspx

more ▼

answered Apr 28, 2010 at 04:49 PM

avatar image

250 3 4 6

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Apr 28, 2010 at 12:03 PM

Seen: 2236 times

Last Updated: Apr 28, 2010 at 12:33 PM

Copyright 2018 Redgate Software. Privacy Policy