Databases Reference
In-Depth Information
For example:
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 member of the same name and selecting
Shared Member
as its storage option.
