Pros and cons of ASO and BSO

As you have seen earlier in the chapter, there are some differences between the ASO and the BSO. Even though there are differences, we would like the reporting output to be the same and the analyst who is running the report should not even know to which type of database he is connected. Let us take some time to look at a few of the pros and cons between these two types of databases.

Pros and cons of BSO

The Essbase BSO is the original format of the Essbase database technology. The BSO is also the mainstay for Essbase as it offers robust, full-featured functionality. Here we will describe what we feel are some of the positive features of the BSO as well as some of the not so positive features for you.

Pros

Listed below are just a few high-level features that we feel makes the Essbase BSO a good choice:

• Several databases stored in one application.

• No reserved names for application and database names.

• Account dimension supports all types of calculations and attribute...