Tag Archives: web

Showing the execution date and time for the datasets and Cubes

Hello there,

Have you ever wanted to show the last execution time or the last refreshed time for a cube in a document?

To do that you just need to:

  1. Create a text;
  2. Add this auto-text: {&REPORTNAME:EXECUTIONTIME}

Where REPORTNAME will be the name of your report or Cube. For example, if you have a report with the name: Report Analysis, the auto-text will be {&[Report Analysis]:EXECUTIONTIME}

God bless you!

Configuring Google Maps for MicroStrategy

Hello there!

Today I’m going to teach you how to configure Google Maps API for MicroStrategy.

To do that you have to:

1. Go to: https://code.google.com/apis/console

2. Click on API and Authentication and click on APIs


* Sorry because mine is in Portuguese.

3. Look for: Google Maps JavaScript API v3

4. Click on Google Maps JavaScript API v3 and Enable it


5. Click on Credentials in the API and Authentication menu


6. Click on the button: Create new key


7. Use the browse key


8. If you use ASP.NET you must insert this URL:

  • http://SERVERNAME/MicroStrategy/asp/Main.aspx*

If you use J2EE:

  • http://SERVERNAME:PORTNUMBER/MicroStrategy/servlet/mstrWeb*

In my case I’ve used for ASP.NET:

And for J2EE:

Now you have an API KEY!

9. Go to C:\Program Files (x86)\MicroStrategy\GISConnectors\GoogleMap (default MSTR Installation folder)

10. If you use ASP.NET open the ConnectorForGoogleMap_ASP folder and copy the folder: ConnectorForGoogleMap to your plugin folder of your Web ASPx folder.

In my case:

C:\Program Files (x86)\MicroStrategy\Web ASPx\plugins


If  you use Tomcat, use the ConnectorForGoogleMap folder that is inside the ConnectorForGoogleMap folder. Paste this second ConnectorForGoogleMap folder inside your Webapps/MicroStrategy/plugin folder.

11. Open this pasted Google Maps plugin folder and browse to: ConnectorForGoogleMap\WEB-INF\xml\config\google

12. Edit the googleConfig.xml file

13. Change the tag:

<mk isPremier=”true”>InvalidPremierKey</mk> 


<mk isPremier=”false”>YOUR GOOGLE MAPS API KEY</mk>


<mk isPremier=”false”>AIzGSCird6Wo5TFLASD2_UoVfembPd4</mk>  (it is not a valid key)

14. Restart your IIS or J2EE Web Server.

Now you can use Google Maps for MicroStrategy.

Hope it helps!

God bless you!

Web Statistics

Hello there!

Do you know what is Web Statistics? Web Statistics is a feature to trace troubleshoot problems in your environment. You can see what is going with your slow report, for example.

You can see those logs in two ways: screen or file or screen and file.

So, to enable these statistics, you just have to:

1. Go to Web Administrator:

2. Under Diagnostics -> Statistics


3. Choose your mode


4. If you chose File or Screen and file mode, you must give a path so MicroStrategy Web can save this log for you.

In my case, I chose Screen and the result is something like this:


Now you can analyse your environment with this log.


Hope it helps!

God bless you!

Purge Microstrategy Web Cache

Hello there!

Today let’s talk about caches in Microstrategy Web.

Sometimes when you change something in Intelligence Server, Narrowcast Server or even in Web Server you don’t see the changes in Microstrategy Web.

You can force Microstrategy Web to reread the property files in the classpath.

To do that you have to use Web Administrator.

If you use IIS (Internet Information Service), you have to enter this URL:


Where WebServerNameOrIP is the IP or DNS your server. Just change to the correct one.

If you use Web Universal (J2EE):


Where AppServerName:port is the Server and Port of your Web Server.

When you open this URL, you will see something like this:


Just check those options, and MicroStrategy Web will purge all system level caches.

Hope it helps.

God bless you