Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

An OLAP Cube is a multidimensional database that is optimized for data warehouse and online analytical processing (OLAP) applications.

An OLAP Cube Manager is a method of storing data in a multidimensional form, generally for reporting purposes. In OLAP cubes, data (measures) are categorized by dimensions. The query language used to interact and perform tasks with OLAP cubes is Multidimensional Expressions (MDX). The MDX language was originally developed by Microsoft in the late 1990s, and has been adopted by many other vendors of multidimensional databases.

This article describes how to manage Cube Manager in Ginesys HO. 

Pre-requisites

  1. The users' role must have access to the Cube Manager feature by enabling Add app operation for the feature through Admin - Utility - Manage - Cube Manager.

  2. Particular module for Which the cube will be created, must be present.

Step-by-step guide

...

The steps are as follows:

  1. Go to Admin > Utility > Manage > Cube Manager.
  2. Cube Manager module opens.
  3. Click on Add button.
  4. OLAP Cube Manager window will open. 
  5. Fill the Cube Information section.
    1. Module: Select the module for which you are creating the cube. 
    2. Cube Master: Cube Master is the type of cube you want to create. Select the cube master from the drop down list.
    3. Cube Type: The selected cube master will be populated in the Cube Type field.
    4. Cube Name: Put in the Cube Name (Mandatory Field).
    5. Date From:  Date when the cube will be started (Mandatory Field).  


Filter by label (Content by label)
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@136dd
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel in ( "manage-cube-manager" , "admin-ho" , "administration-ho" ) and type = "page" and space = "PUB"
labelsmanage-cube-manager admin-ho administration-ho

...

hiddentrue

...