tailieunhanh - Oracle Essbase 9 Implementation Guide- P42

Oracle Essbase 9 Implementation Guide- P42: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. | Calculating your Essbase Cube In the following screenshot you can see how the vehicle totals are correct because the vehicle dimension has already been calculated Jan 2009 Feb 2009 Mar 2009 Qtr 1 2009 Sporty 4000 300 4000 0 Reserved 5000 7800 5000 0 2 Door Sedan 9000 8100 9000 0 Functional 750 4000 750 0 Flashy 1350 5000 1350 0 4 Door Sedan 2100 9000 2100 0 Worker 12500 750 12500 0 Player 350 1350 350 0 4X2 Pickup 12850 2100 12850 0 Muddog 300 4000 300 0 Climber 7800 5000 7800 0 4X4 Pickup 8100 9000 8100 0 Total Vehicles 32050 28200 32050 0 Now that we have the sales rolled up in the vehicle dimension we can now calculate the Calendar Periods dimension which will roll up the values of the months to the quarters and then to the years. Can you imagine how the numbers would look if we rolled up the Calendar Periods dimension first Jan 2009 Feb 2009 Mar 2009 Qtr 1 2009 Sporty 4000 300 4000 8300 Reserved 5000 7800 5000 17800 2 Door Sedan 9000 8100 9000 26100 Functional 750 4000 750 5500 Flashy 1350 5000 1350 7700 4 Door Sedan 2100 9000 2100 13200 Worker 12500 750 12500 25750 Player 350 1350 350 2050 4X2 Pickup 12850 2100 12850 27800 Muddog 300 4000 300 4600 Climber 7800 5000 7800 20600 4X4 Pickup 8100 9000 8100 25200 Total Vehicles 32050 28200 32050 92300 190 Download at Chapter 5 Looking at these examples can also give you a good idea of why it is so important to correctly set up your dimensions with regards to the Dense and Sparse settings. You can take solace in the fact that this only applies to BSO databases and there are no Dense or Sparse considerations for ASO databases. ASO databases only contain Sparse dimensions. Using Substitution Variables One of the coolest things in Essbase is the substitution variable. Substitution variables are like global variables that can be defined once and then used anywhere in Essbase you want to. The main use for substitution variables is to create a dynamic easy to use variable which will change with time. Each .