OLAP Manager Components and Workflow
Here is the list of OLAP Manager components and how the workflow is defined.
Column | Description |
---|---|
Cubes | With a Nectari installation, you can manage as many cubes as desired. Each cube contains its own definition of Dimensions, Measures, Slices and Data Sources. |
Dimensions | Key element of a data cube, define dimensions in Nectari. |
Measures | Key element of a data cube, define measures in Nectari. |
Slices | Defined subsets of data based on a list of dimensions. |
Data Sources |
A data source is a source for the defined structure of the cube. A cube could have several data sources. For instance, a production ERP system, a legacy system, an external database shared by a supplier, etc. Each data source is managed by 3 different screens:
|
Build the cube |
Once the cube is defined, mapped with the data sources and with proper slices, it has to be built. Suitable objects will be (re)created in the data warehouse (e.g. Nectari Cube). |
Scheduler | You can manage One-time, Daily, Weekly or Monthly jobs that can refresh or load all data, per data sources, into the cube. |
Logs | You can view the history of jobs for a cube (build, refresh, load all), including error messages if a job failed. |