- Data storage Properties defines when and where the consolidations are stored.
- We can specify data storage properties for members.
- For example, by default, members are tagged as store data.
- Essbase sums the values of store data members and stores the result at the parent level.
- For example, you can change a store data member to a label only member.
TYPES OF STORAGE PROPERTIES:
- store
- dynamic calc
- dynamic clac and store
- never share
- label only
- shared member
let us know in detail about storage properties:
STORE:
- Store data is the default storage property.
- The member stores data.
- In th above example, "FY10" member is of store property which is default one.
- Whenever a member is tagged as "store", we need to launch default calculation ,when we connect to smart view.
- As shown in the below image we need to launch the default calculation:
DYNAMIC CALC:
- Data associated with this memeber is not calculated until it is requested by user,calculated data is not stored.
- It is discared after the request is completed.
- NOTE:If we tag level 0 member as dynamic calc we need to attach formula to it.
- Storage space will be reduced and default calculation time will get reduced.
DISADVANTAGES:
- Retreival time may increase.
below example gives us clear explaination.
In the above image,"usa" is tagged as "dynamic calc", as soon as we connect to smart view the memners of usa should roll up to its parent with out any default launcher.
DYNAMIC CALC AND STORE:
- The calculated data is then stored.It has both the properties of dynamic calc and store.
- Data associated with this memeber is not calculated until it is requested by user,calculated data is not stored.
- It is discared after the request is completed.
- NOTE:If we tag level 0 member as dynamic calc and store we need to attach formula to it.
- Default calculations time will get reduced.
SHARED MEMBER:
- A shared member is used to create alternate hierarchies. The data for shared members come from the original member. There is no storage space reserved for the shared member.
- Below rules must be followed for shared member:.
- A shared member name must be same as the original member.
- The shared member must come after the original member.
- The shared member and the original member must belong to the same dimension.
- We can create any number of shared members in an outline.The shared member cannot have the formula, UDA, Attribute attached to it.
- The shared member can have an alias.The shared member cannot have child members.
- In the above example,we have annathapur as a menber under same hierarchy.
- When we connect to smart view we need to get same data for ananthapur under "AP" and ananthapur under "TG",we can see in below image.
LABEL ONLY:
- Although a label only member has no data associated with it, it can display a value. The label only tag groups members and eases navigation and reporting. Typically, label only members are not calculated.
- We can tag Label only non-Level 0 members only. When we tag parent member as label only, the parent will not get calculated from its child and time is no storage space reserved for the parent member also.
- It displays the first child data.
- In the above example,"usa" is tagged as label only.
- When we connect to samrt view data associated with member "mi" will be diaplayed.
NEVER SHARE:
- It avoids implied sharing.
- Tag the parent member , never share , when you don’t want the value of to be implicitly shared with the parent member.
- The data associated with the member is duplicated with the parent and its child if an implied shared relationship exists.
What is implied sharing?
- When a parent has only one child, it doesn’t need to calculate the parent member.
- Its simply refers the value from it’s child.
- In the above example,as "p3"is tagged as never share,simply it refers the value from its child.
No comments:
Post a Comment