MicroStrategy Object Exchanger is a custom written tool that allows automatic and fast replacement of all occurrences of an attribute or a metric in all available reports. The formatting of the replaced object will be preserved!
Compared to the conventional manual way (open each report, replace the object, format the object again, save the report) Object Exchanger helps you to save many hours of hard and error-prone work.
MicroStrategy Object Exchange
The tool is based on MicroStrategy Intelligence Server API. You will need .NET Framework Redistributable (from Version 2.0) to start the tool. You can download it for free from Microsoft.
I used this tool at one of the German retail customers to replace one of the attributes (Item) with another one (Item Group) — but in over 100 reports! The whole process took only about 2 minutes.
Feel free to use MicroStrategy Object Exchanger in your projects. You can download it here. Just unpack the ZIP-file. The interface is very intuitive. Please let me know about your experience using this tool.
Note: You must have MicroStrategy installed on the machine where you want to execute this tool.
The Object Exchanger currently only supports the metadata from 8.x versions. To be on the safe side don’t forget to backup your metadata! I look forward for your comment, views on this tool.
You can read more about MicroStrategy Object Exchanger at my blog in German language.
Application(s) is provided “as is” and MicroStrategy101 and individual application author(s) disclaim all warranties, whether express or implied, with respect to all provided items, including all warranties of merchantability, fitness for a particular purpose, accuracy, systems integration, title, satisfactory quality and non-infringement. MicroStrategy101 and individual application author(s) do not warrant that use of the provided items or any portion thereof will be uninterrupted or error-free, or that the provided items or any portion thereof will meet any need or requirement of licensee.
GREAT. Just the tool I need!!!!!!. Thousands of thanks
Please share you experience about this application. This application crashed upon execution at my and another friend’s PC. could not test it.
It crashed for me too upon execution. Also when i tried to install suggested .NET Framework the installation had to be aborted because of some conflict with another allready installed .NET Framework version.
Please let us know OS build, version and SP installed. Is your OS/CPU 64bit? .net framework version? One need to have at least v2 of .net framework installed.
Hi, here’s some system information:
OS – MS Win XP Pro version 5.1.2600 SP3 build 2600
CPU – x86 Family 6 Model 13 Stepping 8 GenuineIntel ~1994 Mhz
It seems that i have several versions of .NET framework installed:
.NET Framework 1.1
.NET Framework 1.1 hotfix(KB928366)
.NET Framework 1.1 Swedish Language Pack
.NET Framework 2.0 SP2
.NET Framework 3.0 SP2
.NET Framework 3.5 SP1
Hope this information will help us forward
Hi,
did you try the program on a PC where MicroStrategy is installed?
If yes, which MicroStrategy components?
Here is the list of the DDLs that become active after I start Object Exchanger on my PC (created with ProcessExplorer from sysinternals.com). Please check whether you miss some of them:
MicroStrategy Object Exchanger.exe 4512 0.71 MicroStrategy Object Exchanger Slavik Taubkin, xyz@abc.com
Process: MicroStrategy Object Exchanger.exe Pid: 4512
Name Description Company Name Version
advapi32.dll Advanced Windows 32 Base API Microsoft Corporation 5.01.2600.5512
clbcatq.dll Microsoft Corporation 2001.12.4414.0700
comctl32.dll User Experience Controls Library Microsoft Corporation 6.00.2900.5512
comctl32.dll Common Controls Library Microsoft Corporation 5.82.2900.5512
comdlg32.dll Common Dialogs DLL Microsoft Corporation 6.00.2900.5512
comres.dll Microsoft Corporation 2001.12.4414.0700
crypt32.dll Crypto API32 Microsoft Corporation 5.131.2600.5512
ctype.nls
gdi32.dll GDI Client DLL Microsoft Corporation 5.01.2600.5698
GdiPlus.dll Microsoft GDI+ Microsoft Corporation 5.01.3102.5512
imm32.dll Windows XP IMM32 API Client DLL Microsoft Corporation 5.01.2600.5512
Interop.DSSCOMMasterLib.dll 1.00.0000.0000
kernel32.dll Windows NT BASE API Client DLL Microsoft Corporation 5.01.2600.5512
kernel32.dll.mui Client-DLL für Windows NT-Basis-API Microsoft Corporation 5.01.2600.0000
l_intl.nls
libcurl.DLL
locale.nls
lpk.dll Language Pack Microsoft Corporation 5.01.2600.5512
M5CLICON.DLL MicroStrategy Incorporated 9.00.0209.0090
M5COMShr.DLL MicroStrategy Incorporated 9.00.0209.0090
M7COMUTL.DLL MicroStrategy Incorporated 9.00.0209.0090
M8Base4.DLL MicroStrategy Incorporated 9.00.0209.0090
M8DatTy4.DLL MicroStrategy Incorporated 9.00.0209.0090
M8Db3.DLL MicroStrategy Incorporated 9.00.0209.0090
M8DbCm3_32.dll MicroStrategy Incorporated 9.00.0209.0090
M8DbCon3.DLL MicroStrategy Incorporated 9.00.0209.0090
M8DbMap2.DLL MicroStrategy Incorporated 9.00.0209.0090
M8Encry3.DLL MicroStrategy Incorporated 9.00.0209.0090
M8Forma3.DLL MicroStrategy Incorporated 9.00.0209.0090
M8icudt22l.dll
M8icuin22.dll IBM ICU I18N DLL IBM Corporation and others 2.02.0000.0000
M8icuuc22.dll IBM ICU Common DLL IBM Corporation and others 2.02.0000.0000
M8LiXML2.DLL MicroStrategy Incorporated 9.00.0209.0090
M8Log2.DLL MicroStrategy Incorporated 9.00.0209.0090
M8LogRt.DLL MicroStrategy Incorporated 9.00.0209.0090
M8PDSrl2.DLL MicroStrategy Incorporated 9.00.0209.0090
M8PrcCo2.DLL MicroStrategy Incorporated 9.00.0209.0090
M8PrfMon.DLL MicroStrategy Incorporated 9.00.0209.0090
M8Res2.DLL MicroStrategy Incorporated 9.00.0209.0090
M8Rgstr4.DLL MicroStrategy Incorporated 9.00.0209.0090
M8Sso.DLL MicroStrategy Incorporated 9.00.0209.0090
M8SvrCH.dll MicroStrategy Incorporated 9.00.0209.0090
M8SvrDA.dll MicroStrategy Incorporated 9.00.0209.0090
M8SvrDE.dll MicroStrategy Incorporated 9.00.0209.0090
M8SvrEN.dll MicroStrategy Incorporated 9.00.0209.0090
M8SvrES.dll MicroStrategy Incorporated 9.00.0209.0090
M8SvrFR.dll MicroStrategy Incorporated 9.00.0209.0090
M8SvrIT.dll MicroStrategy Incorporated 9.00.0209.0090
M8SvrJA.dll MicroStrategy Incorporated 9.00.0209.0090
M8SvrKO.dll MicroStrategy Incorporated 9.00.0209.0090
M8SvrNL.dll MicroStrategy Incorporated 9.00.0209.0090
M8SvrPT.dll MicroStrategy Incorporated 9.00.0209.0090
M8SvrSV.dll MicroStrategy Incorporated 9.00.0209.0090
M8SvrTCH.dll MicroStrategy Incorporated 9.00.0209.0090
M8Synch4.DLL MicroStrategy Incorporated 9.00.0209.0090
Microsoft.VisualBasic.ni.dll Visual Basic Runtime Library Microsoft Corporation 8.00.50727.0042
micross.ttf
MicroStrategy Object Exchanger.exe MicroStrategy Object Exchanger Slavik Taubkin, xyz@abc.com 1.02.0000.0000
msasn1.dll ASN.1 Runtime APIs Microsoft Corporation 5.01.2600.5512
mscoree.dll Microsoft .NET Runtime Execution Engine Microsoft Corporation 2.00.50727.0832
mscorjit.dll Microsoft .NET Runtime Just-In-Time Compiler Microsoft Corporation 2.00.50727.0832
mscorlib.ni.dll Microsoft Common Language Runtime Class Library Microsoft Corporation 2.00.50727.0832
mscorrc.dll Microsoft .NET Runtime resources Microsoft Corporation 2.00.50727.0042
mscorwks.dll Microsoft .NET Runtime Common Language Runtime – WorkStation Microsoft Corporation 2.00.50727.0832
msctf.dll MSCTF Server DLL Microsoft Corporation 5.01.2600.5512
msctf.dll.mui MSCTF-Server-DLL Microsoft Corporation 5.01.2600.0000
msctfime.ime Microsoft Text Frame Work Service IME Microsoft Corporation 5.01.2600.5512
msvcp80.dll Microsoft® C++ Runtime Library Microsoft Corporation 8.00.50727.0762
msvcr80.dll Microsoft® C Runtime Library Microsoft Corporation 8.00.50727.0762
msvcrt.dll Windows NT CRT DLL Microsoft Corporation 7.00.2600.5512
ntdll.dll NT Layer DLL Microsoft Corporation 5.01.2600.5512
odbc32.dll Microsoft Data Access – ODBC Driver Manager Microsoft Corporation 3.525.1132.0000
odbcbcp.dll Microsoft BCP for ODBC Microsoft Corporation 2000.85.1132.0000
odbcint.dll Microsoft Data Access – ODBC Resources Microsoft Corporation 3.525.1132.0000
ole32.dll Microsoft OLE for Windows Microsoft Corporation 5.01.2600.5512
oleaut32.dll Microsoft Corporation 5.01.2600.5512
pdh.dll Windows Performance Data Helper DLL Microsoft Corporation 5.01.2600.5512
psapi.dll Process Status Helper Microsoft Corporation 5.01.2600.5512
rpcrt4.dll Remote Procedure Call Runtime Microsoft Corporation 5.01.2600.5512
secur32.dll Security Support Provider Interface Microsoft Corporation 5.01.2600.5512
shell32.dll Windows Shell Common Dll Microsoft Corporation 6.00.2900.5512
shlwapi.dll Shell Light-weight Utility Library Microsoft Corporation 6.00.2900.5512
sortkey.nlp
sortkey.nls
sorttbls.nlp
sorttbls.nls
SynTPFcs.dll SynTPFcs Synaptics, Inc. 7.05.0017.0027
System.Drawing.ni.dll .NET Framework Microsoft Corporation 2.00.50727.0832
System.ni.dll .NET Framework Microsoft Corporation 2.00.50727.0832
System.Runtime.Remoting.dll Microsoft .NET Runtime Object Remoting Microsoft Corporation 2.00.50727.0832
System.Windows.Forms.ni.dll .NET Framework Microsoft Corporation 2.00.50727.0832
unicode.nls
user32.dll Windows XP USER API Client DLL Microsoft Corporation 5.01.2600.5512
user32.dll.mui Client-DLL für Windows XP USER-API Microsoft Corporation 5.01.2600.0000
usp10.dll Uniscribe Unicode script processor Microsoft Corporation 1.420.2600.5512
uxtheme.dll Microsoft UxTheme Library Microsoft Corporation 6.00.2900.5512
version.dll Version Checking and File Installation Libraries Microsoft Corporation 5.01.2600.5512
winmm.dll MCI API DLL Microsoft Corporation 5.01.2600.5512
wldap32.dll Win32 LDAP API DLL Microsoft Corporation 5.01.2600.5512
ws2_32.dll Windows Socket 2.0 32-Bit DLL Microsoft Corporation 5.01.2600.5512
ws2help.dll Windows Socket 2.0 Helper for Windows NT Microsoft Corporation 5.01.2600.5512
wsock32.dll Windows Socket 32-Bit DLL Microsoft Corporation 5.01.2600.5512
xpsp2res.dll Service Pack 2 Messages Microsoft Corporation 5.01.2600.5512
xpsp2res.dll Service Pack 2-Meldungen Microsoft Corporation 5.01.2600.5512
*** Files that I have that you don’t ***********************************
diasymreader.dll Dia based SymReader Microsoft Corporation 8.0.50727.3053
fpSpru70.ocx FarPoint Unicode Spread Controls (OLEDB) FarPoint Technologies, Inc. 7.0.0.32
MFC42u.DLL MFCDLL Shared Library – Retail Version Microsoft Corporation 6.2.8071.0
OLEPRO32.DLL Microsoft Corporation 5.1.2600.5512
System.Xml.ni.dll .NET Framework Microsoft Corporation 2.0.50727.3053
WINSPOOL.DRV Windows Spooler Driver Microsoft Corporation 5.1.2600.5512
*** Files that you have that I don’t **********************************
lpk.dll Language Pack Microsoft Corporation 5.01.2600.5512
M7COMUTL.DLL MicroStrategy Incorporated 9.00.0209.0090
psapi.dll Process Status Helper Microsoft Corporation 5.01.2600.5512
usp10.dll Uniscribe Unicode script processor Microsoft Corporation 1.420.2600.5512
******************************************************************
Also i discovered that many of my files have different version number than yours even though they have the same name.
Well, probably we have different version numbers of DLLs just because we use different MicroStrategy versions. I use 9.0.
I think, the tool crashes at the start because of some missing DLLs. The easiest way to find out, what DLLs are missing, is to use “Microsoft CLR Debugger” from .NET SDK. It will show you an error like “Retrieving the COM class factory for component with CLSID {05042236-8382-11D1-8E1D-006008960167} failed”. Then you can look for the DLL with this CLSID in the Internet — or just ask me
Just an FYI, this feature was added to 9, but its undocumented and kind of buried. If you go to Project Configuration -> Project Definition -> Advanced, you’ll see a check box for “Enable Find and Replace object dependencies”. Then, you can go to Tools -> Find and Replace, and you’ll have a new option for Object Dependencies. You can choose the original object, what you want to replace it with, search for dependents, and check which ones you want to change it on.
Looks like MicroStrategy is stealing every product idea from here.
So what component is missing?
Retrieving the COM class factory for component with CLSID {05042236-8382-11D1-8E1D-006008960167} failed
I’m getting the same error with version 9.0.1
This CLSID belongs to the DLL file “M5CLICON.DLL”. It’s normally installed under “C:\Program Files\Common Files\MicroStrategy\”
But! As Bryan writes, MicroStrategy has now this feature directly in the Desktop. So why don’t just use it?
Application is working absoultely fine with the help of some changes that had to made