Skip to Content
Author's profile photo Christian Schäfer

Dynamic Chart Labeling by Using Prompts

The starting situation is as follows. I’ve used multiple columns (universe -> odbc -> excel) for my organizational units (main department, department, group, cost center).

For Filtering the database I’ve set up some command prompts as you can see in the following picture.


For a dynamic chart label showing you on which layer you are at the moment depending on what you’ve chosen at the prompts:

Right Click on the chart you want to format -> Format Chart… -> Title –> Title Label -> fill in the statement below!

=”YOUR_TEXT ” + UserResponse(“Main Department:”) + (If UserResponse(“Main Department:”) = “” Then “” Else (If UserResponse(“Department:”) <> “” Or UserResponse(“Group:”) <> “” Or UserResponse(“CostCenter:”) <> “” Then “, ” Else “”)) + UserResponse(“Department:”) + (If UserResponse(“Department:”) = “” Then “” Else (If UserResponse(“Group:”) <> “” Or UserResponse(“CostCenter:”) <> “” Then “, ” Else “”)) + UserResponse(“Group:”) + (If UserResponse(“Group:”) = “” Then “” Else (If UserResponse(“CostCenter:”) <> “” Then “, ” Else “”)) + UserResponse(“CostCenter:”)

You can easily port this method for every dimension you want to be shown in the chart label by using prompts for other dimensions and adapt the statement for example like this: dimension KPI with prompt text “choose kpi:” -> UserResponse(“choose kpi:”)

That’s it. You now have a dynamically changing chart label depending on what you’ve chosen at the prompts.

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.