Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
ADDING CURRENCY TO TITLE BASED ON PROMPTS
How can I add CURRENCY SIGN TO TITLE BASED ON PROMPTS ?
LIKE THIS ONE : https://ibb.co/TMj5mXf but it should changed by prompts to another currency also (like gbp)
Answers
-
I'm not able to view your link but I imagine I know what you're referencing. You have to define your prompt as a Presentation Variable (ex. PV_CURRENCY). When you are editing your graph's title, you will then reference the Presentation Variable in the Title (ex. Graph of Spending in @{PV_CURRENCY})
0 -
Thanks!
if I have : USD or EUR in prompt
but I want to represent $ or €
how can I do it ?
0 -
I can't see your link, either.
You can use a variable prompt, perhaps with radio buttons for USD or EUR. The choice will be a pres variable, say P_CURR.In your analysis, include a case statement column like CASE '@{P_CURR}{USD}' when 'USD' then '$' when 'EUR' then '€' , etc.
Use a formatted narrative view for your title that references that column's position.
In the narrative view, set the "number of rows to return" as 1.
0
