Modify Columns on "Show Details" Window for PerformancePoint


I have some data that I have in SQL. I set up a cube in Business Intelligence Developer. I have link to the Analysis Service with PerformancePoint. Everything is working well with my charts, decomposition trees, etc. It is all perfect.

Except, when users drill-through to see the data by clicking on "Show Details" from the right-click menu, the window that pops up only lists the primary key I have. So, I get a list of numbers. I know it is the primary key because I can reference to the primary key field and see that those are indeed the records comprising the view.

So, that is fairly useless to a user. I don't mind leaving the primary key in the "Show Details" view. How do I add other columns? I want to show the entire tuple, or at least additional columns to provide context for the user. I have searched and messed around with both the cube and PerformancePoint and appear to be missing something. Everything else is working 100% - this shouldn't be so difficult.

I am using PerformancePoint in SharePoint 2010 on top of SQL Server 2008 R2.

Thank you,
Joseph Irvine
Who is Participating?
Rainer JeschorConnect With a Mentor Commented:
this details are defined in the cube in the drill-trough action. By default its just the keys of your fact.
How to change:

From my experience a workaround (which worked for PPS2007) has been:
Define a Drill-through action in the cube and name it "Show details".
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.