Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Dynamic Column Heading based on Column Values
Good Day Experts,
Is there a way to dynamically rename column heading based on a specific field value?
The scenario I have is like this:
If <TYPE> = 'value1' THEN column_heading_name equal to 'Units'
If <TYPE> = 'value2' THEN column_heading_name equal to 'Quantity'
Let me know if you need further details.
Thank you.
Answers
-
What exactly do you want to achieve? I'm not sure if I understand what you're trying to do here. What would happen if you have both values returned in your data set? Or are you creating 2 columns from this column based on the CASE statement that you provided?
0 -
Hello Joel Acha,
I am only using 1 column for this.
I have a requirement that the column header name of this attribute should change to:
1. 'Units' if column_type = 'Units' or
2. 'Quantity' if column_type = 'Quantity'.
Thank you for your reply.
0 -
The point I tried to make earlier is what if you return data that has not values in that column? What would be the heading in that instance?
0 -
Hello,
It will always have values (column_type) in that column since it is a required column.
Thank you.
0 -
I just have to ask / say this out loud for the sake of my own mental sanity:
Does whoever designed that "data model" beneath have any idea of how databases work in the first place?!
Such a "requirement" is at the same time hilarious and makes one lose faith in mankind at the same time.
0 -
Hello Sir Christian,
Thank you for your input sir.
May I request please to kindly confirm if this requirement is feasible to do in analysis report (dynamic column heading base on a specific value)?
Thank you again.
0 -
In order to "solve" this "requirement" you'd need to be more specific. Is the value of column A driving the header column B? Or is the value of column A driving the header of column A?
If the latter...How can you be certain that only 1 value is ever present?
While technically doable, this is pretty counter-intuitive and dirty with regards to any development standard. Let alone "analytics" as a concept in and of itself.
0 -
Hello Sir Christian,
The value of columnA is the one who will dictate what would be the column header name of columnB.
Wherein columnA will be put in the 'Section' part in the pivot table:
Also attaching the report layout I want to achieve.
Thank you very much.
0 -
Use BIP or Excel. What you're doing isn't analytics. It's pixel-perfect reporting.
0 -
Hello Sir Christian,
Thank you for your input.
Yes I am more of a BI Publisher guy and it can be done using that tool.
0
