Link to home
Create AccountLog in
Avatar of jkeagle13
jkeagle13

asked on

Modify Columns on "Show Details" Window for PerformancePoint

Hello,

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
ASKER CERTIFIED SOLUTION
Avatar of Rainer Jeschor
Rainer Jeschor
Flag of Germany image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer