Manual Cube Setup for Profit Module

New Profit cube can be set up manually by performing the following steps:

1. The files to update cubes are placed in the out-of-the-box Analytics folder (~\Prosperoware.Umbria\Default\Scripts\Analytics\init folder).

   Note: The files placed in this folder are commands to trigger cube processes and should only be deployed if cubes are set up and in use.

2. The following files in the folder are auto-deployed and should not be executed manually:

   • CalibanCubeDDL

   • ClearCache

   • Delete

   • Process

Note: The UmbriaAnalyticsDDL file is deprecated and no longer in use.

3. Execute the following files to update tabular cubes:

   • UmbriaAnalyticsTabular: This is the cube definition file for the analytical cube.
   • UmbriaAnalyticsTabularStats: This is the cube definition file for stats cube.

   Note: If cubes are used for the Profit module manually enter the encryption password in the UmbriaAnalyticsTabularStats file before deploying the cube.

4. Open the Stats file in the text editor and search for the following string: TOBEREPLACED. Replace the values in this placeholder with the actual encryption password for the profit module.
5. Save the file and open it in the SQL Server Management Studio (connect to the Analysis Services instance).
6. Execute the file.
7. Refresh databases. The UmbriaAnalytics database appears.
8. Expand Data sources, double-click UmbriaDS and change the settings for the connection (click on the first line and then the button with three dots appears).
9. Save data source changes.
10. Right click on cube, and click Process.
11. Right click on cube, and click Browse.
12. Click the Excel icon on the top to browse the cube in Excel.

Tip: When processing cubes if you encounter a timeout error, increase the timeout period. Right click the server name in Management Studio>select Properties>Check “Show Advanced (All) Properties”> then adjust the ExternalCommandTimeout setting. It is recommended to take a data back up before you redeploy cubes for new changes.