OBI Custom Attributes

With the OBI Custom Attributes option, BI users with the multiple property license (OPI_<version number> OBI Enterprise (Multiple Properties - OBIEE) can set up a maximum of 10 custom columns to appear in BI reports. Currently, the customized columns pertain to the Resort Dimension (which all BI Cubes have). In future Opera versions, other Dimensions will be available for customizing columns such as for the Market, Source, and Room Type Dimensions. The Resort Dimension pulls its data from the Opera table records of OBI_Resort_View, Resort_Features, and Resort_UDF.

The example below, displays the final output of some customized attributes (labels and columns) for the Resort Dimension on an OBI Report. This report was accessed in OBI (OBIEE Answers and Reports) after:

The OBI custom attributes were modified
The cubes were rebuilt.

obi_custom_attributes_results_screen

Opera BI Custom Attributes Setup Screen

This Opera BI Custom Attributes Setup screen appears when the Configuration>Setup>Opera Business Intelligence Setup>Options>Custom Attributes button is selected. Depending on whether you are editing or creating new customized columns and their attributes, various prompts will dynamically display during the process.

obi_opera_bi_custom_attributes_setup

Selection Criteria

Select from the OBI Dimension Table, the dimension for which you want to create new attributes or edit existing ones. Select the Search button.

Grid

The grid displays existing attributes (such as source information, custom labels and columns) for the dimension. The gray table at the bottom of the screen displays the SQL Statement of Queries that will be executed for the custom column when the cube is built.

Seq. The number in the sequence of where the custom column will appear in the Opera BI Custom Attributes Setup screen and in the placement of the OBI reports.

Opera Table. The source of data for the custom column.

Custom Column. The name of the column from the Opera table.

Custom Column Desc. Description of the custom column in the Opera Table.

Custom Label. The name of the column label as it will appear in the report.

Return Value. The label of the data, obtained from the Opera table, as it will appear in the column in the report.

Advanced Filter. An advanced sub-query.

Button Functions

New. Select this button to create a new custom column. See Creating and Editing Custom Attributes below.

Edit. Select this button to edit an existing custom column. See Creating and Editing Custom Attributes below.

Delete. Highlight the custom column you want to remove and select the Delete button.

Creating and Editing Custom Attributes

Note: After creating a new custom column or modifying an existing one, you must rebuild all of the OBI cubes.

New

Select the New button to create a new custom column. The Select New Custom Column Seq. screen appears. The available sequence numbers display. Only 10 columns are available.

Select New Custom Column Seq. Screen

obi_select_new_custom_col_sequence

The available sequence numbers for the custom columns display.
Highlight the sequence number for where in the report row you want the new custom column to appear. Select OK.
The Select New Custom Attribute screen appears.

Select New Custom Attribute Screen

This screen lists the new column name, column description, and Opera table where the values will be obtained.

Highlight the new column for the type of data you would like added to your report and select OK.
This screen closes and the Modify Custom Attributes screen displays with the populated attributes of the new column you just created. You can modify the default values. See Edit, below.

Edit

Modify Custom Attributes Screen

The Modify Custom Attributes Screen displays when you have just added a new column (see above) or when you highlight an existing column and select the Edit button from the Opera BI Custom Attributes Setup screen. On this screen, you can modify the existing attributes and default values, if desired.

Dimension Name. (Read-only). The Dimension selected from the Opera BI Custom Attributes Setup screen for the current custom column.

Attribute Seq. (Read-only) The sequence for the current custom column in the report row, as selected from the Select New Custom Column Seq. screen.

Opera Table. The Opera data used as the source of data, i.e. OBI_Resort_View, Resort_Features, or Resort_UDF.

Custom Column. The column from the Opera table that will be used as the source of data.

Custom Column Label. You may leave the default value or enter the column's heading label as you would like it to appear on the report, such as Swimming Pool.

Custom Column Description. The type of column description from the Opera table.

Key Column. The main identifier of how the report is sorted, i.e. Resort. This will always be the first column.

Return Values. The value from the table identifying the item that the property can provide for the Custom Column label. For example, if the Custom Column Label is Leisure, you may enter 'SPA, 'POOL' here.

Additional Filter. This is optional for an advanced sub-query and additional clause in SQL format for the report output.

After rebuilding the BI cubes, you will be able to see the results for your reports in OBIEE>Answers and Reports.