Thursday, January 29, 2009

OBIEE Column headings

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):

image

To alter the column heading go to Table View Properties:

image

In the Display Column & Table Headings you have five choices:

image

Only column headings:

image

As separate rows

image

This allows you to customize the column heading over two rows:

image

image

As Table.Column

image

As Table.Column (Where needed)

image

Doesn't seem to change anything at first glance, but works fine when you have two columns with the same name from different folders:

image

No column or table headings

image

Till Next Time

9 comments:

Anonymous said...

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.
ID 1
Name john

instead regular tabular format of
Id Name
1 john

John Minkjan said...

Why don't you use a narrative view?

regards

Anonymous said...

Thank you. It works.

Anonymous said...

Is there a way to make the table headings show up in a Pivot Table?

John Minkjan said...

Craig Not really sure what you are looking for, check if your measure labels aren't set to hidden.

regards

John

Anonymous said...

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.

Kindly let me know how can I do that?

Thanks in advance
Raje

John Minkjan said...

Raje,

Maybe this will give you a start:
http://obiee101.blogspot.com/2007/12/obiee-pivot-table-with-carriage-return.html

regards

John

Anonymous said...

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?

Unknown said...

Sorting column heading

How to sort the column heading dynamically?