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!
Turbo Integrator - Decativate Feeder evaluation while process runs
- Elessar
- Community Contributor
- Posts: 345
- 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
Hi,
It's a proven practice to turn off the rule while process runs:
Prolog: RuleLoadFromFile (cCube, cDummyEmptyRuleFile);
Epilog: RuleLoadFromFile (cCube, '');
It's a proven practice to turn off the rule while process runs:
Prolog: RuleLoadFromFile (cCube, cDummyEmptyRuleFile);
Epilog: RuleLoadFromFile (cCube, '');
-
- 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
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:
Thanks for your help!
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:
So but if the Cubename.Rux file exist already then i would load this?RuleLoadFromFile('Sales', ' ');
This example creates a rule for the Sales cube using the file named Sales.rux in the server's data directory.
Thanks for your help!
-
- MVP
- Posts: 3661
- 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
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.
-
- Community Contributor
- Posts: 248
- 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
If you simply want to remove the rule then you can use CubeRuleDestroy(CubeName) instead of loading an empty rule file
-
- 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
Would you go with unloading rules before trying batchupdate?