Turbo Integrator - Decativate Feeder evaluation while process runs

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

Turbo Integrator - Decativate Feeder evaluation while process runs

Post by HighKeys » Thu Jul 30, 2020 7:27 am

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: 202
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Location: Russia

Re: Turbo Integrator - Decativate Feeder evaluation while process runs

Post by Elessar » Thu Jul 30, 2020 7:36 am

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

HighKeys
Posts: 97
Joined: Fri Aug 09, 2019 10:11 am
OLAP Product: TM1 / TM1 Web / Perspectives
Version: Planning Analytics V2.0.9
Excel Version: Plus 2013

Re: Turbo Integrator - Decativate Feeder evaluation while process runs

Post by HighKeys » Thu Jul 30, 2020 8:54 am

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: 3416
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 » Thu Jul 30, 2020 12:00 pm

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: 236
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 » Thu Jul 30, 2020 1:10 pm

If you simply want to remove the rule then you can use CubeRuleDestroy(CubeName) instead of loading an empty rule file

Bakkone
Posts: 112
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 » Sun Aug 02, 2020 7:33 pm

Would you go with unloading rules before trying batchupdate?

Post Reply