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
Feeders not working?
- mattgoff
- MVP
- Posts: 516
- Joined: Fri May 16, 2008 1:37 pm
- OLAP Product: TM1
- Version: 10.2.2.6
- Excel Version: O365
- Location: Florida, USA
Re: Feeders not working?
Nothing jumps out at me. Is this a copy/paste or a retype?
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.
-
- MVP
- Posts: 3235
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Feeders not working?
To test further, do you have n-level cells on both left-hand side and right-hand side of the feeder ?
Did you unload the cube to fire feeders again (or bounce the server, which is more drastic) ?
Did you unload the cube to fire feeders again (or bounce the server, which is more drastic) ?
Best regards,
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
- Steve Rowe
- Site Admin
- Posts: 2460
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: Feeders not working?
Can you confirm the left hand side of your feeder statement is an N level and that the hard coded rules are the exact rules you have in the rule sheet as opposed to your interpretation of what is going on?
It is very unlikely that this a bug and probable that some form of user error is involved.
Suggest you post screen shots of your trace and check feeders too.
Cheers,
It is very unlikely that this a bug and probable that some form of user error is involved.
Suggest you post screen shots of your trace and check feeders too.
Cheers,
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- Posts: 16
- Joined: Tue Feb 12, 2013 7:31 am
- OLAP Product: TM1+Cognos Express
- Version: 9.5.2+10.1+10.2
- Excel Version: 2007+2010
- Location: Prague
Re: Feeders not working?
Just for sure, try switching off persistent feeders and recycle your test.
Regards
Petr
Regards
Petr