Content Comparison

Ginesys Version A new version of Cube Manager has been released in Ginesys version 11.145.6 carries with it the updated version of Cube Manager. Users may enjoy all the features of the Cube Manager by updating to this Ginesys version. This article relates to updating 11.145.6 along with Cube Manager.

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.

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.

   6.
   
2. Update Ginesys HO and the following message is seen -"Error occurred while synchronizing OLAP Write Database Schema with Application Database. OLAP Write Database connection is not available. Skipping OLAP Schema Sync Process". 
   1. If you update till the latest available version (i.e. 11.145.x) you will need to Configure Cube Manager.
   2. If you update to any version below 11.145.x - you can just close the Auto Updater and restart your services and your software.
The user can setup Cube Manager, only when he has the app operation privileges to do so. Otherwise the Ginesys Admin in your organization provides privileges of Setup app operation for Cube Manager to the currently logged in user or a person with the proper privileges needs to open the Setup and configure the same.
If the Cube Manager is being setup for the first time the list view will appear now ready to start working.
For an existing user of OLAP Database, the OLAP Schema Sync process has to be completed by clicking on Update OLAP Database button, in the Tools tab of the HO Auto Updater.
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 Report Data Store (Write Database) - If it cannot connect Report Data Store (Write Database), 
3. 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.
4. It will return to the Auto Updater. 
Close the Auto Updater window.
If Auto Updater can connect the Report Data Store (Write Database), then the OLAP Database will updated. Last available "OLAP Version" will be displayed.
If you get any error at the time of Cube Refresh for existing Custom Logic, please log a ticket with the https://care.ginesys.in/ 

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

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

7. Select database updates to be applied till 11.145.9 or above (as necessary for you).
8. Click Apply Selected Updates and your database patches will start getting applied.
9. 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.
10. Let the Auto Update finish its Ginesys Application Update.
11. 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.
12. 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.
13. 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.
14. 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.
15. 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.
16. 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.
17. 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.
18. On successful completion of this step, your Cube Manager will be migrated to latest configurations and is ready for use.
19. If anywhere during the above steps you see an error that is not mentioned here please contact Ginesys Care.