tailieunhanh - Oracle Essbase 9 Implementation Guide- P35

Oracle Essbase 9 Implementation Guide- P35:Essbase is a multidimensional database management system. The name Essbase stands for Extended Spread Sheet dataBASE. Using the custom add-in provides the end-user with near seamless compatibility in the Microsoft Excel spreadsheet program. | 5 Calculating your Essbase Cube Let s take a minute and review what we have completed so far. We now have a fully functioning Essbase operation set up. The server software is installed the client software is installed a real application and a database are built and the database is loaded with data. It s all there and ready for the heart of the system. If the database outline is the foundation of an Essbase database then the calculation scripts are the heart of an Essbase database. Although you can calculate both an ASO database and a BSO database unless otherwise noted the instructions in this chapter pertain primarily to the BSO. In this chapter you will learn about one of the most important pieces of functionality in Oracle Essbase. It is one of the main reasons why Oracle Essbase with its cube technology is so vastly superior to any relational database when it comes to data analytics analysis and reporting. This important functionality is the Essbase database calculation. To help you put the power of the Essbase database calculation to work for you we will take you through the steps needed to be able to create and run an Essbase database calculation script. We will also show you the various types of database calculation scripts. Essbase database calculation scripts can be in the form of an Essbase database calculation script file a database member formula written in the database outline and executed by a database calculation script or a database outline member formula executed by Essbase only when the data is needed dynamically calculated member . Download at Calculating your Essbase Cube One thing to keep in mind some Oracle affiliates have offered a three day database calculation class that only covers how to write Essbase effective database calculation scripts. We have mixed feelings on the real value of such a class. With the information we provide in this chapter combined with a little patience practice and common sense there is absolutely no .