Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

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

Inline Prompt Issue

Received Response
11
Views
5
Comments
KashSidd
KashSidd Rank 5 - Community Champion
in Oracle Business Intelligence Applications

Hi,

I was trying to display an inline prompt on top of an analysis and it works fine using Presentation Variable but if the Prompt is not selected then it leaves the variable name as is "@{PTable}" which Users dont want so is there a way to not show anything if not selected

OBIEE Version: 12.2.1.3.0

Thanks,

Kash

Answers

  • Christian Berg-0racle
    Christian Berg-0racle Rank 10 - Analytics Guru

    CASE WHEN '@{PTable}{SomeRandomDefault}' = 'SomeRandomDefault' THEN 'WhateverYouWantToShow' else '@{PTable}{SomeRandomDefault}' END

  • KashSidd
    KashSidd Rank 5 - Community Champion

    Nice and let me try

  • KashSidd
    KashSidd Rank 5 - Community Champion

    I tried the CASE statement but its not working and can you elaborate as to how it would be used? I am using a Static Text box on top of the analysis?

  • Christian Berg-0racle
    Christian Berg-0racle Rank 10 - Analytics Guru

    In a static text view you can only show the variable itself. Not the whole formula.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    No reason you couldn't make your default value the thing you wanted to show, and change the filter on that column using a case statement to change it to the column in question (so it is always equal itself - if you want your default to show all values!)