This post on OTN (http://forums.oracle.com/forums/thread.jspa?threadID=852758&tstart=15) triggered me to have closer look at the column headings possibilities
Lets start with a simple report (Sample Sales):
To alter the column heading go to Table View Properties:
In the Display Column & Table Headings you have five choices:
Only column headings:
As separate rows
This allows you to customize the column heading over two rows:
As Table.Column
As Table.Column (Where needed)
Doesn't seem to change anything at first glance, but works fine when you have two columns with the same name from different folders:
No column or table headings
Till Next Time
I want to show only one row on report. Is it possible to show column headings vertically and there vale in front of it in OBIEE?. for eg.
ReplyDeleteID 1
Name john
instead regular tabular format of
Id Name
1 john
Why don't you use a narrative view?
ReplyDeleteregards
Thank you. It works.
ReplyDeleteIs there a way to make the table headings show up in a Pivot Table?
ReplyDeleteCraig Not really sure what you are looking for, check if your measure labels aren't set to hidden.
ReplyDeleteregards
John
My pivot table has 10 seperate measures in columns. I want to display 5 columns in one row and the remaining 5 columns on other row.
ReplyDeleteKindly let me know how can I do that?
Thanks in advance
Raje
Raje,
ReplyDeleteMaybe this will give you a start:
http://obiee101.blogspot.com/2007/12/obiee-pivot-table-with-carriage-return.html
regards
John
I know exactly what craig is getting at. There is a difference between the column heading and the table headings when you look at the table view. Measure labels show the column headings but not the table ones. I have been trying without success to get the table headings to show in a pivot table. Any ideas?
ReplyDeleteSorting column heading
ReplyDeleteHow to sort the column heading dynamically?