Versions Compared

Version Old Version 21 New Version Current
Changes made by

Deepankana Roy

Deepankana Roy

Saved on

Key

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

...

On Ginesys Application update: Update Read database version.

On Cube version update: Update Write database version

A new version of Cube Manager has been released in Ginesys version 11.145.9. This update may have some interference with your operations, if you are using OLAP cube based reports. In this version, there are some major overhauls in the configuration management of cube based reporting and cube refreshing mechanisms. This article will help you update your Ginesys installation to the new version with minimum friction in reporting. However, it is still recommended to apply this update at a time when small disruption of cube based reports will not cause immediate impact and thereby allow some time for Ginesys support to address the issue. 

This is a simple step by step guide without much detail about every step and will help you setup your new cube manager configuration quickly. If you need a detail understanding of the modules, please follow dedicated articles on new cube manager setup and configuration.

Page Properties
idUpdate of Cube Manager

This article describes the process of update Cube Manager through HO Auto Update. 

Warning

Alert: New Auto Updater will have to be downloaded after this change, for further version update.

Note

Note: Ginesys HO Auto Update will now reflect the OLAP Version, along with database and Software Version, will be displayed at the bottom of the Auto Update.

    After Completion of OLAP Database configuration, you need to update OLAP Database after completing the update of Database and Software. In the Tool tab you will get Update OLAP Database button.
Tip

Note: You can see a progress bar <> in the Auto Updater after any modification in OLAP Database. 

At first you need to update Ginesys HO. How To: Update Ginesys HO using Auto Update will describes the HO Update process. 
Now You need to setup Cube Manager. How To: Configure Cube Manager will describes the Setup Cube Manager. 
  • After Setup Cube Manager, you need to Configure Cube Manager. How To: Configure Cube Manager will describes the Configure Cube Manager. 
    • After configuration when you will update cube manager, following scenario may be occurred.  The Auto Updater checks for Write database connection details.If it cannot connect to the Write database during update for any reason, it will skip the update of Cube Manager. The Ginesys application changes, if any, will be updated. After completing the application update, it will display a message – “Version update for cube manager is not done, due to non-availability of cube server. Please update before checking any cube reports.”
    If Auto Updater can connect the Write database, then it will check, if the Cube Refresh process is on -
    If the Cube Refresh is in progress, then it will not update the Cube manager and displays a message - "Cube refresh is in progress, unable to update."

    If the Cube Refresh is not in progress, then it will update MISRETAIL (Write) database as required.

    Tip

    The OLAP Database or Report Data Store (Write) database is called MISRetail

    It will also update Ginesys application changes if any are available.
    Close the Auto Updater.
    If the Cube Manager update is failed during the update process of Ginesys application, new function button 'Update OLAP Database' that has been added to Auto Updater > Tools tab will be enabled.
    If you click on the Update OLAP Database button, OLAP database version will be checked by the system.
    If the version is found to match, the following message will be displayed - “Cube Manager is already updated till latest available version.”
    If the version does not match, it will check the connection for Write database - 
    If it cannot connect Write database, the Cube Manager update will be skipped and "Version update for cube manager is not done, due to non-availability of cube server. Please update before check any cube reports." – message will be displayed.
    If Auto Updater can connect the Write database, then it will check if the Cube Refresh process is in progress.If the Cube Refresh is in process:It will not update the cube manager and displays a message - "Cube refresh is in progress, unable to update."If no cubes are being refreshed - 
  • Last available "OLAP Version" will be displayed.
  • MISRETAIL Database will be updated with the patch update as required.
  • If the multiple releases with OLAP related updates are found, all the changes will be reflected within a single round of update.
    • Close Auto Updater.
    Info
    titleImportant
    Info
    • If you are updating to any version below 11.145.9, you can ignore this article.
    • If you are not using cube based reports, you can ignore this article.


    Warning
    iconfalse

    You will not be able to update to version 11.145.9 by Auto Update if any of the following is true. Please contact Ginesys Care if such is the case for you.

    • You are running Oracle Enterprise Edition database.
    • You are running cube based reporting based on multi-database configuration.

    Steps to follow - 

    1. The new version of Auto Updater (version 12.0) will have to be downloaded before update of Ginesys version 11.145.9. Run your current Auto Updater, click Click for newer version of Auto Update link on top right corner of the window and download new version of Auto Updater.

    2. Verify that your Auto Updater is showing version 12.0 before proceeding further.

      1. This version has the features for updating OLAP cube data structures automatically and will also show your current OLAP version in addition to your software and database versions.

    3. Select database updates to be applied till 11.145.9 or above (as necessary for you).
    4. Click Apply Selected Updates and your database patches will start getting applied.
    5. On completion of the database update process you will see a message "There was some issue while updating OLAP database". Ignore this message for now.
    6. Let the Auto Update finish its Ginesys Application Update.
    7. Go to 'Admin > Utilities > Cube Manager' and you will see the following message "Cube manager needs to be configured.". Click OK and continue. Cube Manager setup window will now open.
    8. You are now presented with 3 database connection configuration with Ginesys Database Server connection already provided. This window allows advanced configuration of OLAP cubes using multiple databases.
      1. If you are using multiple databases for cube management, please stop at this point and call Ginesys Care now to assist you with multi database OLAP cube setup.
      2. Else please proceed as below.
    9. Check the Same as Ginesys Database Server checkboxes in the 'Cube Read Database' and 'Cube Write Database' connection. Please click Proceed on confirmation messages that may come on clicking the checkboxes.
    10. Click Configure button on bottom left of the window. The system will start showing a wait message as Configuring...Please wait. This process will be migrating your cube configurations to latest versions.
    11. On successful completion of the process, an information message showing "Migration completed successfully. Please run 'Update OLAP Database via Auto update'" will be shown. Click OK.
    12. Now run Auto Updater once more and go to the Tools tab to update the OLAP cube data structures.
      1. NOTE: For this action of Auto Update there is no need to stop License and other services.
    13. Click Update OLAP Database button. This button will be updating your cube related database objects to latest version and will take some time to complete. Please don't close the window till it is processing.
    14. On successful completion of this step, your Cube Manager will be migrated to latest configurations and is ready for use.
    15. If anywhere during the above steps you see an error that is not mentioned here please contact Ginesys Care.


    Warning
    titlePlease consider the following warnings after update
    • If you have been using any custom logic for refreshing your cubes other than the generic logic (stored procedures), your cubes will be overwritten with generic logic. The custom logic has to be re-applied with the help of Ginesys Care.
    • Schedules already defined for Cube-sets will be terminated and have to be re-scheduled after Cube Manager setup is done.