Versions Compared

Version Old Version 15 New Version 16
Changes made by

Daniel Nikolovski

Maarten Schilt

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Command

create-source-in-adapter

Parameters

  • source-type: longview-close / longview-tax

  • source-name: name of source to be created

  • factdb-name: name of the fact database that was created via SSM

  • factdb-server: SQL server on which the fact database is hosted

  • factdb-authentication-type: integer value indicating how to authenticate with fact database: 0 = proprietary, 1 = windows.

  • factdb-username (optional): SQL username in case of proprietary authentication

  • factdb-password (optional): SQL password in case of proprietary authentication

  • ssas-server-name: SQL server on which the SSAS cube is hosted

  • ssas-database-name: name of the SSAS database

  • ssas-cube-name: name of the SSAS cube within the database, should be “CXO“ for regular scenarios.

  • first-period (optional): the first period in case the customer works with a broken book year. Example: Apr. Note: currently only works for longview-close sources.

Example

.\CXO.Adapter.LongviewTidemark.Cli.exe create-source-in-adapter source-type:longview-close source-name:MyLongviewCloseSource factdb-name:cxo_fact_MyLongviewCloseSource factdb-server:cxo-dev-sql02 factdb-authentication-type:1 ssas-server-name:cxo-dev-as01 ssas-database-name:MyLongviewCloseSource ssas-cube-name:CXO first-period:Apr

  • After running these commands the adapter is configured and a first source is available. When multiple sources are required, run the create-source-in-adapter for each source needed.

  • Each source is created with a default configuration for dimensions, Longview symbol names, etc. These defaults need to be changed for the source to function properly. The next section explains how to configure the Longview sources.

...