The Oracle Business Intelligence team recently announced the availability of a new virtual box appliance, courtesy of the Oracle Technology Network – the Oracle Business Intelligence Enterprise Edition SampleApp V305, which can be downloaded from the OTN. This sample application is packed with a number of OBIEE examples which manifest OBIEE 11.2.1.7’s features and capabilities as well as the best practices of design.
Some of the major focal points of the sample application include:
- Advanced set up and expandability owing to features like automatic detection of the IP address and an enterprise install of 64bits.
- Integration of multiple features with Business Intelligence such as :
- Business Intelligence plus Oracle R Enterprise
- Business Intelligence plus Endeca
- Business Intelligence plus Essbase
- Business Intelligence plus Database Advanced Analytics
- Business Intelligence plus Oracle Enterprise Performance Management system and the Financial Reporting system.
- New features of Business Intelligence.7 like the front and back end.
- Several other miscellaneous functions like generator of physical structured query language, simulation of concurrency, Business Intelligence functional interactions, etc.
Programmers will probably remember that the previous Business Intelligence Enterprise Edition 11.1.1.6.2 by Oracle had a similar Essbase integration. The limitation with this was the single dimensioned nature of the Essbase Aggregate Storage Option databases created by the persisting aggregates to the Essbase ASO cubes. The persisting wizard created data bases which could have only one aggregation, since it worked with only relational data bases.
The SampleApp v305 however overcomes this limitation using what it calls as Cube Spin Off – the Oracle Essbase Interaction (8.21) dashboard. This dashboard is a preview of sorts which will let users pick up any data from within the subject area, adjunct it as a cube (Essbase) and also report against it in an automatic fashion – thus allowing for a quicker reporting and increased accessibility to forecasts, Multidimensional Expressions functions, etc.
Another interesting thing to note here is the type of database created. It’ll get clear from the way the cube is defined. The database cube is a Block Storage Option database, and not an Aggregate Storage Option database like the ones created by the Aggregate persistence wizard of the Business Intelligence Administration tool. These BSO databases also take care of the unavailability of member name restriction when building cubes across relational database sources. They have been designed to accord across all levels and dimensions, as well as duplicate names of members. The SampleApp has been made available on the Oracle Technology Network and thus can be freely downloaded and used.
Please Share This Knowledge With Others!