Enabling dynamic column headings

Reporting heading changes can be frequent within a solution during development, and in ongoing processes through the life of the solution. Each time, this normally entails changing the actual reports, and then releasing the changes to production. Externalized strings give one the capabilities to maintain the headings without changing the report code.

Getting ready

OBIEE has the framework for creating custom headings which are externalized strings. To enable this, open the BI Administration Tool and open the repository file (RPD).

How to do it...

The repository file stores all the definitions of the subject areas and data model. This is located on the middle-tier server:

  1. Select the presentation layer objects to be customized. ...

Get Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.