Infer the Use Logical Column Property for Presentation Columns

Presentation columns have both a Name property and a Use Logical Column Name property.

In some cases, these properties can come into conflict. For example, the table shows a scenario where this situation could occur.

Repository Presentation Column Name Logical Column Name Use Logical Column Name

Original

Sales

GroupSales

No

Current

Sales

Sales

Yes

Modified

GroupSales

GroupSales

Yes

If the regular merge rules for the objects in the table are applied, the merged repository contains a presentation column called GroupSales and a logical column called Sales, with the Use Logical Column Name property set to Yes. This result is incorrect because the name of the presentation column is different from the name of the logical column.

To avoid this situation, the Oracle BI Server infers the value of the Use Logical Column Name property. Using the inference logic, the merged repository has a presentation column called GroupSales, a logical column called Sales, and the Use Logical Column Name property set to No.