Cubes not feeding on server start-up

Post Reply
MattDavis
Posts: 7
Joined: Wed Dec 02, 2009 11:50 am
OLAP Product: TM1
Version: 9.0 9.4 and 9.5
Excel Version: 2003 and 2007

Cubes not feeding on server start-up

Post by MattDavis »

Hi all

is there a way to force TM1 to generate feeders in a certain cube order, when restarting the server?

we are using 9.4.0 and helpfully the order that feeders are computed are displayed in the message log. I'd never normally consider the cube order a problem as in previous versions of TM1(9.1 and 8.4.3) it hasn't been an issue (certainly in our models anyway) - however after startup we have output cubes with some unfed data in.

To correct it I have to manually generate the feeders by the old "space bar - rule save" method, and then all data comes through correctly.

as an example: three particular cube are an issue. I need TM1 to generate feeders in this order..

Raw Data cube => Mapping cube => Output cube

but I can see from the server message log that TM1 generates feeders in this order..

1. Mapping cube
2. Output cube
3. Raw Data cube

as I said above this in turn is leading to unfed data in the Output cube

please help!

Matt
It always used to be about the brackets, now it's about the semicolon
User avatar
jim wood
Site Admin
Posts: 3958
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Cubes not feeding on server start-up

Post by jim wood »

If I remeber rightly there is a setting in the CFG file where you force this to happen. I'm certain this is the case for 9.4. You might want to check the admin guide. (Or whatever they are calling it these days.)
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
lotsaram
MVP
Posts: 3702
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Cubes not feeding on server start-up

Post by lotsaram »

Your issue is not a common one but not unheard of. Cubes always seem to load in a predefined order, you could play around with the cube names to get them to load in the desired order, but in an established system this is probably not an option due to the rework required.

As event triggered chores/processes do not yet exist a possible solution would be to:
Have a chore scheduled at a very regular interval (say 5 minutes) that
- checks the value of a consolidated cell in the "output" cube that you know is not fed on server load
- if the value is non-zero then exit process
- if the value is zero then
- reprocess feeders for raw data
- reprocess feeders for mapping cube
- reprocess feeders for output cube
Post Reply