TM1 Forum

I have a rule/feeder that basically says use the scenario "Blended Forecast" to take "Actual" scenario for actual financial data and "Forecast" for forecast financial data.
It is working fine in multiple cubes.

Here is the code in the rule:
**************************************************************************************************
SkipCheck;

# Blended Forecast Rule; feeder on line 32
[ ' Blended Forecast ' ] = N:
DB ( ' Project Finance ' , DB ( ' Time Control ' , !Year , !Month , ' Scenario ' ) , !Market , !Business , !Department , !Project , !Job , !Year , !Month , !Account , !Comment ) ;
DB ( ' Finance ' , DB ( ' Time Control ' , !Year , !Month , ' Scenario ' ) , !Market , !Business , !Department , !Year , !Month , !Account ) ;

FEEDERS;

# Blended Forecast Feeders; rule on line 5
[ ' Actual ' ] => [ ' Blended Forecast ' ] ;
[ ' Forecast ' ] => [ ' Blended Forecast ' ] ;

************************************************************************************************

While this working fine in multiple cubes, I reloaded some data in one of the cubes and suddenly, the two scenarios ("Blended Forecast" and "Actuals") didn't tie out at a consolidated high level (for actuals months).
So, I went to the leaf level and tied the two scenarios out - they tied.
At this point, I know that this is a consolidation issue - potentially related to persistent feeders.
So, I delete the .feeders file for the cube and restart the service.
The two scenarios now tie out - problem solved.

Why when I reload data in other cubes has this not been an issue?
I would think that when I reload data it would say that the cells now with data are non-zero and shouldn't be skipped.
Is there something I can put into the TI code to correct this?

Thanks in advance for any advice or insight anyone might be able to share.

Feeder statement go in the cube where the data that is being fed from resides. I see two cubes referenced in your rule, Project Finance and Finance. The feeder statements for these cubes should be in the rules file for those cubes.

Thanks Tomok.

Clarification - the cube in which I am editing the rule is called "Project Finance".
I made a mistake in pasting the rule- in troubleshooting the cube, I copied over a piece of similar code into my spreadsheet from the "Finance" cube (to compare the similar rules - then forgot to delete when pasting here). Below is the true rule (just that line omitted.)

So the rule is saying take the data from within the same cube "Project Finance" and pull ! for all the dimensions, except for Scenario.
For Scenario, the DB call part of the code, it is going to a "Time Control" cube where it states in the "Blended Forecast" scenario, which months are "Actual" or "Forecast".

The feeder in the bottom section is working within "Project Finance" and saying feed "Actual" and "Forecast" to "Blended Forecast".

The problem lied in the fact that a lot of the cells would feed all the way up the rollups/hierarchies. But randomly some would not - so when I looked at "Blended Forecast" vs "Actual" they did not tie out. When I went down to lowest leaf level, the two scenarios tied.

This made me think this the issue was related to persistent feeders.
So, I deleted the "Project finance.feeders" file and restarted the server.
Afterwards, the two scenarios tied out at a consolidated level - so the problem is solved (at least for now).

I am curious why exactly this fixed the problem.
When I load new data into the cube, why doesn't it look to see if there is new non-zero cells?
Or am I missing something about the way persistent feeders or consolidations work within TM1?
All other cubes in which use a similar rule for "Blended Forecast" don't seem to have this problem.

Thanks,
Sam


**************************************************************************************************
SkipCheck;

# Blended Forecast Rule; feeder on line 32
[ ' Blended Forecast ' ] = N:
DB ( ' Project Finance ' , DB ( ' Time Control ' , !Year , !Month , ' Scenario ' ) , !Market , !Business , !Department , !Project , !Job , !Year , !Month , !Account , !Comment ) ;

FEEDERS;

# Blended Forecast Feeders; rule on line 5
[ ' Actual ' ] => [ ' Blended Forecast ' ] ;
[ ' Forecast ' ] => [ ' Blended Forecast ' ] ;

************************************************************************************************