Converting from BSO to ASO using migration utilities

Converting from BSO to ASO using migration utilities

An Aggregate Storage Application is used to create aggregate storage database. Only one database can be created using Aggregate Storage Application. Conversion of Block Storage Outline to Aggregate Storage Outline can take place but vice versa is not possible.

BSO Limitations:

1. BSO is widely used in financial applications,that are more densely populated.
2. Outline size is limited in BSO
3. Loads and Calculations are required for batch times. Whenever a new data is loaded, batch calculation is essential, which is a scheduled recalculation of the database, which is time consuming and may also require users to be disconnected for a certain period of time.
4. Limited numbers of dimensions are used in BSO.
5. Use of calculation scripts is helpful in complex calculations.

ASO Limitations:

1. Maximum number of dimensions can be used.
2. Replicated, Transparent and Linked type of partitions can be used.
3. Storage of up to 2⁵² dimensions is possible.
4. At zero level members only data is stored.

When to use ASO:

1. When the database is sparse and with more than 12 dimensions and having one or more dimensions tens of thousands of members.
2. When there are no changes/updates or when less number of updates are to be performed.
3. When complex calculations are not required and depend only on summarizing the data.

Steps required converting BSO to ASO:

• Review the structure of 5 dimensional Samppart outline.

In the navigation panel of Essbase servers enlarge the Samppart application and double click on outline

• Outline is displayed as:

Revolutionize Your Business With Generative AI

From product design and software development to virtual agents, content creation, and reporting, GenAI is transforming business. Our AI experts help you unlock GenAI’s full potential and drive growth.

Let’s Get Started

• For conversion of BSO to ASO goto File à Wizards àAggragate Storage outline Conversion.

• Now select source outline screen.

• Select Essbase Server in Source outline and select company.otl then click next.

• Verify corrections to outline, click on next.

An ASO can be directly created from outline wizard.

• Select destination for aggregate storage outline.

Click Create Aggregate storage application.

• Give the application and database norms for ASO
• Now click Ok

• Click Finish and now we can see ASO Application in Administration console.

• We can observe the differences of BSO and ASO outline.

Changes we observe after converting BSO to ASO.

• In BSO, hierarchy information of the member is not found, whereas in ASO, we can find it, as well as, can specify whether the hierarchy is stored or dynamic.

• Calculation Scripts which we perform in BSO will not work in ASO, for which, we have to write Multi Dimensional Expression (MDE) script in ASO.
• “Solve Order Property” is used in ASO instead of Two Pass calculations in BSO.