Oracle Essbase 9 Implementation Guide- P20: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. | Building the Essbase Outline For example - TOTAL SALES 2 SALES DISCOUNTS - In the above formula TOTAL SALES SALES DISCOUNTS -1 Member storage When you create a member in Essbase you need to tag the member with a storage property on how the data is stored for this member. By default when a member is created it is tagged as Store Data. You can change the member storage option in Member Properties Data Storage. The different storage options available to you are explained as follows Store Data Stores the data value with the member. The data can be the result of a calculation data load from an external source or an Essbase Lock and Send directly from Microsoft Excel using the Essbase Add-in for Microsoft Excel. The data is physically stored in the database. Dynamic Calc and Store The first time the data is requested Essbase will dynamically calculate it and then store it with the member. Essbase will automatically recalculate the data and update the stored values on the next request for data if a component value used in the member formula changes. At the first call for a dynamically calculated and stored member s data value the data is dynamically calculated and physically stored in its proper cell in the database. Unless a component value of the now stored data value has changed the data is not dynamically calculated again. Dynamic Calc Essbase does not physically store the calculated data value at all and only calculates it on demand. This is a good option if database size is an issue as it helps keep the database smaller. Some care must be exercised because dynamic calculations tend to consume large amounts of resources. Balance is the key here. Never Share Does not allow Essbase to implicitly share this member. What this means in Essbase is when you have a member that only has one child member that member implicitly takes the value of the only child. There are times when you do not want this to occur. You can still share this member explicitly by creating another .
