Creating a table view with two levels of headers

May 18, 2009
Query Failed: [nQSError: 42043] An external aggregate is found in an outer query
May 27, 2009

This tutorial applies to:Business Intelligence Server Enterprise Edition – Version: [1900] – Release: 10g

The question was rather frequent – “How to create a table view with two levels of headers?”

i.e. the high-level heading as the table title heading and then another level of heading where there is one sub-heading/title for one set of columns and a different sub-heading for another set of columns

The high-level heading can be created by adding a title view for this.

And then for 2nd level of sub-heading that should be different for one set of columns and another sub-heading for another set of columns, you can achieve this by displaying the table headings as well in addition to the column headings and then set the custom table heading appropriately for the respective set of columns that require the same heading.

To do this, you need to follow a 2-step approach
1) go to the table view and edit the table view properties. Set the ‘display column & table headings’ property to ‘as separate rows’ instead of ‘only column headings’.
2) Then go to each column and set the custom table heading. Set the same table heading for all the columns that require the same heading.


  1. Anupam says:

    I am currently working with pivot tables in OBIEE.
    I noticed that while using the pivot view the header of the columns is no longer visible.
    Is there a way to make the headers visible?

  2. Andriy Yakushyn says:


    Good question.

    Check this link

    I can clearly see headings there

    Did you check OTN?

  3. MAV says:

    I have the same problem that Anupam. When I run the report with the Pivot Table, the title of the report is no longer visible. Is any way to set visible the Name of the Report?
    Thanks in advance.


  4. Cjhepburn says:

    Create a new variable in Criteria.
    Edit Column formula: ‘Add the text for your header info’
    In the pivot table design view drag that new field above the “Measure Labels”
    You can add as many layers as you like.

Leave a Reply