Modify Columns on "Show Details" Window for PerformancePoint
Posted on 2013-06-06
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.