I have a cube that includes 2 dimensions, Cost Centre and Status.
The status has 2 elements, Status_Number and Status_Description.
There is a rule on the cube as follows:
Code: Select all
['Status_Number'] = N:
if(ATTRN('F_CostCentre', !F_CostCentre, 'CC_DsbldFlagN') = 1, 4, stet);
['Status_Number']=C:9;
['Status_Description']=S:
if(['Status_Number'] = 0, 'Not Started',
if(['Status_Number'] = 1, 'Preparing',
if(['Status_Number'] = 2, 'Staff Budget Submitted',
if(['Status_Number'] = 3, 'MTFS Agreed',
if(['Status_Number'] = 4, 'Disabled', 'No Status')))));
I am looking for a way to set the consolidation based on the statuses of the children, so for example if all children are Staff Budget Submitted then consolidations are set to Staff Budget Submitted, if 4 out of 5 children are set to Staff Budget Submitted but 1 is set to Preparing then consolidations are set to Preparing etc etc.
While scratching my head as to how to achieve this I can’t think beyond the use of a TI to set the Status_Number for consolidations based on various logical conditions (which I envisage to be a bit of a minor nightmare). Can anyone suggest an easier approach or am I on the right lines with the TI approach.
Cheers, Mark