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
Rux File Comparison Code
-
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Rux File Comparison Code
Try Winmerge. Open source, easy to use, and very powerful for doing that kind of comparison.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
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.