User Dimension for Benchmarking

Another special usage of a User Dimension is the benchmarking analysis.

In this case you will want to compare, or benchmark, a selected dimension member to all the other dimension members within the same dimension.

To do this, you can work with a user dimension with two members: One user dimension member to always show all dimension members, and another user dimension member to only show the selected (benchmarked) dimension member.

In fact, both members are created as members without criteria. To create such a member, you simply click “OK” right away in the Add criteria dialog you see when adding a new User Dimension member:

mceclip0.png

You should probably rename the two members to e.g. “All” and “Selected”. Remember to check/remove translations as you do so.

Furthermore, the All member should be set to ignore criteria coming from the dimension we will use for benchmarking. This is to make sure that the All member always shows all members from the dimension.

mceclip1.png

The other member, the Selected member should be set up as a member without any criteria or criteria options at all. In this way, it will always respond to whatever criteria (global, local, drill down) is applied to the object.

In the example below, Justen Cartwright has been selected as a global criteria for the drop down list in the criteria bar.

The two columns in the crosstab represents the two members of the benchmark user dimension. Notice that the All column shows all salespersons (due to the ignore setting), and that the Selected column only shows data for the selected salesperson.

mceclip2.png

The bar chart is actually just a copy of the crosstab. The visible bars are based on the All column. To hide the Selected column in the bar chart, you can work with Visibility to hide the second element in the benchmark user dimension.

mceclip3.pngmceclip4.pngmceclip5.png

In this case, the second element of the user dimension is used only to identify the Selected dimension member and to add a color agent to that dimension member.

mceclip6.png

Was this article helpful?
0 out of 0 found this helpful

Comments

1 comment
  • Hi,

    I can't get this to work for me.

    I created a user dimension Test.

    Added 2 members without selecting anything.

    Renamed 1 member from Total1 to Selected

    for Total ignored dimension on Items-Article Groep

    click on OK and then again on OK and got message:

    But i don't want to share the test user dimension, I just created it via the tool bar Tools-User Dimension.

     

    Next I tried via the dataproperties pane, called test2:

    clicked on ok and tested

    so why is my selected column not reacting to the selection?

     

    note: I have latest version installed

    0

Please sign in to leave a comment.