General OBIEE

Get Involved. Join the Conversation.


    Randall Thompson
    Format prompt selectionsAnswered
    Topic posted February 3, 2017 by Randall ThompsonSilver Medal: 2,000+ Points, tagged Customizing Layout, Customizing Reports, Fusion, OBI Answers, OBIEE Answers, OTBI, Report Layouts, Reports, SQL 
    64 Views, 4 Comments
    Format prompt selections
    Add specific formatting to prompted selections

    Is there a way to format the selections that show for prompts? For instance i need to have a prompt that forces all the selection options to be in upper case, is it possible to add a formula to the prompts to show that to the end user?

    Best Comment

    Chris Dabel


    To do this, edit the column prompt > expand Options, expand the dropdown, then select SQL results.

    Then, edit the SQL like this, then save your Prompt/Analysis:

    SELECT UPPER("Folder"."Column Name") FROM "Sales - CRM Pipeline" FETCH FIRST 65001 ROWS ONLY

    Chris Dabel
    Oracle Fusion Support