• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

DATA STORAGE PROPERTIES in EssBase

DATA STORAGE PROPERTIES

There are six properties available in Essbase Database. Those are

  • Store Data “S”
  • Dynamic Calc “X”
  • Dynamic calc and store “V”
  • Label only “O”
  • Shared members “H”
  • Never Share “N”

 

Store Data:

By Default the storage type of any member is store data. That means data is stored for that member combinations. If it is a parent member, the member is calculated from it’s children and gets stored in database(i.e. in page files)

 

Dynamic Calc:

When we tag a parent member as Dynamic calc the member gets calculated during retrieval time and Analytic a\services don’t reset the storage space for the member combinations. During default calculations, the member won’t get calculated; installed it will get calculated during retrieval only.

 

Advantages:

Storage space will be reduced and default calculation time will get reduced

 

Disadvantages:

Retrieval time may increase now.

 

Note: We cannot Dynamic calc on a level 0 member. We can tag on level 0 member, only if it has a formula attached to it.

 

QTR1 2007(Dynamic calc)

JAN 2007

FEB 2007

MAR 2007

Right click on any member and click Edit Member properties. Click Data storage. A drop down appears and Select Dynamic calc.

 

Dynamic calc and store:

When we tag a parent member as Dynamic calc and store, the member calculated during retrieval time and Analytic services don’t reserve the storage space for the member combinations. During default calculations, the member won’t get calculated; instead it will get calculated during first retrieval only and it writes the data into Essbase data base. Only first user may face some issues with retrieval time. For subsequent users, it is same as Store Data only.

 

Advantages:

Default calculations time will get reduced.

 

Disadvantages:

Retrieval time may increase now for the first user only. If two many concurrent users are there, it’s better of use Dynamic calc instead of Dynamic calc and store.

Note: We cannot tag Dynamic calc and store on level 0 member. We can tag on level 0 member, only if it has a formula attached to it.

QTR1 2007(Dynamic calc and store)

JAN 2007

FEB 2007

MAR 2007

Right click on any member and click Edit Member properties. Click Data storage. A drop down appears and Select Dynamic calc and store.

 

Label Only:

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 it’s child and time is no storage space reserved for the parent member also. We can save some time during default calculations and also we can save some storage space. Apart from the table only mainly eases navigation in report. It’s a dummy parent which is used to group together some members.

In the below example, cards related is a parent which is used to group related members

Measures dimension is the best example for Label only

Measures (Label Only)

 

1

 

In this example, Cards Related to label only. Cards related will not get calculated from CARDS REJECTED and CARDS ACTIVATED members Cards Related member will not have any spacer also reserved for it. In the reports, we can easily select the Cards related information.

Note: It doesn’t matter, what symbol is there on the child members under label only parent.

Right click on any member and click Edit Member properties. Click Data storage. A drop down appearsend Select Label only.

Summary
Review Date
Reviewed Item
DATA STORAGE PROPERTIES in EssBase
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on DATA STORAGE PROPERTIES in EssBase"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.