Versions Compared

Old Version 10

changes.mady.by.user Deepankana Roy

Saved on

compared with

New Version 11

changes.mady.by.user Deepankana Roy

Saved on

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.

...

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. 

Expand
titleCreate OLAP Cube Manager

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 from which the cube will start working (Mandatory Field).  
    6. Date To: Date upto which the cube will work (Mandatory Field).

    7. As on Dated: Date on which a particular cube will work (Mandatory Field).

      Tip

      Note: For particular combination of Module and Master Cube either Date From and Date To or As on Dated will be enabled.


    8. Description: You can put in the description of cube.
    9. Type: You can select the cube type either Private or Public. 
      1. Private: If you select Private then the cube will be visible to the particular user who have rights to access the respective module and the admin. 
      2. Public: If you select Public then the cube will be visible to all users who have rights to access the respective module. 
    10. Select the Site: Select either All Sites or Selected Sites. If you select All Sites option then the Assign Site section will be disabled. Otherwise you can select site which you want to assign for the cube. 
  6. Click on Save button to save the OLAP Cube Manager. 


Expand
titleEdit OLAP Cube Manager

Pre-requisites

  1. The users' role must have access to the Cube Manager feature by enabling Add Modify app operation for the feature through Admin - Utility - Manage - Cube Manager.
  2. Particular module for Which the cube will Cube must 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.
  6. Module: Select the module for which you are creating the cube. 
  7. Cube Master: Cube Master is the type of cube you want to create. Select the cube master from the drop down list.
  8. Cube Type: The selected cube master will be populated in the Cube Type field.
  9. Cube Name: Put in the Cube Name (Mandatory Field).
  10. Date From:  Date from which the cube will start working (Mandatory Field).  
  11. Date To: Date upto which the cube will work (Mandatory Field).

    12. As on Dated: Date on which a particular cube will work (Mandatory Field).

    Tip

    Note: For particular combination of Module and Master Cube either Date From and Date To or As on Dated will be enabled.

  12. Description: You can put in the description of cube.
  13. Type: You can select the cube type either Private or Public. 
    1. Private: If you select Private then the cube will be visible to the particular user who have rights to access the respective module and the admin. 
    2. Public: If you select Public then the cube will be visible to all users who have rights to access the respective module. 
  14. Select the Site: Select either All Sites or Selected Sites. If you select All Sites option then the Assign Site section will be disabled. Otherwise you can select site which you want to assign for the cube. 
    15. Click on Save button to save the OLAP Cube ManagerManager.
  15. Cube Manager module opens.
  16. Select one cube you want to edit.
  17. Go to Action > Edit or press CTRL+ALT+E..
  18. Edit OLAP Cube Manager window will open. 
  19. All the previously saved data will be populated. 
  20. Modify data as per your requirement except Module and Master Cube.  
  21. Click on Save button to save the modified data. 


Expand
titleRefresh OLAP Cube Manager

Pre-requisites

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

Step-by-step guide

The steps are as follows:

  1. Go to Admin > Utility > Manage > Cube Manager.
  2. Cube Manager module opens.
  3. Select one cube you want to Refresh.
  4. Go to Action > Edit or press CTRL+ALT+R.
  5. Refresh Cube popup window opens showing a message - "Do you want to refresh Cubes?" .
  6. If you click on Yes, the refresh process will start and you will get the new update of the cube after completing the process. 


Expand
titleEdit Discard OLAP Cube Manager

Pre-requisites

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

Step-by-step guide

The steps are as follows:

  1. Go to Admin > Utility > Manage > Cube Manager.
  2. Cube Manager module opens.
  3. Select one cube you want to edit Discard.
  4. Go to Action > Edit or press CTRL+ALT+ED..
  5. Edit OLAP Cube Manager window will open. 
  6. All the previously saved data will be populated. 
  7. Modify data as per your requirement except Module and Master Cube.  
  8. Click on Save button to save the modified data
  9. Discard popup window opens showing a message - "Cube once discarded cannot be retrieved. Do you want to discard this cube?".
  10. If you click on Yes, the cube will be discard permanently. 


Expand
titleRefresh Show History of OLAP Cube Manager

Pre-requisites

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

Step-by-step guide

The steps are as follows:

  1. Go to Admin > Utility > Manage > Cube Manager.
  2. Cube Manager module opens.
  3. Select one cube you want to Refresh Discard.
  4. Go to Action > Edit or press CTRL+ALT+RH.
  5. Cube Refresh Cube popup window opens showing a message - "Do you want to refresh Cubes?" .If you click on Yes, the refresh process will start and you will get the new update of the cube after completing the process. History popup window will open. 
  6. You can search particular cube to check history.
  7. you can check Calculator, Start Time, End Time and Run Duration. 

    Tip

    Maximum last twenty cubes are displayed here.



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