How to create a Map View / Geospatial service in Microstrategy Web Dossier

Today we will learn on how to use Map View / Geospatial service in Microstrategy Web

In order to use Map view / Geospatial service, we need to first define the geography (longitude/latitude) in our dataset. If you have columns with city/country name, you can still define the geography. Microstrategy will automatically convert city/country to latitude/longitude format.

Steps:

• Right click and edit your dataset that has either longitude/latitude or city/country names
• Right click the column that has City/Country 
• Define the geography accordingly (city if the column contain city names, country if it has country names )
• It will automatically convert the city/country into latitude/longitude format
• Click save
• Now use Geospatial Service
• Add the geography column under the Geo attribute 

• Specify a color by attribute
• Under formatting, Select Map options
• Map style = Street

• You are done.
• Check the visualization

Microstrategy web dossier - display dynamic images based on a page filter

Today we will learn on how to display dynamic images in Microstrategy web dossier based on a drop down list (filter)

Steps to perform:

• You need to store images at a central location (it can be any)
• You need to install and configure a web server at the same location where you are storing your images. so, every image has an HTTP path
• you will need to store that path and the image name in a table
• Fields: 
• Image 
• ImageHTML: this will be a HTTP path in the form of html pointing to your image
• e.g: <img src = "full path to the server and image.jpg" height=450px width=800px>

• Go to your web dossier and import the above dataset (table)
• while importing the dataset, right click the field "ImageHTML"
• Change the data type to "HTML"

• Click save dataset
• Now, create a filter and drag the "image name" object to the filter.
• Add a new visualization (Grid type).
• Drag the ImageName and ImageHtml fields to the Visualization rows.
• Right click the filter > Select target > select visualization name you created > Apply
• Right click ImageName > format > No fill
• Right click ImageHtml > format > No Fill
• Righ click a row in ImageName > format > No fill 
• Shrink/drag the ImageName header to the extreme left (0 inches), so, it is no longer visible and does not take any visualization grid space. In this way, your image will be visible in the whole grid.
• Make column headers white color and vertical/horizontal lines to None.
• You are done.
• Click image names in the filter and you will see images changing dynamically.

Microstrategy Web Dossier - Data Internationalization

Today we will learn on how to change the language of Microstrategy Web Dossier visuals based on user's default language

For Labels and data, You have two options: 

• You can create separate tables for each lanaguage (table level)
• You can create separate column with postfix in the same table for each language (e.g.: Column1_EN for english, Column1_NL for dutch)

For this experiment, will be using Column pattern for changing the data language

First, you need to add the new language for the Dutch user (in Microstrategy Developer):

• Set the default language to Dutch
• Set the number and date format to Dutch (used to change the locale)
• Set the I-Server language to Dutch  (used when exporting reports)
• Enable “Data Internationalization” (to be enabled at project level in Microstrategy developer)
• Go to Project Settings > Language > Data
• Enable “SQL based”
• Add dutch language
• Let the English language be default
• In the column pattern, add “_DTCH” in from of Dutch language
• Leave column pattern for English as blank
• Refresh/Update the project