Prepare Your External Applications
To ensure your external applications continue to work without interruption, review and update your semantic model to meet the latest standards.
- Hierarchy (logical dimension) based on two logical tables: To adhere to the optimal practice, a hierarchy (logical dimension) must be derived from one and only one logical table (dimension table). You must combine the logical tables and then delete the logical table that you merged the data from. For example, if you have a hierarchy (logical dimension) sourced from a dimension table and a dimension extension table, add the dimension extension table data to the dimension table. After you've combined the logical tables, delete the dimension extension table.
- Logical foreign key joins: Logical foreign key joins will be deprecated; delete the logical foreign key joins and replace them with logical joins.
- Primary keys: All logical levels must have a primary key defined.
- Application Roles: User-level security will be deprecated; update the semantic model to exclusively use application roles for all object and data security permissions.
If the external semantic model references application roles and groups, then you must create them manually. The merge capability imports only the mappings and doesn't import the roles and groups definitions. Create the applicable groups in your identity provider, see Create Groups or Create a Group as applicable. Create application roles using the Security page in Oracle Fusion Data Intelligence, see Create an Application Role.
- Data types of the conforming columns are matching, else you can't merge.
- Data for the mapped columns match, else queries don't fetch correct results.
- Level of details at which data is stored in the dimensions match, else queries return incorrect results.
- External semantic model is up to 25 MB in size.
- Catalog objects are in folder names that don't conflict with the prebuilt folders of Oracle Fusion Data Intelligence and in
/Shared/Custom/folder. - New logical table source that you add has a higher priority group than the prebuilt logical table source. For example, if the logical table source of the prebuilt object is 2, then you must specify a priority group of 3 or higher.
- Additional hierarchy has its own total level.
The external semantic model connects only to the Oracle Autonomous Data Warehouse associated with Oracle Fusion Data Intelligence. After enabling the external application merge functionality, if you make semantic model changes with data augmentation, then it'll result in unexpected errors. If such changes exist, then you must update the data augmentations to remove the semantic model changes. Ensure that you make the semantic model changes in the external semantic model and that you don't use system variables in your extensions.You must also ensure that the functional areas enabled in the target environment and the development environment from where the template semantic model was extracted are the same to avoid failure of the external application merge.