Cube data is IN;
Actuals pre_10-1
Code: Select all
Organisation Breakdown pre_10-1
Resource Breakdown
Nomination
Site
Resource Source
MonthYear
Employees
Actuals Measures
SKIPCHECK ;
FEEDERS ;
# Feed Ops Plan and Actuals
['Actual Headcount'] =>
DB('Ops Plan and Actuals pre_10-1','Actuals','Actual Headcount','Current',!Nomination,!Resource Source,!Organisation Breakdown pre_10-1,!Resource Breakdown,!Site,!MonthYear);
Cube i'm trying to populate with a rule;
Ops Plan and Actuals pre_10-1
Code: Select all
Source Type
Ops Plan and Actuals Headcount
Version
Nomination
Resource Source
Ops Plan OBS pre_10-1
Ops Plan RBS
Site
MonthYear
SKIPCHECK;
['Actual Headcount']= N: DB('Actuals pre_10-1',!OPS Plan OBS pre_10-1,!Ops Plan RBS,!Nomination,!Site,!Resource Source,!MonthYear,'All Employees','Actual Headcount');
FEEDERS;
I get the right numbers when skipcheck is removed, but as soon as you start looking at top level numbers the server grinds to a halt (obviously i know why!). Due to that i'm certain its feeders that are causing the issue, but as usual icannot fathom what it needs to fix it. If anyone has any ideas i'd appreciate them