Oracle Essbase 9 Implementation Guide- P27: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. | Chapter 3 3. On the Dynamic Time Series screen select Y-T-D and GEN 3 as shown in the following screenshot 4. Once you click OK the outline will be updated to reflect to the changes that you have made as shown in the following screenshot Shared members Shared members are another great tool offered by Essbase to help you increase your data and reporting versatility in a simple and extremely efficient manner. In a nutshell a shared member is another occurrence of an already existing member in the outline. The shared member only stores a pointer to the existing outline member thereby giving serious space and processing efficiencies in the database. 115 Download at Building the Essbase Outline The benefits do not end there either. What you can do is have the shared member original member be a child to many different parents. For example if you have a product that is available in several markets you can organize your outline with the child members as needed for each market. The shared member can appear in several places simultaneously and be selectively calculated with relative ease. In the preceding screenshot notice how we have the individual vehicles located in three different groups in the database outline. The vehicles under the Total Vehicles parent are the original members and the vehicles located under Total US Vehicles and Total Canada Vehicles are the shared members. By doing this we can create different group totals from the same pool of members in the outline. There are only two main rules for Essbase shared members. You cannot tag a member as a shared member unless the same member already exists as a non-shared member and the shared members need to be the lowest members or the Level 0 members of their respective dimensions. Summary Well that wraps up the chapter on the Essbase outline. We know you ve been hit with a lot of information upto this point. There is a lot to know about the Essbase database outline. You have learned how to add dimension
