I know I can use Presentation variables to change column headers, but my Essbase Substitution Variables are Repository Variables and that just doesn’t seem to work.
Now the first thing one might ask is why not use a pivot with periods as columns. Well like most clients there is a particular view they wanted and there were other columns needed that are not shown.
So after some noodling and playing around I came up with an option. Use a Dashboard Prompt to set a Presentation Variable and use the Repository Variable to set the default value of the prompt.
I used the Presentation Variable to set the Custom Heading for the column.
This little analysis was then embedded in a dashboard and working with Dashboard Properties add the dashboard prompt is hidden.
The dashboard looks like this. Notice that the 3rd column has the proper month name showing.
Thanks and until next time.