Data Copy in an ASO Application
For those of you familiar with Essbase, when creating an Essbase application there are two types available; BSO (Block storage) and ASO (Aggregate storage). Typically, BSO applications are used when the requirements involve complicated calculations, whereas ASO applications are used if the model contains large dimensions and does not require any complex calculations. One of the main problems with ASO databases in the past was finding a way to perform calculations such as a standard data copy from one member to another – a task that is extremely simple in a BSO application. You see, unlike in BSO applications, ASO applications don't give you the ability to write and execute calculation scripts. However, there is a way round this which uses MaxL along with an external calculation script and a little bit of MDX. Below illustrates a copy from scenario Actual to Forecast for months April to August. The MaxL Script is as follows: execute calculation on database MyApp.MyDB wit...