Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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
191
Views
1
Comments
aPsikus
aPsikus Rank 6 - Analytics & AI Lead
edited Aug 13, 2024 5:25PM in Oracle Analytics Forum

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 & AI 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.