TM1 Forum

Posted: **Mon Oct 27, 2008 5:05 pm**

Hello

I have a dimension called Departments.
Then I have a measures dimension called EmployeeMeasures with AvaliableHrs as a C: element composed by PayHrs and StdHrs.

Suppose I have the following department in the Departments dimension and three employees rolling up to it:

1820 - ControlFinance
*John D
*Arnie K
*Dan Lot

Is there a way to write a rule that zeroes AvailableHrs for 1820 - ControlFinance dep only??

Posted: **Mon Oct 27, 2008 8:40 pm**

Do you want it zeroed at ControlFinance level, or at Employee level? Here's a couple of options for either

Code: Select all

['1820 - Control Finance', 'Available Hours'] = C: 0; (Just does the consolidated level, doesn't affect employees)

['Available hours'] = C:
if(elisanc('Departments', '1820 - Control Finance', !Departments)=1 % !Departments@='1820 - Control Finance', 0, stet); (does both employees and Control Finance consolidation.  Check behaviour of Control Finance parents as it [i]might [/i]not do what you expect.)

[{'John D', 'Arnie K', 'Dan Lot'}, 'Available hours'] = C: 0; (Employees only, doesn't cater for new employees {} is shorthand for writing the same rule for lots of elements in the same dimension)

Note % is the logical "or"
elisanc is element is ancestor
When comparing strings you have to use @= not simply = (you can also use @<> for not equals for strings)

HTH,
Martin

TM1 Forum

RuleCalculation for an specific element

RuleCalculation for an specific element

Re: RuleCalculation for an specific element