When Writting Fix Statement is there a Order of using Dimensions ?

Dear All,

In this Article we will be focusing on writing an article in which every Hyperion Calculation Scripts specialist once in the early stages of his career might have a doubt about it, I encountered myself this question couple of times.


To answer the question., 
Question : Is there an order of using dimensions in a Fix statement ?

Answer :  No the order of dimensions in a Fix statement don't make any difference






For example :: 

There should be no differene between a
Fix(Sparse)
Fix (Dense) 

and 
FIX(Sparse, Dense) 

as the fixes would be unioned together internally

Maintenance scripts - Calculations

//ESS_LOCALE English_UnitedStates.Latin1@Binary

/* Author: Jay Raghupathruni, Script is part of the yearly maintenance */

Yearly maintenance calc script ---As a Hyperion Administrator, you get Monthly, Quarterly, Yearly tasks to maintain Planning/Essbase applications...

Scenarios that a request can be -

1. We want to clear whole year : wow that’s simple1

     

2. Clear Budget data for year FY10, remove data for Descendants of Entity dimension, excluding Descendants(Parent1)

similarly there might be a request for writting a script from scenario dimension, asking to eliminate few selected from say 50+ members...