Tuesday, June 17, 2008

Displaying desired dimension property in Excel Add-in

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 :)


No comments: