Maps in Dossier

A map is a spatial detail which is composed of one or many layers. A layer is the way in which ESRI Maps for MicroStrategy visually represents geographic datasets.  A layer is similar to a legend item on a paper map. For example, on a road map, roads, national parks, political boundaries, and rivers might be considered different layers. When you add MicroStrategy business data to a map, Esri Maps for MicroStrategy creates a layer and displays it on the Contents pane. Once the layer is created, you can configure how it is styled, set its transparency, enable clustering or heat maps, turn on pop-up windows, and so on. 
 
You can add a Map visualization to your dossier, to display your data as map markers on an interactive map. You can use the visualization to:

• Filter the map markers shown in the visualization by selecting map markers for which to display data.
• Display map markers as static images in the visualization, or display the map markers as dynamic bubbles. If you choose to display the map markers as dynamic bubbles, the size of each dynamic bubble is automatically determined based on the value of the metric used to display the map markers, with the largest bubbles being displayed for the largest metric values.

In the image below, you can view different layers used to compare different attributes and metrics on the map.


In the image below, you can view clusters on various data points on the map.


Requirements:

• Attributes: 1 or more
• Metrics: 1 or more
• Geo Attribute: Latitude & Longitude
• Angle: 1 or more metric
• Color By:  1 or more metric

 
Minimum MicroStrategy version: 10.9
Publisher: MicroStrategy 

Installation Instructions:

• To view this dossier with the visualization, download the .mstr file below and deploy it in MicroStrategy Desktop or MicroStrategy Web.
• You can open a working demo by uploading the .mstr file below and doing the following:
• To open the demo visualization in MicroStrategy Desktop, double click the .mstr file.
• To open the demo visualization in MicroStrategy Web, choose Create -> Upload MicroStrategy File -> View Dossier.

Reference: MSTR Community

Dynamic Custom Group in Dashboard/Dossier

You can dynamically cluster attribute elements by using a table with range classification. This table can be imported from Excel file or can be a table in relational database

Let's assume you have a table that clusters your Employees by the Cost brackets. Based on those brackets a Rating is defined (like A, B, C...). This table can be imported from Excel file or from a table in relational database.
Please notice there is a Flag column that contains value '1' for each row. If you don't have this column in your data don't worry! Just use Upper column instead in the formula (see formula of 'Rating Metric' below).


Currently, your Dashboard/Dossier displays Cost per Employee, but it is missing Rating information.


As a first step import your Rating table. Import Rating as an attribute.


Create a metric 'Rating Metric' with the following formula:
Max(IF(((Cost>Lower)And(Cost<Upper)),Flag,0)){~+}


Create a grid that contains Employee, Rating (attribute) and Cost. The data comes from two unrelated data sets so you will get a cross join of data.


Add "Rating Metric" to Filter Pane and set a filter 'Greater than or Equal to" 1. You will see a proper Rating assignment and you don't even need to display 'Rating Metric" on the grid.


This assignment is dynamic, meaning that if you change the Rating brackets in your data set the new Rating rules will be applied automatically (assuming, you are using a live connection to a database).
You may need to change Level of your metrics if there are more attributes in your initial data set.

Dynamic Custom Group in Dashboard/Dossier

You can dynamically cluster attribute elements by using a table with range classification. This table can be imported from Excel file or can be a table in relational database

Let's assume you have a table that clusters your Employees by the Cost brackets. Based on those brackets a Rating is defined (like A, B, C...). This table can be imported from Excel file or from a table in relational database.
Please notice there is a Flag column that contains value '1' for each row. If you don't have this column in your data don't worry! Just use Upper column instead in the formula (see formula of 'Rating Metric' below).


Currently, your Dashboard/Dossier displays Cost per Employee, but it is missing Rating information.


As a first step import your Rating table. Import Rating as an attribute.


Create a metric 'Rating Metric' with the following formula:
Max(IF(((Cost>Lower)And(Cost<Upper)),Flag,0)){~+}


Create a grid that contains Employee, Rating (attribute) and Cost. The data comes from two unrelated data sets so you will get a cross join of data.


Add "Rating Metric" to Filter Pane and set a filter 'Greater than or Equal to" 1. You will see a proper Rating assignment and you don't even need to display 'Rating Metric" on the grid.


This assignment is dynamic, meaning that if you change the Rating brackets in your data set the new Rating rules will be applied automatically (assuming, you are using a live connection to a database).
You may need to change Level of your metrics if there are more attributes in your initial data set.

Change the Tooltip displayed on a Graph

Tooltips are only visible in Web. However, both MicroStrategy Developer and Web allow you to modify the tooltips displayed in a graph by using macros. These macros are dynamic text that is replaced with graph information when the tooltip is displayed in Graph View.

While the default macro used is {&TOOLTIP}, you can use different macros to customize what information appears in a given graph. You can use multiple macros in the same tooltip or combine static text and macros.

Some tooltip macros may not be available for use in specific types of graphs. For example, {&XVALUE} can only be used in Bubble charts or Scatter plots. If a macro is unavailable for the given graph type, no tooltip is displayed in the graph when viewed in Web.

The following table describes the macros you can use to customize graph tooltips in both MicroStrategy Developer and MicroStrategy Web:

Character sort order in MSTR

The sort order of characters in MicroStrategy is different from ASCII standards. The MicroStrategy sort order of characters affects:

•

The order of files and folders in MicroStrategy Developer and MicroStrategy Web

•

The order of ascending and descending sorts of alphanumeric values in MicroStrategy reports

The sort order described below is for English locales only. The sort order may be different in different locales.

The table below lists the non-printable characters which are first in the sort order. All these characters are equal to each other, so the final sorting order is determined by which character is retrieved from the data warehouse first.

ASCII characters that are non-printable characters are listed in the tables below with their character representation. For example, a backspace is represented as BS.

NULL	SOH	STX	ETX	EOT	ENQ	ACK
BEL	BS	SO	SI	DLE	DCL	DC2
DC3	DC4	NAK	SYN	ETB	CANC	EM
SUB	ESC	FS	GS	RS	US	DEL

The table below lists the sort order of characters in MicroStrategy. The order goes from left to right and top to bottom. For example, the top left table cell (TAB) is the beginning of the sort order, the cell to the right of that (LF) is next in order, and the bottom right cell (Z) is the end of the sort order.

TAB	LF	VT	FF	CR		‘	^	_	-
,	;	:	!	?	.	‘	“	(	)
[	]	{	}	@	*	/	\	&	#
%	+	<	=	>	|	~	$	0	1
2	3	4	5	6	7	8	9	a	A
b	B	c	C	d	D	e	E	f	F
g	G	h	H	i	I	j	J	k	K
l	L	m	M	n	N	o	O	p	P
q	Q	r	R	s	S	t	T	u	U
v	V	w	W	x	x	y	Y	z	Z