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
- 18 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Organization Hierarchy: using the value of one field as the heading for another.
If the content of the field "Organization Hierarchy"."Level 01 Organization Classification" is "Division",
how can I use this content to be the column heading for "Organization Hierarchy"."Level 01 Organization Name"?
Answers
-
You can't have a dynamic column name based upon data
0 -
Not sure exactly as the design goes…
but could you just create two columns
"Organization Hierarchy"."Level 01 Organization Classification" is "Division"
"Organization Hierarchy"."Level 01 Organization Name"
each has the column name you want to display.
Used advanced suppression, if
"Organization Hierarchy"."Level 01 Organization Classification" is "Division"
suppress the column
same on other column, just opposite way so it suppresses
"Organization Hierarchy"."Level 01 Organization Name"
if
"Organization Hierarchy"."Level 01 Organization Classification" is NOT "Division"
So in summary, create the two columns with two different headings, use avandced suppression on each column to determine which column you show in what scenario.
Maybe that can work.
0 -
OTBI does not support direct column-heading substitution from another column value.
However, I think you can try using a presentation variable populated via an EVALUATE SET VARIABLE expression and referenced in the column heading. Hope it helps!0
