You can set up a presentation variable:
And you can use it then in many places : OBIEE - Where can I use a presentation variable ?
@{MyPresentationVariable}{MyDefault Value}
@{myYear}{max(Time.Year by)}
Which means:
In 10G, the dashboard prompt is the only way to set a presentation variable. With the advent of 11G, you can now set a presentation variable with the help of a variable prompt
When the dashboard or variable prompt is used in a dashboard, the variable is simply set with the new value.
When you create a dashboard prompt, you have in the column “set variable” the choice between two values :
10G
11G
This functionality does not exist at the moment.: OBIEE 11g: How To Set the Value of a Presentation Variable Using Javascript