Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1221
  • Last Modified:

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
0
jkeagle13
Asked:
jkeagle13
1 Solution
 
Rainer JeschorCommented:
Hi,
this details are defined in the cube in the drill-trough action. By default its just the keys of your fact.
How to change:
http://www.bidn.com/blogs/DevinKnight/ssis/2212/performancepoint-%E2%80%93-using-ssas-actions

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

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now