Compare Rules/TI processes for Production and Development

Post Reply
wypwong
Posts: 22
Joined: Tue Aug 13, 2013 2:35 pm
OLAP Product: TM1
Version: TM1 10.1
Excel Version: 2007

Compare Rules/TI processes for Production and Development

Post by wypwong »

Hi all

Is there a quicker way to compare rules and TI processes in 2 different instances (production and development), than comparing them line by line manually?

Many developers had worked on the projects, and sometimes they were not updated in both versions.

And I think it's time to do a clean up, so it will be easier for me to maintain going forward.

P
tomok
MVP
Posts: 2831
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Compare Rules/TI processes for Production and Developmen

Post by tomok »

wypwong wrote:Hi all

Is there a quicker way to compare rules and TI processes in 2 different instances (production and development), than comparing them line by line manually?

Many developers had worked on the projects, and sometimes they were not updated in both versions.

And I think it's time to do a clean up, so it will be easier for me to maintain going forward.

P
There are a number of text editors that can do this comparison for you. Just have it compare the .pro and .rux files.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
dan.kelleher
Community Contributor
Posts: 127
Joined: Wed Oct 14, 2009 7:46 am
OLAP Product: TM1
Version: 9.4
Excel Version: 11
Location: London

Re: Compare Rules/TI processes for Production and Developmen

Post by dan.kelleher »

This sounds like a source-code control issue.

I'd suggest adopting a version control system such as the open-source Apache Subversion:

https://subversion.apache.org/

I use a freeware client available here:

http://tortoisesvn.net/

This also allows you to compare differences between versions of your code.
Andrew_M
Posts: 6
Joined: Thu Jun 07, 2012 12:47 pm
OLAP Product: Tm1
Version: 10.1
Excel Version: 2k10

Re: Compare Rules/TI processes for Production and Developmen

Post by Andrew_M »

If you need really quicker way and this is one-time task (I mean to compare these 2+2 files on 2 instances) then my suggestion is to use software tools for data comparison and merging of files like WinMerge. Regarding WinMerge you can open and compare source files (.rux and .pro) or just copy text right from TI \rules editor.
blackhawk
Community Contributor
Posts: 136
Joined: Thu May 29, 2008 2:29 pm

Re: Compare Rules/TI processes for Production and Developmen

Post by blackhawk »

wypwong,

If you want a tool you can use TM1Compare which will allow you to visually compare and migrate TM1 rules, processes (as well as dimensions and attributes) across multiple servers. See the Commercial section of this board (viewtopic.php?f=20&t=10354&p=48629&hilit=compare#p48629) for details.

Disclaimer: I work for CarpeDatum, the maker of TM1Compare.
User avatar
Harvey
Community Contributor
Posts: 236
Joined: Mon Aug 04, 2008 4:43 am
OLAP Product: PA, TM1, CX, Palo
Version: TM1 8.3 onwards
Excel Version: 2003 onwards
Contact:

Re: Compare Rules/TI processes for Production and Developmen

Post by Harvey »

Flow Genesis will do this for you, but the future of that product is in doubt. I'm considering continuing it in a free version if there's any interest.

You can also use freeware tools like WinMerge, SVN, etc, to do a similar thing, as I did before I developed tools to do it for me. I posted a blog covering the basics ages ago.

Another good option is the TM1CMP command line tool from ykud. Check out his blog post about it here.
Take your TM1 experience to the next level - TM1Innovators.net
wypwong
Posts: 22
Joined: Tue Aug 13, 2013 2:35 pm
OLAP Product: TM1
Version: TM1 10.1
Excel Version: 2007

Re: Compare Rules/TI processes for Production and Developmen

Post by wypwong »

Thank you all for the very useful information. It will save me a lot of times. :)
Post Reply