Help with intercube feeders

[Unwin354]

Hi, I’ve been using tm1 as user only for a couple of year but I am very new to cube and rule building and I was hoping for some help. I have managed to get part of the way on something that I am working but from what I can find on the forum it looks as though I need to work on the feeders but to be honest I’m getting a little confused. I have three cubes

Cube1: FN_IncentiveRates
Dim1: FN_FiscalYear
Dim2: FN_IncentiveCode
Dim3: FN_BonusType

Cube2: FN_IncentiveSales
Dim1: FN_FiscalYear
Dim2: FN_Ledger
Dim3: FN_AccountingPeriod
Dim4: FN_SalesGroup
Dim5: FN_Incentive_Salary_Measure

Cube3: FN_IncentiveSalaries
Dim1: FN_AccountingPeriod
Dim2: FN_EmployeeDetails
Dim3: FN_FiscalYear
Dim4: FN_Incentive_Salary_Measures

In my FN_IncentiveSalaries cube I have managed to write the following rule. Is calculating a bonus incentive for a staff member based on whether Sales have been met for a Sales Group. I have gotten the rule work and return a value but when I put zero suppression on my results disappear I know this due to the feeder but I’m not sure how to write this any help would be appreciated.

Code: Select all

['3rd Quarter','Incentive']=C: if(DB('FN_IncentivesSales',!FN_FiscalYear,'Actual V Budget','3rd Quarter',ATTRS('FN_EmployeeDetails',!FN_EmployeeDetails,'Sales Group'),'Sales')>1,

		['3rd Quarter','Transactions']* DB('FN_IncentiveRates',!FN_FiscalYear,ATTRS('FN_EmployeeDetails',!FN_EmployeeDetails,'Incentive Code'),'All Bonus Types'),stet);

[garry cook]

['3rd Quarter','Incentive']=C:

The rule you have is calculating at a C (consolidated) level only so you will either need to feed the data beneath the consolidation in order for TM1 to recognise that the consolidation needs to be fed or make sure that there is data in one of the children. Is the C level rule intentional? Makes sense to do this for Percentages / ratios / etc but looks like this is a simple bonus value aggregation so would first consider using an N level rule if possible and feeding this unless there is good reason for the C: only rule.

The IncentivesSales appears to be where the Sales data is held and should therefore be where the feeder originates from but by the look of it, you may have to overfeed slightly to get back to the EmployeeDetails level. Probably easiest to do this via TI using the Attribute lookup on EmployeeDetails to create consolidations within the SalesGroup dim and feed these direct assuming the consolidations aren't huge.

Depending on the data structures, you may be able to get away with feeding straight from Transactions (depending on what this data actually is) but be careful if you think of using conditional feeders to check Sales values if you go down this route - a quick search on the forum will give you a good appreciation of the pros / cons of using conditional feeders.


PS - As an aside, is this right -

,!FN_EmployeeDetails,'Sales Group'),'Sales')>1,

?

Need to check this shouldn't be >0 otherwise you risk missing data if only 1 Sale is made.