compare MDX statements across multiple instances

[JamiseBondi]

Hi,

I'm in the process of doing an audit of all dynamic subsets across all dimensions in an instance and also comparing this across multiple instances (6 different instances). Currently I'm using a very manual approach which is to open up each subset with the MDX showing, copy it into an excel spreadsheet - this is done for each instance - and then use =EXACT in excel to determine if any of them vary from a baseline MDX. As you can imagine this is extremely tedious and time consuming. Does anyone have any pointers as to how this process could be accelerated or done more efficiently using other processes/tools/methods?

Thanks guys.

[jim wood]

I'm not sure if this is an option for you but the client I'm currently working with has used Perl scripts to do this kind of job. I don't have a script to hand but if you have anybody within your IT group that can program Perl, it might be worth looking in to,

Jim.

[JamiseBondi]

Thanks Jim,

I'll pose the question and see if I have any takers.

cheers.

[Edward Stuart]

If you get no takers then you could save some time with agent ransack.

I searched for the string "tm1filter" from .sub files and retrieved a list of 200+ files

Then exported to text/ csv file, which gave me the full MDX statement which could then be inserted into Excel for comparison.

http://www.mythicsoft.com/agentransack

Dependant upon your MDX expressions you could find a way to make your searches more efficient.

You could also try taking advantage of WinMerge off the files generated from search above

[JamiseBondi]

Edward this little nugget of info has saved me a heap of work - thanks very much for sharing. That app is awesome. I've got the FileLocator Pro and it's super powerful. Searched through all my files in about 5 seconds, found all the MDX's I need. I used Tm1Subset as my filter within the file. Now just a bit of excel work to format them and then compare and voila!
thanks for the link!