Oracle Cloud Infrastructure Documentation

Merge External Applications

As a modeler, modeler administrator, and security administrator, you can merge the semantic model of an external application such as another Oracle Analytics Cloud instance with Oracle Fusion Data Intelligence. You can also merge your existing catalogs in the external Oracle Analytics Cloud with those in the Oracle Analytics Cloud instance associated with your Oracle Fusion Data Intelligence instance.

The merge enables you to join the external semantic model with the conformed dimensions of Oracle Fusion Data Intelligence to create connected analytics across the enterprise for cross-functional insights.

Prior to merging the external semantic model, the system validates it and displays the validation report in the Validation tab in the External Application region. If there are no errors in the external semantic model, then you can proceed with the merge. When the external application name is the same as the currently merged one, then it won't show in the validation tab even if you validate it. Once an external application is merged, its not possible to import and validate again an external application with the same name. To import the external semantic model again, you must change the external application name.

  1. Sign in to your service.
  2. In Oracle Fusion Data Intelligence Console, click Semantic Model Extensions under Application Administration.
  3. In the External Application region, click Actions, and then click Import Application to import the external semantic model.
  4. In Select Application and Content to Merge, enter a name for your application in External Application Description, select Semantic Model Import, and click Select Semantic Model to import the applicable Oracle Analytics Cloud semantic model from your local machine, and enter the password that you use to encrypt the semantic model file.

    Select Application and Content to Merge dialog

  5. In Resolve imported content conflicts, choose the option to rename the imported objects with either a prefix or suffix when a conflict occurs.
  6. Select Expose custom columns in out of the box subject areas to expose columns added to the conformed dimensions in all the applicable subject areas.
  7. Click Validate.

    The system validates the external semantic model and displays a report in the Validation tab. If there aren’t any errors, then the system displays the Merge Application button; click it to complete the merge process.
    Validation is successful and the Merge Application button is enabled

    If there are errors, then the system displays the errors and doesn’t initiate the merge. You must fix the errors in the external semantic model and try again.
    Validation failed and errors displayed

  8. In the External Application region, verify that the import process has completed.

    Merge completed

  9. In the External Application region, click Publish Model. In the Publish Model dialog, select the values and click Publish.

    Publish Model dialog

  10. In the External Application region, click Actions, and then click Import Application to import the external BAR file.
  11. In Select Application and Content to Merge, enter a name for your application in External Application Description, click Application Import, and click Select Bar File to import the applicable Oracle Analytics Cloud bar file from your local machine, and enter the password that you use to encrypt the bar file.
    You can select the external bar file only after importing the external semantic model. The bar file imports the JAZN file and the catalogs.
    Import Bar file

  12. Click Import.
  13. In the External Application region, click the Activity tab to verify that the import process has completed.
  14. Navigate to the Security pages and assign applicable groups to users to provide access to the merged external catalogs.