OBI Code Mapping

Note: This topic applies to OBI having licenses OPB_<version number> OBI Enterprise (OBIEE - Multiple Properties), or OPI_BUIP_<version number> OBI Standard (Single) using OLAP technology and data cubes. This topic does not apply to standalone S&C Advanced Reporting whose data is accessed directly from Opera tables via OLTP. For S&C Advanced Reporting, see S&C Advanced Reporting Subject Areas or S&C Advanced Reporting Setup.

When the OBI license code is active, users can map similar, existing Opera codes to a single OBI code for efficient OBI reporting. For example, many similar rate codes may have been created in Opera with different names (i.e., RACK1, RACK2 RACKN, and so forth), yet these rate codes may have closely-related attributes that would allow them to be grouped together into one OBI rate code, called RACK. When Opera and OBI codes are mapped, the OBI report output itself will not change, as the report still contains all the consolidated Opera codes. The benefits to OBI code mapping, however, are that OBI code mapping will:

• Provide consistency in reporting
• Improve performance and enable cubes to be built faster (cube dimensions will contain fewer records and the size of the cube will also be reduced)
• Enhance reporting performance in both the single-property as well as multiple-property environments.

  Note: OBI code mapping functionality is currently available with Opera and OBI rate codes. In future Opera versions, mapping will be available for other codes, such as market codes, source codes, room codes, etc.

Prerequisites

• Create an OBI reporting code that other Opera codes will be mapped to. The OBI reporting code needs to be active in at least one property.

OBI Code Mapping for BI Reporting Screen

Access the Opera BI Code Mapping for BI Reporting screen by selecting Configuration>Setup>Business Intelligence Setup> Options>OBI Code Mapping. At this screen, you can view, create, edit and delete OBI Reporting Codes.

Selection Criteria

Select from the OBI Mapping Table LOV the type of code (i.e., Rate) you would like to view or map. Select the Search button. Existing mapped codes will display.

Grid

BI Code. The BI Code that the Opera codes are mapped to.

BI Label. The label of the BI Code as seen on BI reports. (This label is editable in the BI Label field beneath the grid, see below.)

BI Code Description. Description of the BI Code. (This description is editable in the BI Code Description field beneath the grid, see below.)

Mapped Opera Codes. The Opera codes that are currently mapped to the BI Code.

Bottom of Grid

Beneath the grid are two fields for editing and one section for easily viewing all of the mapped Opera codes.

BI Label. If you want to change the BI Label for the BI Code of grouped rates, you may enter the new label here and select Save. The new BI Label appears in the grid and all affected records will be updated.

BI Code Description. If you want to change the BI Code Description for the BI Code of grouped rates, you may enter the new description here and select Save. The new BI Code description appears in the grid and all affected records will be updated.

Gray View Only Section. The mapped Opera Codes that are grouped as part of the highlighted BI Code are listed here for easy viewing.

Button Functions

Save. Select this button to save changes made to the BI Label and BI Code Description.

New. Select this button to open the Select New BI Reporting screen. Here you will select the BI reporting code you want to have Opera codes mapped to. The list of the type of codes displayed depends on the OBI Mapping Table selected from the LOV. See Creating New BI Mapping below.

Edit. Select this button to edit the highlighted BI Code Mapping. The Rate Code multi-select screen appears. See Editing BI Mapping below.

Delete. Deletes the highlighted BI Code and mapped Opera codes. This combination will no longer be used for BI reporting.

Creating New BI Mapping

This screen (Select New BI Reporting Code) displays after you select the New button from the Opera BI Code Mapping for BI Reporting screen. You will map all data for the Opera Codes to the BI Reporting Code. All statistics will be consolidated to the BI Reporting Code when building the cubes and in BI reporting.

1. Highlight the New BI Code you want used as the BI Reporting Code.
2. Select OK. The Rate Code multi-select screen appears (below).
3. On the Rate Code multi-select screen, select all the Opera rate codes you want mapped to the BI Reporting Code. (For instructions on using the Rate Code multi-select screen, see Gen_Multi_Select screen.)

4. When you are through, select OK. Your new BI Code mapping will appear on the Opera BI Code Mapping for BI Reporting screen.

Note: When creating new or editing BI Code Mapping, you must rebuild the affected OBI cubes. If you want past data in the mapped BI reports, you must complete a full rebuild. Currently, cubes affected by rate codes that should be rebuilt are: COMPANY, FUTURE_RESV, RESV_HISTORY_MONTH, RESV_PACE_MONTH, AND TRAVEL_AGENT.

Editing BI Mapping

This screen (Rate Code multi-select screen) displays after you highlight the BI Reporting Code and select the Edit button from the Opera BI Code Mapping for BI Reporting screen. From this screen, you can add or remove (select and de-select) Opera codes that are mapped to the current BI Reporting Code. (For instructions on using the Rate Code multi-select screen, see Gen_Multi_Select screen.)

1. After you have made your edits, select the OK button. Your edited BI Code mapping will appear on the Opera BI Code Mapping for BI Reporting screen.
   

   Note: When creating new or editing BI Code Mapping, you must rebuild the affected OBI cubes. If you want past data in the mapped BI reports, you must complete a full rebuild. Currently, cubes affected by rate codes that should be rebuilt are: COMPANY, FUTURE_RESV, RESV_HISTORY_MONTH, RESV_PACE_MONTH, AND TRAVEL_AGENT.

See Also

• OBI Cube Maintenance