Your server may have dozens or even hundreds of cubes on it. A common strategy with a large and slowly changing Measures dimension (or some other dimension like Product) is to spin off a copy of the cube after a certain time period, typically the fiscal year end. There are a number of different reasons that you might do this. First, the cube may simply focus on Current Year and Prior Year, or a fixed number of years and scenarios such that the cube becomes too unwieldy when you start adding more. Second, if you need to be able to go back and pull a report so that it looks exactly how it did in a certain fiscal year, then you may need to spin off the cube. Depending on how many cubes you end up spinning off for each fiscal year, it may be necessary to go and clean them up at some point, but you might still want to keep them around, just in case. You can do this by hand by stopping the app, zipping up the app folder and all its contents, and deleting the app from within EAS.
Here is an example of a batch file you could use on Windows. This relies on the free 7-Zip package being installed somewhere. The nice thing about this approach is that while it uses MaxL, it doesn’t actually have any MaxL files — it just injects the MaxL command via the command-line. Edit the variables for your setup, and you’re on your way. It’s not pretty but it’s nice if you have to go cleanup a bunch of apps! Happy cubing — Jason. [download zip of the following batch file]
@echo off SET USER=adminuser SET PW=adminuserpw SET SERVER=essbaseserver SET APPPATH=D:\Essbase\App SET ZIP="7zp\App\7-Zip\7z.exe" @echo. @echo ------------------------------------------- @echo This is the cube archiver utility... @echo. @echo Looking for App %1 ... IF NOT EXIST %APPPATH%\%1 GOTO NoApp @echo. @echo I found it at %APPPATH%\%1 ... @echo. @echo Attempting to stop the app... REM essmsh -l %USER% -p %PW% -s %SERVER% StopCube.msh %1 echo alter system unload application %1; | essmsh -s %SERVER% -l %USER% %PW% -i @echo Archiving the app ... %ZIP% a -tzip EssApp_%1.zip %APPPATH%\%1 echo. choice /M "Okay to delete app %1" IF ERRORLEVEL 2 GOTO Done echo alter application %1 enable startup; | essmsh -s %SERVER% -l %USER% %PW% -i echo drop application %1 cascade force; | essmsh -s %SERVER% -l %USER% %PW% -i GOTO Done :NoApp @echo I could not find that app at %APPPATH%\%1 !!! :Done