hi,
i have a client who have some cube with a lot of rules with 1 big dimension (2 millions elements) and some other small dimension.
the problem today is i have to wait at least 5 hours for save rules if i change something in rule editor (and for make new rule or make a correction, i have to test a lot)
any tips to reduce the waiting time of save rule in this case?
thank a lof for help.
Cross-posted in IBM community : https://community.ibm.com/community/use ... 4eda43146b
rule save time wait problem
-
- Posts: 52
- Joined: Mon Sep 26, 2022 11:10 am
- OLAP Product: Planning analytics
- Version: PA 2.0.74.23
- Excel Version: Excel 2016
rule save time wait problem
Last edited by mrdauduong on Mon Oct 10, 2022 7:48 am, edited 1 time in total.
-
- Regular Participant
- Posts: 424
- Joined: Sat Mar 10, 2012 1:03 pm
- OLAP Product: IBM TM1, Planning Analytics, P
- Version: PAW 2.0.8
- Excel Version: 2019
Re: rule save time wait problem
Hi , this has been discussed below, please go through them, it might help:
https://www.tm1forum.com/viewtopic.php?t=3829
https://www.tm1forum.com/viewtopic.php?t=3139
https://www.ibm.com/support/pages/what- ... rule-saved
https://static1.squarespace.com/static/ ... _Rules.pdf Thanks
https://www.tm1forum.com/viewtopic.php?t=3829
https://www.tm1forum.com/viewtopic.php?t=3139
https://www.ibm.com/support/pages/what- ... rule-saved
https://static1.squarespace.com/static/ ... _Rules.pdf Thanks
"You Never Fail Until You Stop Trying......"
-
- Regular Participant
- Posts: 359
- Joined: Sat Jun 08, 2019 9:55 am
- OLAP Product: Planning Analytics
- Version: Planning Analytics 2.0
- Excel Version: Excel 2016
Re: rule save time wait problem
Hi,
Someone appears to have thrown you in at the deep end, my sympathies!
Looking at all your posts, it seems to me you are trying to run before you can walk, no wait you are trying to enter the 100m Olympic final before you can walk!
Can any of the rules be turned into TI processes, if you don't know what a TI process is, this might help:
https://www.ibm.com/docs/en/planning-an ... tor-basics
Maren
Someone appears to have thrown you in at the deep end, my sympathies!
Looking at all your posts, it seems to me you are trying to run before you can walk, no wait you are trying to enter the 100m Olympic final before you can walk!
Can any of the rules be turned into TI processes, if you don't know what a TI process is, this might help:
https://www.ibm.com/docs/en/planning-an ... tor-basics
Maren
- Steve Rowe
- Site Admin
- Posts: 2423
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: rule save time wait problem
Quick and dirty for testing new rules etc could be to remove nearly all the data, except that which you need to proove out rule changes.
Depends if are you trying to solve "I need to get these rules written and tested" or "How to improve the compile time of the rules" As others have indicated the latter can be one of the most challenging jobs.
Good luck!
Depends if are you trying to solve "I need to get these rules written and tested" or "How to improve the compile time of the rules" As others have indicated the latter can be one of the most challenging jobs.
Good luck!
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- Posts: 52
- Joined: Mon Sep 26, 2022 11:10 am
- OLAP Product: Planning analytics
- Version: PA 2.0.74.23
- Excel Version: Excel 2016
Re: rule save time wait problem
thank for this, i will read all that
BariAbdul wrote: ↑Thu Oct 06, 2022 10:39 am Hi , this has been discussed below, please go through them, it might help:
https://www.tm1forum.com/viewtopic.php?t=3829
https://www.tm1forum.com/viewtopic.php?t=3139
https://www.ibm.com/support/pages/what- ... rule-saved
https://static1.squarespace.com/static/ ... _Rules.pdf Thanks
-
- Posts: 52
- Joined: Mon Sep 26, 2022 11:10 am
- OLAP Product: Planning analytics
- Version: PA 2.0.74.23
- Excel Version: Excel 2016
Re: rule save time wait problem
they dont want TI process, they have the biggest VM in the world and they dont want something fast and simple
they just want a calcul direct when they type something
they just want a calcul direct when they type something
MarenC wrote: ↑Thu Oct 06, 2022 4:08 pm Hi,
Someone appears to have thrown you in at the deep end, my sympathies!
Looking at all your posts, it seems to me you are trying to run before you can walk, no wait you are trying to enter the 100m Olympic final before you can walk!
Can any of the rules be turned into TI processes, if you don't know what a TI process is, this might help:
https://www.ibm.com/docs/en/planning-an ... tor-basics
Maren
-
- Posts: 52
- Joined: Mon Sep 26, 2022 11:10 am
- OLAP Product: Planning analytics
- Version: PA 2.0.74.23
- Excel Version: Excel 2016
Re: rule save time wait problem
i dont have trouble with writing rule, just want to know how to improve the compile time of rule and there post below is good enough !! thank !!
Steve Rowe wrote: ↑Thu Oct 06, 2022 4:46 pm Quick and dirty for testing new rules etc could be to remove nearly all the data, except that which you need to proove out rule changes.
Depends if are you trying to solve "I need to get these rules written and tested" or "How to improve the compile time of the rules" As others have indicated the latter can be one of the most challenging jobs.
Good luck!
-
- Regular Participant
- Posts: 359
- Joined: Sat Jun 08, 2019 9:55 am
- OLAP Product: Planning Analytics
- Version: Planning Analytics 2.0
- Excel Version: Excel 2016
Re: rule save time wait problem
Hi,
I mean when they make tea in the morning they have to click a button right?
Maren
One important piece of advice, sometimes difficult conversations with the clients are necessary!they just want a calcul direct when they type something
I mean when they make tea in the morning they have to click a button right?
Maren
-
- Posts: 52
- Joined: Mon Sep 26, 2022 11:10 am
- OLAP Product: Planning analytics
- Version: PA 2.0.74.23
- Excel Version: Excel 2016
Re: rule save time wait problem
thank Maren, i try again and again to convient them to use TI for complexe rule and i can do a TI that can work well with only 5 secondes waiting time. but they dont want to...they want to something complexe to make his life simplifier...