General OBIEE

Get Involved. Join the Conversation.

Topic

    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 
    63 Views, 4 Comments
    Title:
    Format prompt selections
    Summary:
    Add specific formatting to prompted selections
    Content:

    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

    Hi,

    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

    Thanks,
    Chris Dabel
    Oracle Fusion Support
     

    Comment