RFE 116669 - TM1 Data Snapshot functionality - Copy rule to values in a TM1 cube
Posted: Fri Mar 23, 2018 2:36 am
Hi Everyone, (Sorry about not posting in the correct area previously.)
https://www.ibm.com/developerworks/rfe/ ... _ID=116669 and https://www.ibm.com/developerworks/rfe/ ... _ID=118320 are an RFEs for a TM1 commend to internalise the copy of rule values to values. The specific details are include in the RFE, and IBM have said it should be easy to do.
Today this RFE is the number 1 Planning Analytics RFE which is not slated for a future release, however, IBM have indicated they intend to reject the RFE as the capability already exists. I am hoping as many votes as possible will help IBM reconsider rejecting this RFE .
We typically use copy rules values to values at milestones through our planning process to keep a history snapshot of the plan to compare against updates. WE use bedrock to export the rule vales to file and then reimport. We use Hustle and RunTI to improve process times by over 50% to 1/2 an hour, but this is not acceptable performance. Here is a recent list of threads related to this issue:
http://www.tm1forum.com/viewtopic.php?f ... 656#p68656 Improve TI Processing Time
http://www.tm1forum.com/viewtopic.php?f=3&t=13901 Parallel run vs. ICX
http://www.tm1forum.com/viewtopic.php?f=3&t=13196 Copy version performance
http://www.tm1forum.com/viewtopic.php?f=3&t=13861 TM1RunTI and number of cores/threads
A TM1 in memory solution will be significantly quicker than our current approach of writing to disk and reimporting or the alternative, writing to a replica cube and back to original cube, and require less ongoing maintenance.
https://www.ibm.com/developerworks/rfe/ ... _ID=116669 and https://www.ibm.com/developerworks/rfe/ ... _ID=118320 are an RFEs for a TM1 commend to internalise the copy of rule values to values. The specific details are include in the RFE, and IBM have said it should be easy to do.
Today this RFE is the number 1 Planning Analytics RFE which is not slated for a future release, however, IBM have indicated they intend to reject the RFE as the capability already exists. I am hoping as many votes as possible will help IBM reconsider rejecting this RFE .
We typically use copy rules values to values at milestones through our planning process to keep a history snapshot of the plan to compare against updates. WE use bedrock to export the rule vales to file and then reimport. We use Hustle and RunTI to improve process times by over 50% to 1/2 an hour, but this is not acceptable performance. Here is a recent list of threads related to this issue:
http://www.tm1forum.com/viewtopic.php?f ... 656#p68656 Improve TI Processing Time
http://www.tm1forum.com/viewtopic.php?f=3&t=13901 Parallel run vs. ICX
http://www.tm1forum.com/viewtopic.php?f=3&t=13196 Copy version performance
http://www.tm1forum.com/viewtopic.php?f=3&t=13861 TM1RunTI and number of cores/threads
A TM1 in memory solution will be significantly quicker than our current approach of writing to disk and reimporting or the alternative, writing to a replica cube and back to original cube, and require less ongoing maintenance.