OLAP Manager in Sage Enterprise Intelligence (SEI)

By | March 30, 2023

On-Line Analytical Processing (OLAP) is a kind of software that allows users to access and analyse business data stored in several, and sometimes extremely large, data bases.

The definition and setup of OLAP data are multidimensional, which means the information may be compared in a variety of ways. Data cubes and data warehousing are two terms that are frequently used in relation with OLAP.

For business intelligence, SEI offers its own OLAP engine.

In OLAP Manager, we need to create cubes. Cubes are used as data warehouse in OLAP Manager.

Why using cubes as data warehouse? Cubes perform well with large amounts of data. For comparing and building outcomes, cubes are perfect. For instance, to comparing this year’s results with those from last year. Cubes are effective with a variety of data sources, including Sage X3 data and old ERP sales data.

If more OLAP cubes are required, they can be added to the database. This should only be done after a detailed analysis of the data requirements for the company.

Following steps showing process of building cubes.

  1. Identify the data requirement.
  2. Define the OLAP Cube.
  3. Build the OLAP Cube.
  4. Create a data model in the data model designer.
  5. Users view the data
Fig01: Process of building cube

OLAP Manager components and workflow:

  • Cubes

You are able to handle as many cubes as you like with an SEI installation. The definitions of Dimensions, Measures, Slices, and Data Sources are included within each individual cube.

  • Dimensions

We need to define dimensions in SEI. A dimension is an angle that will be used to examine the measurements. Common dimensions include products, business partners, and dates.

  • Measures

We need to define measures in SEI. Measures are numeric type fields with measurable values. Measures include things like sales totals, costs, margins, and quantities.

  • Slices

It is a defined subset of data based on a list of dimensions. A Slice is a subset of data included inside the Cube that is specified by a collection of Dimension Elements. To create a self-service ready Cube, as many Slices as Dimension combinations are available must be used. As a result, when the end user creates Views, the most efficient Slice is utilised.

  • Data Sources

A data source is a source for the cube’s defined structure. A cube could contain various data sources. For example, a manufacturing ERP system, a legacy system, an external database shared by a supplier, and so on.

Every data source is controlled by three different screens:

  1. Data Source Editor: This screen is used to specify the data warehouse tables, joins, fields, calculated fields, tracking, and stored procedures.
  2. Dimensions mapping: This screen is used to establish relationships between cube dimensions and data source or determined/calculated fields.
  3. Measures mapping: This screen is used to establish relationships between cube measures and data source or determined/calculated fields.
  • Build the cube

The cube must be built when it has been specified, mapped with the data sources, and given the appropriate slices. In the data warehouse, appropriate objects will be (re)created (e.g. SEI Cube).

  • Scheduler

You may handle one-time, daily, weekly, or monthly operations that update or load all data into the cube from different data sources.

  • Log

You can monitor a cube’s job history (build, refresh, load all), including error messages if a job fails.

OLAP manager is a best solution in SEI to analyze data if it is stored in extremely large sized database.

About Us
Greytrix – a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.

Greytrix caters to a wide range of Sage X3 (Sage Enterprise Management) offerings – a Sage Business Cloud Solution. Our unique GUMU™ integrations include Sage X3 for Sage CRM, Salesforce.com and Magento eCommerce along with Implementation and Technical Support worldwide for Sage X3 (Sage Enterprise Management). Currently we are Sage X3 Implementation Partner in East Africa, Middles East, Australia, Asia. We also offer best-in-class Sage X3 customization and development services, integrated applications such as POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons such as Catch – Weight and Letter of Credit for Sage X3 to Sage business partners, end users and Sage PSG worldwide.

Greytrix is a recognized Sage Rockstar ISV Partner for GUMU™ Sage X3 – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage X3 – Salesforce is a 5-star app listed on Salesforce AppExchange.

For more information on Sage X3 Integration and Services, please contact us at mailto:x3@greytrix.com. We will be glad to assist you.