Manual Cube Setup for Profit Module
New Profit cube can be set up manually by performing the following steps:
- Update trunk SVN. Locate the file under Caliban.Db/Analytics/Init/UmbriaAnalyticsDDL.xmla.
- Open the file in the text editor and search for the following string: TOBEREPLACED. This value (it appears 7 times) should be replaced with the actual encryption password for the profit module.
- Save the file and open it in the SQL Server Management Studio (connect to the Analysis Services instance).
- Execute the file.
- Refresh databases. The UmbriaAnalytics database appears.
- 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).
- Save data source changes.
- Right click on cube, and click Process.
- Right click on cube, and click Browse.
- 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.
