TM1 Forum

We have a .rux file for a particular cube that users directly update in our Test and Prod environments. What I need is to be able to compare the contents of the Test and Prod .rux files and get a meaningful comparison output report. I have access to several industry standard file comparison utilities. But because one rule can span several lines in our .rux files and both the Test and Prod files contain more than 40,000 lines, my existing utilities don't pinpoint in an exact enough way the .rux file differences I need to see. Something else I'm looking for is a better way to identify instances where a rule that takes up 5 lines in a .rux file and begins on line 10000 in Test gets located in the production file beginning on line 15000 and is reported so that it's easy to see there's a difference in the location of the rule.

I could write my own comparison program that is designed to compare our .rux files but I was wondering if anyone else has already done this...

Thanks

djsflor wrote:We have a .rux file for a particular cube that users directly update in our Test and Prod environments. What I need is to be able to compare the contents of the Test and Prod .rux files and get a meaningful comparison output report. I have access to several industry standard file comparison utilities. But because one rule can span several lines in our .rux files and both the Test and Prod files contain more than 40,000 lines, my existing utilities don't pinpoint in an exact enough way the .rux file differences I need to see. Something else I'm looking for is a better way to identify instances where a rule that takes up 5 lines in a .rux file and begins on line 10000 in Test gets located in the production file beginning on line 15000 and is reported so that it's easy to see there's a difference in the location of the rule.

I could write my own comparison program that is designed to compare our .rux files but I was wondering if anyone else has already done this...

Thanks

Try Winmerge. Open source, easy to use, and very powerful for doing that kind of comparison.