Oracle Transactional Business Intelligence

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

Categories

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

Format prompt selections

Received Response
61
Views
4
Comments
User_EQ8R5
User_EQ8R5 Rank 3 - Community Apprentice
in Oracle Transactional Business Intelligence

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?

Tagged:

Answers

  • Arun Raj
    Arun Raj Rank 5 - Community Champion

    how about using UPPER key word to force any selection to be in upper case?

  • User_EQ8R5
    User_EQ8R5 Rank 3 - Community Apprentice

    I think that would probably work but I'm not sure how to use the upper formula in a prompt.

  • Chris Dabel
    Chris Dabel Rank 2 - Community Beginner

    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
     

  • User_EQ8R5
    User_EQ8R5 Rank 3 - Community Apprentice

    Thanks!