Installation

...

• Configure proper license key

  • Based on the client’s source, generate the right key using the License Key generator: Oracle EPM Planning / Oracle EPM Financial Consolidation and Close.
    Path to generator: \\cxo-fileserv\Data\Internal Tools\(not-released) LicenseKeyGenerator for B Licenses (with Oracle Cloud EPM adapter)

• Create a new source system in the SSM for the correct source type: Oracle EPM Planning / Oracle EPM Financial Consolidation and Close. This should create:

  • Fact databaseOracle EPM configuration database

  • SSAS cube

• Configure connection string to configuration database in appsettings.json for CLI/WebApi

• Run database migration command on CLI: Run configuration database creation command:
  CXO.Adapter.OracleCloudEpm.Cli.exe migrate-databasecreate-configuration-db server-name:server database-name:configuration_database authentication-type:windows
  Parameters:

  • server-name: name of the server on which the database should be created

  • database-name: name of the database to be created

  • authentication-type: windows / proprietary

  • username: SQL user name (if authentication-type == proprietary)

  • password: SQL user password (if authentication-type == proprietary)

• (While story for bootstrapping a source in the adapter is not yet done):

  • Create a source record in the Source table in the configuration database

  • Create default dimension mapping records in the Dimension Mappings table in the configuration database

...