CLEARBLOCK DYNAMIC

CLEARBLOCK DYNAMIC :

"This Calculation command is used to clear and remove blocks which contains the derived values from Dynamic calc and store member combination."

Now m going to explain how it works in real time as below.

As per definition,We need a member which contains "Dynamic Calc and Store" as a storage type.In Sample.Basic you can see “Diet” member under Product Dimension which is parent of few Shared members here and it has "Dynamic Calc and store" as a storage type.

For Better understanding this topic has been divided in to two parts.

Part 1 : How Blocks are creating for Dynamic calc and Store members?

As per below figure Sample.Basic has 175 Existing Upper-level blocks.

Purpose of Dynamic Calc and store member is calculated at time of first retrieval after that starts behaving as Stored Member. This means that block will be created when after first retrieval.

Retrieved the data for West->Diet member combination as below.

 Now Checking Statistics of Sample.Basic.

As per above Figure Sample. Basic has 176 Upper-level blocks.

Part 2 : Clear and Remove blocks using CLEARBLOCK DYNAMIC.

Here is basic Calculation Script which clears & removes blocks of derived values from Dynamic Calc and Store member combination.

//ESS_LOCALE English_UnitedStates.Latin1@Binary

FIX(@IDESCENDANTS ("Market"),@IDESCENDANTS ("Product"))

CLEARBLOCK DYNAMIC;

ENDFIX

After executing above calculation script.The Existing Upper-level blocks become 175 for Sample. Basic.

 Please write comments…Thanks