Documentation for CXO-Cockpit Reporting Suite 4.2, click for CXO-Cockpit Reporting Suite 4.1 Documentation or check the CXO-Cockpit Website.

Book creator (disable)

System Settings

From CXO Cockpit Reporting Suite Documentation

Jump to: navigation, search

Introduction

The system settings dialog allows you to set all technical parameters that are required to connect to a Source System.

Two types of source systems can be distinguished:

  • Adapter: Source systems that require an CXO-Cockpit application adapter
  • Direct: Source systems that can queried directly with MDX

System Settings Dialog Features and Functions

 

# Name Description
1 Add Source System This button allows you to add a new source system, a new empty tab will appear.
2 Delete Source System Removes the source system of the current selected tab. A source system can only be removed when there are no CXO-Objects conencted to this source system.
3 Rename Source System Renames the source system. Source system names are used for indentification purposes in the design studio.
4 Source Systems - tabs Every source system has its own tab with configuration fields.
5 Use Application Connector This field indicates if the source system integrated with an adapter or if it is queried directly.
6 CXO Staging database Specifies the staging database of the this adapter. These fields are not used for direct source systems.
7 CXO Fact Database Specifies the fact database of the this adapter. These fields are not used for direct source systems.
8 OLAP Connection Specifies what OLAP plugin is used and how to connect to the OLAP database.
9 OLAP Actions
  • Check: Checks if the OLAP connection can be made

The following actions are only enabled for adapter (non-direct) source systems that use SSAS as OLAP version:

  • Create New: Creates a new OLAP database
  • Process: Processes the OLAP Cube
  • Update: Rebuilds the OLAP model and applies the calculated members
  • Cube Calculations: Opens a maintence screen where custom MDX cube calculations can be maintained


The following actions are only enabled for direct source systems:

  • Dimension Split: Allows you to split an OLAP dimension into two or more CXO-Cockpit dimensions
  • Dimension Mapping: Allows you to map the OLAP dimensions to CXO-Cockpit dimension codes
  • Period Frequency: Defines how the period structure should be interpreted.
10 License Information Use this field to enter or update the license key. Press the check button to validate the license key.

See Also

Retrieved from "http://lib.cxo-cockpit.com/wiki/index.php/System_Settings"