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. It is not necessary to select all the objects or a whole subject area; the technique can be used for a reduced set of objects.
2. Right-click on the subject area. Select Externalize Display Names | Generate Custom Name, as shown in the...