x

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

Yuzu gravatar image

Yuzu
3 1 1 1

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

Queue gravatar image

Queue
250 2 2 3

(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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1951
x945
x174
x2

asked: Apr 28, 2010 at 12:03 PM

Seen: 2008 times

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