MicroStrategy Functions Reference
© 2011 MicroStrategy, Inc.
Another way to use this function would be to create an attribute form that
combined the first letter of someone’s first name with the person’s full last
name. The InitCap function could be used to ensure that the first letter of
the first name was capitalized. An attribute form of this type would require
the use of the functions InitCap, ConcatBlank, Concat, and LeftStr.
The definition of such an attribute form is shown below:
1), "."), [CUST_LAST_NAME])
An attribute form using a definition such as the one listed above would
display names such as J. Doe, M. Smith, and L. Martinez. The InitCap
function ensures that the first letter of the first name is capitalized.
LeftStr (left string selection)
The LeftStr function returns a substring taken as a specified number of
characters from the left of the input string. For example, if the specified
length is five, LeftStr would return the string “Micro” from the original
string “MicroStrategy”. LeftStr is useful for abbreviations or length
reduction when the entire input string is not required.
LeftStr (Argument, Length)
• Argument is a metric, fact, column, or string value representing the text
• Length is an integer indicating the number of characters, starting from
the far left position of the string, to be returned.
For information on the syntax used in your specific database, refer to
Appendix A, MicroStrategy and Database Support for Functions,
and search in the section that corresponds to your database.
The LeftStr function can be used to create attribute forms that use
abbreviations. This can help reduce the length for attribute forms that may
have long descriptions.