question

Yuzu avatar image
Yuzu asked

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.

sql-server-2005ssisssasperformance-point
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Yuzu avatar image Yuzu commented ·
The Main problem was that calculated members cannot be drill down, but it helped a lot the answer.
0 Likes 0 ·

1 Answer

·
Queue avatar image
Queue answered

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

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.