How to change Parent Column Heading Names in OBIEE 12c

1. You can use these icons to erase formatting, copy current formatting, or paste column formatting to another column.

1. Open Column Properties for the 2 – Billed Quantity column.

2. Click the Column Format tab and then the Format icon to the right of the Column Heading box.

3. Choose a background color and add a border.

4. Click the Copy Cell Format icon.

5. Click the OK button.

Step #6: Formatting Remaining Columns

Formatting Remaining Columns

1. Click the Custom Headings checkbox and change the Folder Heading to

‘This Year’.

2. Change the Column Heading to ‘Billed Quantity’.

3. Click the OK button.

4. Click the Results tab.

5. Your table should resemble the one displayed above.

6. Click the Criteria tab

How to change Parent Column Heading Names in OBIEE 12c

1. Open Column Properties for the 1 – Revenue column.

2. Click the Column Format tab and then the Format button to the right of the Column Heading box.

3. Click the Paste Cell Format icon.

4. Click the OK button.

5. Click the Custom Headings checkbox and change the Folder Heading to ‘This Year’.

6. Change the Column Heading to ‘Revenue’.

7. Click the OK button.

Result

1. Format the 121 Period Ago Rev column with a new background color and border. Copy the formatting.

2. Rename the Folder Heading to ‘Last Year’.

3. Rename the Column Heading to ‘Period Ago Rev’.

4. Format the 123 Rev Pct Var to Period Ago column. While in the Edit Format screen, paste the formatting from the prior column.

5. Rename the Folder Heading to ‘Last Year’.

6. Rename the Column Heading to ‘Rev Pct to Period Ago’.

7. Click the Results tab.

8. Save your analysis

Datawarehouse Architect