Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
narrative for prompted values only
In Answers, on a dashboard, I have 30 column variable prompts. When user prompts 3 fields --- lets say, Fiscal Year, Program Name, Region -- I would like to include narrative at bottom of dashboard page that says ... "The Report above is for FY16 results for March Madness Program in North America" Or "Results are for FY=FY16; Program Name = March Madness; Region = North America.
Since there are 30 column variable prompts, I don't want to see "column a = none; column b = none; FY=FY16; column d = none; Program Name = March Madness; column f = none; Region = North America ... column nth = none?
Can you help me out? Is there a better way than using "narrative" view?
Answers
-
Hi,
I understand that you use Presentation Variable in prompt?
If yes, you can use narrative view.
Write text and put in it something like that: @{variable_name}.
For example:
"The Report above is for @{FY} results for @{Program Name} Program in @{Region}"
0 -
Ugly but you could have a 'dummy' column that builds the narrative text using case statements and concatenation - then narrative only shows 1 row of the one column ...
0 -
Thanks Choracy. I am not sure this'll work as it'll only show data in the first row, just for those particular columns. What if user prompts for two regions and 3 quarters and 4 programs ... the narrartice would only show 1 region, 1 quarter and 1 program. J
0 -
Hi Thomas. Could you screenshot your idea? J
0 -
Something like ...
'The Report above is for ' ||
CASE WHEN '@{FY}' <> '' THEN '@{FY} results for ' ELSE '' END ||
CASE WHEN '@{Program Name} <> '' THEN '@{Program Name} Program in ' || @{Region} ELSE '' END
0