SET COMMANDS

In Continuation to the previous post on Calculation scripts below are some points

SET AGGMISSG:

• It will work with sparse dimensions.

Syntax

SET AGGMISSNG ON | OFF

• If you set OFF it wll not aggregate #missing values.
• If you have data at that combination so always keep it ON  to get accurate data.

Example:

                  Case 1 : I will write some calculation scripts.

SET AGGMISG OFF;

FIX(Account)

AGG(Period);

ENDFIX;

• Lock and send some data in to Q1;
• execute the script
• Q1 will hold some data. fig:13

                   Case 2 :

• Now Lock and send #missing.
• But still Q1 show the data. Which makes huge difference to our calculation.fig 14:

                   Case 3 :

SET AGGMISG ON;

FIX(Account)

AGG(Period);

ENDFIX;

• Now Q1  shows #missing.
• Always keep it on if you want correct values.

                                                fig 15:

SET UPDATECALC:

• This is a calculation command whih turns on/off inteligence calculation.

Syntax

SET UPDATECALC ON | OFF

• ON : It allows to calculate only dirty blocks i.e. the blocks which have been updated and their dependent parents
• If Essbase marks the block as clean block then it doesnot perform recalculation.
• If you want to change the default behaviour then use SET CLEARUPDATESTATUS in calculation scripts.
• OFF :   Essbase calculates all the data blocks regardless of weather they have been updated.

SET CLEARUPDATESTATUS:

Syntax

SET CLEARUPDATESTATUS AFTER | ONLY | OFF

• AFTER: Even if your calculating the subset of database , Essbase marks the datablocks as clean.

CLEAN AND CORRECT VALUE

• ONLY : It does same as AFTER  but doesnot perform the calculation it just remains the blocks a clean.

CLEAN BUT DOES NOT CALCULATE

• OFF :  Data values are calculated perfectly but blocks reamin dirty.