Turbo Integrator - Decativate Feeder evaluation while process runs

Post Reply
HighKeys
Posts: 117
Joined: Fri Aug 09, 2019 10:11 am
OLAP Product: TM1 / TM1 Web / Perspectives
Version: Planning Analytics V2.0.9
Excel Version: Office 365

Turbo Integrator - Decativate Feeder evaluation while process runs

Post by HighKeys »

Hello Community,

i try to transfer many data in a process, one of the cubes feeds many others, so the transfer runs endless cause the feeder evaluation starts after adding one value into it (thats was i think), The process runs fine before i changed my feeder model (reduces heavy overfeeding -8 GB RAM´from feeders cleared)

Now the process runs over 18h in BulkLoadMode, is there an way to deactivate the Feeder Evaluation so i can process the feeders after the datattransfer in the Epilog?

I can post the code but its a really general transfer process.

Thanks for your help!
User avatar
Elessar
Community Contributor
Posts: 331
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Contact:

Re: Turbo Integrator - Decativate Feeder evaluation while process runs

Post by Elessar »

Hi,

It's a proven practice to turn off the rule while process runs:
Prolog: RuleLoadFromFile (cCube, cDummyEmptyRuleFile);
Epilog: RuleLoadFromFile (cCube, '');
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
HighKeys
Posts: 117
Joined: Fri Aug 09, 2019 10:11 am
OLAP Product: TM1 / TM1 Web / Perspectives
Version: Planning Analytics V2.0.9
Excel Version: Office 365

Re: Turbo Integrator - Decativate Feeder evaluation while process runs

Post by HighKeys »

Hi Elessar!

Thanks for your fast answer!, So i have to create a empty Rule file in the datadirectory, then i load this empty file, start the transfer, after complete the transfer i add " RuleLoadFromFile (cCube, '');" to load the original Rule?


The IBM Docs says:
RuleLoadFromFile('Sales', ' ');
This example creates a rule for the Sales cube using the file named Sales.rux in the server's data directory.
So but if the Cubename.Rux file exist already then i would load this?


Thanks for your help!
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Turbo Integrator - Decativate Feeder evaluation while process runs

Post by lotsaram »

I suggest you have a look at the bedrock library bedrock.cube.rule.manage
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
Edward Stuart
Community Contributor
Posts: 247
Joined: Tue Nov 01, 2011 10:31 am
OLAP Product: TM1
Version: All
Excel Version: All
Location: Manchester
Contact:

Re: Turbo Integrator - Decativate Feeder evaluation while process runs

Post by Edward Stuart »

If you simply want to remove the rule then you can use CubeRuleDestroy(CubeName) instead of loading an empty rule file
Bakkone
Posts: 119
Joined: Mon Oct 27, 2014 10:50 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Re: Turbo Integrator - Decativate Feeder evaluation while process runs

Post by Bakkone »

Would you go with unloading rules before trying batchupdate?
Post Reply