Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 50 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI 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