I have a technical question regarding feeders.
I have the following situation and want some advice as to the best way to feed.
I have the following example of a rule used in a relatively small cube designed to calculate Employers NI rates:
Code: Select all
['st_to_pt'] =
DB( If( ['Annual_Salary'] = 0, '',
'lkup_NIRates'),attrs('F_Employee',!F_Employee,'NIRATE'),'ST_to_PT',!C_Year,!B_Versions,'BandWidth');
My question is am I better to use Annual_Salary as the feeder or am I better to put the feeder in the other cube and feed from there?
My current thinking is that I should use Annual_Salary, which seems to be working perfectly fine but just wanted some best practice advice.
cheers, Mark