During exploration of Oracle BI EE Business Model data sources, Essbase Studio creates a hierarchy for each selected Oracle BI EE dimension. For each Oracle BI EE dimension level that contains at least one primary key column, Essbase Studio creates a dimension element representing the given level of the Oracle BI EE dimension.
Rules used to generate binding expressions for these dimension elements:
Rule 1—If the Oracle BI EE dimension level contains a single primary key, then the primary key column is a key binding for the dimension element.
Rule 2—If the Oracle BI EE dimension level contains several primary keys, the key binding expression is the result of the concatenation of all primary keys (converted to string if its unit is not string) with an underscore (_) as a delimiter.
Note: | If the Oracle BI EE dimension level does not contain a logical primary key column, then Essbase Studio does not create a dimension element for the given Oracle BI EE dimension level. |
Rule 1—If the unit of the key binding expression is string (not as a result from concatenation of several primary keys), then the caption binding for the dimension element is equal to the key binding expression.
Rule 2—If the unit of the key binding expression is not string, then the first Oracle BI EE logical column level that is a key column (not a primary key column), and has type of CHAR or VARCHAR, is used as a caption binding expression for the given dimension element.
Rule 3—If the unit of the key binding expression is not string, and there is no key column with type CHAR or VARCHAR, then the key binding conversion, .toString, is used as a caption binding expression for the given dimension element.
Rule 4—If the unit of the key binding expression has unit string as a result of the concatenation of several primary keys, then the caption binding expression is the same as the key binding expression.