mO SharemO Share

We’re excited to announce that the latest information is now available on our new site, the Ginesys One Wiki!. Visit the site for up-to-date resources and insights. We look forward to continuing to support you there!

Managing the Cube Manager

Owned by Deepankana Roy (Unlicensed)
Last updated: Mar 05, 2024 by Aparajita Basu Roy
5 min read

An OLAP Cube is a multidimensional view or temporary table that is optimized for data warehouse and online analytical processing (OLAP) applications. An OLAP Cube Manager is a tool for storing and reflecting data in a multidimensional form, generally for reporting purposes. 

Alert: Cubes can only be worked with if they are assigned to a particular user. Assignments can only be done by Admin users of Cube Manager. 



This article describes how to perform various actions of the 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. The modules have to be assigned to the user for cubes to 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. 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).



    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. 





Pre-requisites

  1. The users' role must have access to the Cube Manager feature by enabling Modify 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.

  4. Go to Action > Edit or press CTRL+ALT+E..

  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. 



Pre-requisites

  1. 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 > Refresh 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. 







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(s) 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 Discard.

  4. Go to Action > Discard or press CTRL+ALT+D.

  5. Discard popup window opens showing a message - "Cube once discarded cannot be retrieved. Do you want to discard this cube?".

  6. If you click on Yes, the cube will be discard permanently. 



Pre-requisites

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

  2. Cube(s) must be created.

  3. The user must have Admin profile for Cube Manager.

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 Action > Assign to User or press CTRL+ALT+I.

  4. The Assign to User window opens.

  5. It has two(2) views, Cube Wise and User Wise.

  6. Select any one view - 

    1. On selecting Cube Wise View, Cube Manager admin is able to assign multiple users to a particular cube in a particular module.

      1. Select Module from lov.

      2. Select Cube from lov..

      3. Select all the users who need to have access to that cube.

      4. Click on Save.

    2. On selecting User Wise View, Cube Manager admin is able to assign multiple cubes to a particular user.

      1. Select User from lov.

      2. Select Module - Cube name from lov..

      3. Click on Save.