My Oracle Support Banner

Model Upload 8.1.1 Technical Questions on New Functionality (Doc ID 2828750.1)

Last updated on MAY 17, 2023

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.1.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI / AAI)
Data Model
User Interface (UI)
JavaScript Object Notation (JSON)


Purpose

Model upload functionality has changed with version AAI 8.1.1 from previous versions.  There are new enhancements and changes which directly impact the technical aspects of model upload:

NOTE: Erwin is still required for customization of data models.  SQL Modeler is not usable for EPM apps and is not recommended.

Model Upload Using JSON / erwin XML

You can upload the warehouse data from the operational systems to the database schema using the erwin XML, JSON or Database XML (<INFODOM>_DATABASE.XML) file. Using the stand-alone command line utility TransformErwin.sh, you can transform the erwin XML into Database XML or JSON.

You can also use the DB.XML or JSON instead of erwin XML to speed up the model upload process.

Model Upload Using OFSAA Data Model Descriptor (JSON) File

This feature allows you to resume the Data Model upload from the logical Data Model, in the form of OFSAA Data Model Descriptor File (JSON) that is generated in the base environment. This helps in speeding up the Model Upload process by skipping the XSL transformation in the primary environment. This feature can be used if the same model in the development environment should be uploaded to multiple OFSAA instances in the production environment. In such scenarios, you can copy the model definition (JSON) files and scripts to the target environment and run the command line utility CopyUpload.sh, to integrate those files in the target environment. You can choose to resume the model upload process from script generation or script execution.

Following are the steps involved in the model upload using OFSAA Data Model Descriptor file:

1.     Copy the required files from source to target environment based on the start point from where you want to resume the model upload process.
2.     Execute the CopyUpload utility.
3.     Perform Model Upload.

Command Line Utility for Generating Slice JSON (ODM)

A standalone command line utility called generateSliceJson.sh is provided that can run on lower environments to generate Slice JSON from the old XML (erwin XML or Database XML) and new XML (erwin XML or Database XML) file.

Slice utility compares the old XML (erwin XML or Database XML) and new XML (erwin XML or Database XML). Based on the checksum values:

§       If the checksum matches, it will ignore the JSON.
§       If the checksum values do not match, then the JSON (ODM) files are generated.

This utility does not have any dependency on OFSAA. It is used for converting OOB and the customized erwin XML or Database XML to JSON (ODM) files. This utility is available at $FIC_HOME/utility directory. You can copy the utility to any machine and run the utility.

Additional details can be found in the OFSAAI 8.1.1 User Guide.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 TransformErwin.sh and generateSliceJson.sh scripts
 MODEL UPLOAD Technical Questions
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.