Saturday 20 October 2018

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:

Wednesday 17 October 2018

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