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.