Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Presentation Variable in Column Formula
user 1208988
Rank 3 - Community Apprentice
Hi All.
I have this requirement to show multiple values of presentation variable in separate rows in a table or pivot.
For example, if I select three department names from dashboard prompt, the table/pivot will populate three rows representing a department.
The column I am trying to populate is not modeled, it's SELECT_PHYSICAL query (to create the prompt).
And then presentation variable in column formula of analysis.
Result at the moment looks like Dept1,Dept2,Dept3 all in one row.
My need is to show
Dept1
Dept2
Dept3
Thanks
0
Answers
-
If you need rows then filter your query and it will bring back.....rows. That's how the tool works.
0 -
May be tell us the actual business requirement?
0 -
"Splitting a string into rows" I guess. Which is fun every time someone asks this
0