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:

  • Data Source Editor: This screen is used to define the tables, joins, field, calculated fields, tracking and stored procedures used as a data warehouse.

  • Dimensions Mapping: This screen is used to define the links between cube dimensions and data source fields or calculated fields.

  • Measures Mapping: This screen is used to define the links between cube measures and data source fields or calculated fields.

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.