MicroStrategy Object Exchanger

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

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.

About Slavik Taubkin

Slavik is an IT consultant currently working for Teradata in Germany. He come originally from the Ukraine’s second largest city Kharkov and live now with his family in a small city near Frankfurt.

13 thoughts on “MicroStrategy Object Exchanger

  1. 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.

    1. 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

      1. 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

  2. *** 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.

  3. 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 :)

  4. 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.

  5. 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

  6. 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?

Comments are closed.