Let's consider that we have dimension with following properties: Label, Name, Description. We'll call this dimension Department and we'll populate it as follows:
Label Name Description
1001 1001 CEO
1002 1002 VP
etc.
So, what happens when we select this dimension in Excel Add-in? Add-in will select Label as default property and you would get something like this:
As you can see, Labels are displayed instead of some meaningful text. What we can do? Go to PerformancePoint pane in Excel, select dimension and from the drop-down list choose option "Select Properties":
In "Select Dimension Properties" dialog box, select properties you would like to be displayed (e.g. in our case we want to display Description property):
Close the dialog and click Refresh in the PerformancePoint pane. Voila, we get what we wanted :)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment