Monthly Archives: July 2014

Transfering projects

Hello there!

Today let’s talk about how to transfer your project to different servers.

There are two ways to do that:

First way) You need to create the source and destination project source in MicroStrategy Desktop/Developer.

You can do that by opening MicroStrategy Desktop/Developer, clicking on Tools -> Project Source Manager -> Add



And then, add the source server and add the destination server.

You can do that using 3-tier or 2-tier, is up to you.

Then, go to Schema -> Duplicate Project


MicroStrategy will ask you the source connection and which project do you want to transfer, and then, it will ask you the destination server.

You need to provide the Administrator user to do that.




Give the name to the destination project name:


Choose the languages that you want to transfer to the destination.


In the window below, you have to take care! Read every option before hit the next button. One option that I usually uncheck is the users and groups to copy. I never intent to transfer the users from my source to my destination, so in that case, just select NONE in Users and groups to copy.


Also, read all options in this windows to make sure you really want that. I usually don’t do nothing on this window.


And the next windows is going to ask you about the logs. Change the directory to one that you can write. Sometimes we can some errors because your windows/unix user don’t have permission to save files on that default directory.


And then, hit the finish button. Wait a little bit to complete, and you will have the project transfered to your destination.

Second way) In the case that you can’t reach the destination server.You can create a mdb file, for example, create the DSN to this mdb file, create a Metadata shell and create a 2-tier connection to this database in MicroStrategy Desktop/Developer. Please refer to the First way to know how to add a new connection.

Then, proceed exactly how I explained to you in the Fist way, but at the end, you will have your project inside that mdb file. Then, go to your destination server, create a 2-tier connection to this mdb file and duplicate the project that is inside this database to your destination server.

So, reviewing it:

1. Create an empty mdb file or an empty database in SQL Server, Oracle, etc…
Go to configuration wizard and create a new Metadata shell for the mdb file.

2. Create a DSN connection to this database;

3. Create a 2-tier connection to this database;

4. Use this 2-tier database to be the destination of your duplicated project;

5. Copy and paste this database to the server that you want to receive this project;

6. Create a DSN connection to this database;

7. Create a 2-tier connection to this database and duplicate the project to your server;

That’s it.

Hope it helps!

God bless you!

Configuring ESRI in 9.4.1

Hello there!

Today let’s talk about how to configure ESRI in Microstrategy 9.4.1.

MicroStrategy we can integrate ESRI to display information in a map using geocode data. For MicroStrategy 9.4.1, we can request a free ESRI license to MicroStrategy Support. For that, you just need to Open a case in and ask Microstrategy for that license.

There are 2 different ways to configure ESRI in 9.4.1, one for the default installation and with hotfix 1 and another one to hotfix 2 and above.

For 9.4.1 without hotfix and hotfix 1:

  1. Browse to locate ESRIconfig.xml file, that is located at:
    • For MicroStrategy Web ASP: …\MicroStrategy\Web Aspx \web-inf\xml\config\”esriconfig.xml”
    • For MicroStrategy Web JSP: …\MicroStrategy\web-inf\xml\config\”esriconfig”
  2. Enter your ESRI license key into the configuration file as shown below:
 <apps><key><![CDATA[0000000001b8a27e2e3719006999bxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx]]></key></apps>  <webmaps>        <webmap id=“5fac74d8e7924e169afddddddddddd” default=“true” />     </webmaps>  </ec>

Re-start the Web Server for the key to take effect.

For 9.4.1 with hotfix 2 and above:

  1. If the ESRI key has been requested go to step 3,
  2. If using existing key, copy it from the file located in [Web Server Location]\WEB-INF\xml\config\esriConfig.xml


  1. <apps>
  2. <key><![CDATA[000000000dddccxxxxxxxxxxxxxxxxxxxxxxxxx00]]></key>
  3. </apps>
  1. Manually create a folder structure in [Web Server Location]\plugins\ConnectorForESRIMap\WEB-INF\xml\config
  2. Download the esriConfig.xml file included below:


  1. Open this esriConfig file and add the key copied from step 1
  1. <ec>
  2. <apps>
  3. <key>[copied key]</key>
  4. </apps>
  5. </ec>
  1. Save the file and place it under [Web Server Location]\plugins\ConnectorForESRIMap\WEB-INF\xml\config.
  2. Restart the web server.


Hope it helps!

God bless you!

 This post was copied from this TN:

About the new licensing way…

Hello there!

This will going to be a quick post. It is just to inform you about the new licesing way in MicroStrategy.

I have told before that MicroStrategy has changed the way you buy licenses. Now you just have 4 kinds of licenses:

1. MicroStrategy Server

2. MicroStrategy Web

3. MicroStrategy Mobile

4. MicroStrategy Architect


Those are only for buying. You won’t have the same names while configuring your environment.

When you edit groups/users you still have Web Reporter, Web Analyst, etc...

So, those 4 licenses are only used to simplify the purchase, you still have all Web, Desktop, etc, licenses to manage.


Hope it helps!


God bless you!

List of commands in Unix to open MicroStrategy tools

Hello there!

Below you will find a list to open MicroStrategy Tools in MicroStrategy Universal (Unix):

Please notice that you need to open your “<HOME_PATH>/bin” to find these files: 

MicroStrategy Command Manager – mstrcmdmgrw
MicroStrategy Configuration Wizardmstrcfgwiz
MicroStrategy Connectivity Configuration Wizardmstrconnectwiz
MicroStrategy DB Query Toolmstrdbquerytool
MicroStrategy Diagnostics and Performance Loggingmstrdiag
MicroStrategy Health Center Configuration Wizardmstrsuppappcfgwiz
MicroStrategy Health Center Center Consolemstrsuppappgui
MicroStrategy License Managermstrlicmgr
MicroStrategy ODBC Administratormstrodbcadx
MicroStrategy Service Managermstrsvcmgr


Hope it helps.

God bless you!

The end of Google Maps for Flash!

Hello there!

Today Microstrategy has just announced that starting September 2, 2014, we aren’t going to be able to use google maps with flash visualization, just with DHTML. So, if you need to show your map In flash mode, you will have to use Esri.

See technote below that explains that:

God bless you!