Introduction

The CXO-Cockpit Data Warehouse Adapter is meant to replicate data that is not in the source system for example an excel sheet with data. This data can be loaded via the Data Warehouse Adapter into an OLAP cube of CXO. The OLAP cube is then used as main source for reporting in the CXO-Cockpit. The normal reports can be used to analyze and categorize the uploaded data. In this way powerful analyses can be made on additional information that normally is not loaded in the source systems. It is easy to access and maintain. The Data Warehouse Adapter has the following process:

-          Copy or load data from a sheet into a Data Warehouse Adapter template.
-          Save the data input into the Fact Database
-          Processing the CXO OLAP Cube with the data from the Fact database
-          Data is visible in the reports

Architecture

Plaatje, duidelijk maken dat het laden in de fact gebeurd op lowest level, cube processing is required for viewing data in the reports (here is lowest level not required)

Link naar Data Loader report

Configuratie

Dimension Mapping
Maintain Variables
Period Frequency

Data Warehouse Adapter

Introduction

Architecture

Configuratie

Other Articles