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.