Page 1 of 1

Sparse and Dense Conditional Feeder

Posted: Thu Nov 12, 2009 6:38 pm
by TM1inChickcago
I'm Cognos Planning person new to TM1 and am having difficulty with feeders. . .

TimeEntries Dimension consists of specific elements (employees) and generic elements (TBD Postions). Specific element cells have a specific office, unit, and depts to which they belong. Generic elements belong to all offices, units, and depts. Working Days is an attribute of the Months dimension.

Following rule exists to populate Working Days:
['Working Days' ] =n:
IF(SUBST(DIMNM('TimeEntries', DIMIX('TimeEntries', !TimeEntries)),1,3) @= 'TBD',continue,
IF(DB('Time_Assump', !TimeEntries, !Versions, 'Office Code Assigned') @= DIMNM('Office',DIMIX('Office', !Office)), continue, stet));

['Working Days'] =n:
IF(SUBST(DIMNM('TimeEntries', DIMIX('TimeEntries', !TimeEntries)),1,3) @= 'TBD',continue,
IF(DB('Time_Assump', !TimeEntries, !Versions, 'Dept Code Assigned') @= DIMNM('Depts',DIMIX('Depts',!Depts)), continue, stet));

['Working Days' ] =n:
IF(SUBST(DIMNM('TimeEntries', DIMIX('TimeEntries', !TimeEntries)),1,3) @= 'TBD',continue,
IF(DB('Time_Assump', !TimeEntries, !Versions, 'Unit Code Assigned') @= DIMNM('Units',DIMIX('Units', !Units)), continue, stet));

['Working Days'] = n:DB('}ElementAttributes_Months', !Months, 'Working Days');


As far as I can tell the rules populates as expected.

I cannot write the feeder though:
Feeder:
['Working Days' ] => DB('Rev', 'Scenario 1', IF(SUBST(DNEXT('TimeEntries', DIMNM('TimeEntries',0)),1,3) @= 'TBD', 'Consolidated',
DB('Time_Assump', DNEXT('TimeEntries',DIMNM('TimeEntries',0)), 'FY Budget Current', 'Office Code Assigned')),
'TOTAL TBDs', !Months, 'FY Budget Current',
IF(SUBST(DNEXT('TimeEntries', DIMNM('TimeEntries',0)),1,3) @= 'TBD', 'All Units',
DB('Time_Assump',DNEXT('TimeEntries', DIMNM('TimeEntries',0)), 'FY Budget Current', 'Unit Code Assigned')),
IF(SUBST(DNEXT('TimeEntries', DIMNM('TimeEntries',0)),1,3) @= 'TBD', 'All Depts',
DB('Time_Assump',DNEXT('TimeEntries', DIMNM('TimeEntries',0)), 'FY Budget Current', 'Dept Code Assigned')),
DNEXT('TimeEntries', DIMNM('TimeEntries',0)), 'Working Days');

It does appear that the above feeder does read the IF statements but only for one TimeEntry; it doesn't cycle through all TimeEntries and I need it to cycle through all TimeEntries