Versions Compared

Old Version 30

changes.mady.by.user Aparajita Basu Roy

Saved on

compared with

New Version Current

changes.mady.by.user Aparajita Basu Roy

Saved on

Key

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

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. 

Warning

Alert: Cubes can only be manipulated 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. 

...

titleCreate or Add Cube

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:

...

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.

...

  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. 

...

hiddentrue
idNew Generic release enhancement
Expand
titleSetup OLAP Cube

After updating to Version xxx, both new and old users will need to configure their cube manager. This option in the action menu will be enabled even when the Cube Manager is properly configured.

...

titleEdit Cube

Pre-requisites

...

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. 

Warning

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. 


Expand
title Add Cube

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).

      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. 


Page Properties
hiddentrue
idNew Generic release enhancement


Expand
titleSetup OLAP Cube

After updating to Version xxx, both new and old users will need to configure their cube manager. This option in the action menu will be enabled even when the Cube Manager is properly configured.



Expand
titleEdit Cube

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. 


Expand
titleRefresh Cube

Pre-requisites

  1. Cube must be created.

Step-by-step guide

The steps are as follows:

  1. Go to Admin > Utility > Manage

> Cube Manager.
  • Cube Manager module opens.
  • Select one cube you want to edit.
  • Go to Action > Edit or press CTRL+ALT+E..
  • Edit OLAP Cube Manager window will open. 
  • All the previously saved data will be populated. 
  • Modify data as per your requirement except Module and Master Cube.  
  • Click on Save button to save the modified data. 
    • Expand
    titleRefresh Cube

    Pre-requisites

    Cube must be created

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


    Page Properties
    hiddentrue
    idAwaiting Release


    Expand
    titleRefresh Status

    Refresh Status reflects the various states of the cube refresh process. Admin and user who has rights to access the module, can also manipulate the refresh status.

    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 Refresh process must be running.

    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 the Status.
    4. Go to Action >
    Refresh 
    1. Refresh Status or press CTRL+ALT+
    R
    1. S.
    2. Refresh
    Cube popup window opens showing a message - "Do
    1. Status popup window will open. 

    2. Select the Cube Refresh Process you want to refresh

    Cubes?"
    Expand
    titleRefresh Status

    Refresh Status reflects the various states of the cube refresh process. Admin and user who has rights to access the module, can also manipulate the refresh status.

    1. . 

  • If you click on Yes, the refresh process will start and you will get the new update of the cube after completing the process. 
    • Page Properties
    hiddentrue
    idAwaiting Release
    1. Click on the Refresh button to refresh the process.
    2. Click on the Cancel Refresh button to cancel the refresh process. 




    Expand
    titleDiscard Cube

    Pre-requisites

    1. The users' role must have access to

    the 

    1. the Cube

    Manager 

    1. Manager feature by

    enabling 

    1. enabling Delete app operation for the

    feature through 

    1. feature through Admin - Utility - Manage - Cube Manager.

    2. Cube

    Refresh process must be running

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

    Refresh the Status

    1. Discard.

    2. Go to Action >

    Refresh Status

    1. Discard or press CTRL+ALT+

    S

    1. D.

    Refresh Status

    1. Discard popup window

    will open. 

  • Select the Cube Refresh Process you want to refresh. 

  • Click on the Refresh button to refresh the process.
    • Click on the Cancel Refresh button to cancel the refresh process

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

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


    Expand
    titleDiscard Cube Assign to User

    Pre-requisites

    1. The users' role must have access to

    the 

    1. the Cube Manager feature by

    enabling Delete 

    1. enabling Assign to User app operation for the

    feature through 

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

    Cube Manager.
  • Cube(s) must be created.

    • Step-by-step guide

    The steps are as follows:

  • Go to Admin > Utility > Manage > Cube Manager.
  • Cube Manager module opens.
  • Select one cube you want to Discard.
  • Go to Action > Discard or press CTRL+ALT+D.
  • Discard popup window opens showing a message - "Cube once discarded cannot be retrieved. Do you want to discard this cube?".
    • If you click on Yes, the cube will be discard permanently

    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. 



    Expand
    titleShow History of Cube Refresh

    Pre-requisites

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

    1. Cube

    Manager 

    1. must be

    created

    1. selected.

    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 > Show History or press CTRL+ALT+H.

    5. Cube Refresh History popup window will open. 

    6. You can search particular cube to check history.

      Tip

      Only the last twenty cubes are displayed here.



    Expand
    titleManage Cubeset

    Cube Set is a collection of cubes which can be manipulated together. 

    Pre-requisites

    1. The users' role must have access to

    the 

    1. the Cube Manager feature by

    enabling app

    1. enabling app operation for the

    feature through 

    1. feature through Admin - Utility - Manage - Cube Manager.

    2. Cubes 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. Go to Action > Cubeset or press CTRL+ALT+B.

    4. Cubeset Window will open.


      Expand
      titleAdd Cubeset
      1. Click on Add button
      2. Create Cubeset popup window will open. 
      3. Put in the Set Name (mandatory field).
      4. Date, Time fields remain disable. If you select the Schedule checkbox then Date, Time fields will be enabled (both are mandatory fields).
      5. Click on Create button to create the cubeset.
      6. The new cubeset will be created.


      Expand
      titleEdit Cubeset
      1. Select the cubeset you want to edit.
      2. Go to Action > Edit.
      3. Edit Cubeset popup window will open. 
      4. All the data will be populated.
      5. Modify the records as per your requirement.
      6. Click on the Modify button to save the modified data.  


      Expand
      titleAssign Cubes
      1. Select the cubeset in which you want to assign the cube. 
      2. Go to Action > Assign Cubes.
      3. Assign Cubeset popup window will open. 
      4. Select the Module and Cube Name.
      5. List of cubes under the selected master cube will be populated. 
      6. Select the cubes you want to assign to the cube set. 
      7. Click on the Add button to save the records.


      Expand
      titleRemove Assign Cubes
      1. Select the cubeset in which you want to assign the cube. 
      2. Go to Action > Remove Assign Cubes.
      3. Remove Assign Cubes popup window will open.
      4. Cube Set and List of Cube of that cubeset will be populated. 
      5. Select the cubes you want to remove from the cube set. 
      6. Click on the Remove button to remove the cubes from the cubeset.


      Expand
      titleDelete Cubeset
      1. Select the cubeset in which you want to delete.
      2. Go to Action > Delete.
      3. You will get a message - "Are you sure you want to delete current Record?"
      4. If you click on yes, the cubeset will be deleted.




    Expand
    titleRemove from Cubeset

    You can remove particular cube from the cubeset. 

    Pre-requisites

    1. The users' role must have access to

    the 

    1. the Cube Manger feature by

    enabling app

    1. enabling app operation for the

    feature through 

    1. feature through Admin - Utility - Manage - Cube Manager.

    2. Cube must be created.

    3. Cubeset 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 Remove from Cubeset

    4. Go to Action > Refresh Status or press CTRL+ALT+F.

    5. Refresh Status popup window will open. 

    6. Select the Cubeset from which you want to remove the selected cube.  

    7. Click on the Remove button to remove the selected cube

    .

    ...

    1. .

    ...