OBIEE - static text view to display presentation variable — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE - static text view to display presentation variable

Received Response
182
Views
1
Comments
aPsikus
aPsikus Rank 6 - Analytics Lead

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.

Answers

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    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.