Feeders not working?
Posted: Fri May 22, 2015 10:22 am
Hi all,
I'm a bit depressed with my situation and I hope that someone helps me... :-/
I have two cubes - one with actuals and one for planning purposes. First of all I would like to link actuals from actuals cube to planning cube.
Dimensionality is as follows (dimension order applied):
actuals (regions, entities_actuals, products, measures_actuals, time)
plan (regions, time, products, measures_plan, entities_plan, versions)
In the planning cube I have this rule applied:
['regions':'E1R1',
'time':'01 2014',
'products':'others',
'measures_plan':'costs',
'entities_plan':'E1',
'versions':'actuals'] =
N:DB('actuals', 'E1R1', 'E1', 'others', 'costs', '01 2014');
This works and I can see the data in the target cell.
I also have feeder in the source cube:
['regions':'E1R1',
'entities_actuals':'E1',
'products':'others',
'measures_actuals':'costs',
'time':'01 2014'] =>
DB('plan', 'E1R1', '01 2014', 'others', 'costs', 'E1', 'actuals');
When I right-click the cell in the source cube and select Trace Feeders I can see that the target cell is fed.
When I right-click the cell in the target cube and select Check Feeders I can see that the target cell is not fed and consolidated levels are not populated, too.
What the hell am I missing???
Appreciate any help!
BR
Vladino
I'm a bit depressed with my situation and I hope that someone helps me... :-/
I have two cubes - one with actuals and one for planning purposes. First of all I would like to link actuals from actuals cube to planning cube.
Dimensionality is as follows (dimension order applied):
actuals (regions, entities_actuals, products, measures_actuals, time)
plan (regions, time, products, measures_plan, entities_plan, versions)
In the planning cube I have this rule applied:
['regions':'E1R1',
'time':'01 2014',
'products':'others',
'measures_plan':'costs',
'entities_plan':'E1',
'versions':'actuals'] =
N:DB('actuals', 'E1R1', 'E1', 'others', 'costs', '01 2014');
This works and I can see the data in the target cell.
I also have feeder in the source cube:
['regions':'E1R1',
'entities_actuals':'E1',
'products':'others',
'measures_actuals':'costs',
'time':'01 2014'] =>
DB('plan', 'E1R1', '01 2014', 'others', 'costs', 'E1', 'actuals');
When I right-click the cell in the source cube and select Trace Feeders I can see that the target cell is fed.
When I right-click the cell in the target cube and select Check Feeders I can see that the target cell is not fed and consolidated levels are not populated, too.
What the hell am I missing???
Appreciate any help!
BR
Vladino