OBIEE - static text view to display presentation variable

aPsikus

OBIEE 12.2.1.2.0

Creating report. I have added formula in the column:

@{variable_name}{"Folder"."Dimension"}

Now I would like to display it in Static text.

Setting@{variable_name} do not work.

Is it possible to display presentation variable from report column in Static text view? Or it will work only for variables from prompt?

Requirement is: that in the report view there will be table with all required data, and at the top some kind of summary containing values from prompt. But for example in prompt there will be ID to limit the results, but in summary I need to display name, which will not be in prompt but will be as column in results.

Jerry Casey

I don't completely understand your requirements, but I believe that setting the value of a presentation variable can still only be done with a prompt.
It seems like there are a number of ways to do what you've described, such as using a sub-query filter, or hiding a second prompt in the page's dashboard properties.