I am having an issue with a feeder. I am trying to feed Standard hours into Labor cube and after I wrote a feeder like below, it just consumes all the memory and does not return until the server runs out of memory and I kill the service and restart.
Feeder:
Code: Select all
['Standard Hours'] => DB('Labor','All Projects', 'All Employees',!Months,'Forecast','Productive Hours') ;
1. Months
2. 'Standard Hours'
'Labor' Cube has 5 dimensions
1. Version
2. Project
3. Employee
4. Months
5. 'Productive Hours' Measure
When I tried to feed one Project and one employee, everything is fine.
Code: Select all
['Standard Hours'] => DB('Labor','02880.00.02', '900040',!Months,'Forecast','Productive Hours') ;
Code: Select all
['Productive Hours'] = N: DB( If( ATTRS('Versions', !Versions, 'LiveVersion') @= 'Y', 'StandardHours','') , !Months,'Standard Hours') ;
Thanks,
Paul.