Solved

Modify Columns on "Show Details" Window for PerformancePoint

Posted on 2013-06-06
1
1,148 Views
Last Modified: 2013-06-06
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
Comment
Question by:jkeagle13
1 Comment
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 495 total points
Comment Utility
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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now