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 database

  • SSAS cube

• Run configuration database creation command:
  CXO.Adapter.OracleCloudEpm.Cli.exe create-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

• Run Set Authentication Settings for IDP authentication for Oracle EPM Adapter

  • TODO: Add example of the command

• Run create-source-in-adapter command

  • TODO add example

• Restart IIS Application Pool for Oracle EPM Adapter

Oracle EPM system configuration

...