MicroStrategy Functions Reference
MicroStrategy and Database Support for Functions   
A
© 2011 MicroStrategy, Inc.
Databases that a function can be evaluated on   
517
Internal functions
•Coalesce
Null and Zero functions
•IsNotNull
•IsNull
•NullToZero
•ZeroToNull
OLAP functions
•FirstInRange
•Lag
•LastInRange
•Lead
•OLAPRank
Rank and NTile functions
None
String functions
•Concat
•ConcatBlank
•InitCap
•LeftStr
•Length
•Lower
•LTrim
•Position
•RightStr
•RTrim
•SubStr
•Trim
•Upper
Arithmetic operators
•-
•x
•+
•/
•U-
Comparison operators
•<
•<=
•<>
•=
•>
•>=
•Begins With
•Between
•Contains
•Ends With
•In
•Like
•Not Begins With
•Not Between
•Not Contains
•Not Ends With
•Not In
•Not Like
Function type
Functions that can be evaluated on the database
Pdf form data extraction - extract form data from PDF in C#.net, ASP.NET, MVC, Ajax, WPF
Help to Read and Extract Field Data from PDF with a Convenient C# Solution
java read pdf form fields; export excel to pdf form
Pdf form data extraction - VB.NET PDF Form Data Read library: extract form data from PDF in vb.net, ASP.NET, MVC, Ajax, WPF
Convenient VB.NET Solution to Read and Extract Field Data from PDF
how to save filled out pdf form in reader; edit pdf form in reader
MicroStrategy and Database Support for Functions
MicroStrategy Functions Reference
A
518
Databases that a function can be evaluated on
© 2011 MicroStrategy, Inc.
Comparison operators for rank
•*<=
•*<>
•*=
•*>=
•*Between
•Not*Between
Logical operators
•AND
•IF
•Not
•Or
Data mining functions
None
Financial functions
None
Mathematical functions
•Abs
•Acos
•Acosh 
•Asin 
•Asinh 
•Atan 
•Atan2 
•Atanh 
•Ceiling 
•Cos 
•Degrees 
•Exp 
•Ln 
•Log 
•Log10 
•Mod
•Power 
•Quotient 
•Radians 
•Randbetween
•Round
•Round2
•Sin
•Sqrt
•Tan
•Trunc
Statistical functions
•Standardize
Function type
Functions that can be evaluated on the database
VB.NET PDF Text Extract Library: extract text content from PDF
control provides text extraction from PDF images and image files. Enable extracting PDF text to another PDF file, and other formats such as TXT and SVG form.
fill in pdf form reader; pdf data extraction tool
C# PDF Text Extract Library: extract text content from PDF file in
Image text extraction control provides text extraction from PDF images and image files. Best C#.NET PDF text extraction library and component for free download.
extract data from pdf file to excel; pdf data extraction
MicroStrategy Functions Reference
MicroStrategy and Database Support for Functions   
A
© 2011 MicroStrategy, Inc.
Databases that a function can be evaluated on   
519
Vertica 3.5 
Function type
Functions that can be evaluated on the database
Basic functions
•Add
•Average
•Avg
•Count
•Geomean
•Max
•Min
•Multiply
•Product
•Stdev
•StdevP
•Sum
•Var
•VarP
Date and time functions
•AddDays
•AddMonths
•CurrentDate
•CurrentDateTime
•CurrentTime
•Date
•DayOfMonth
•DayOfWeek
•DayOfYear
•DaysBetween
•Hour
•MilliSecond
•Minute
•Month
•MonthEndDate
•MonthsBetween
•MonthStartDate
•Quarter
•Second
•Year
•YearEndDate
•YearStartDate
Internal functions
•Coalesce
Null and Zero functions
•IsNotNull
•IsNull
•NullToZero
•ZeroToNull
OLAP functions
•FirstInRange
•Lag
•LastInRange
•Lead
•OLAPRank
VB.NET PDF Image Extract Library: Select, copy, paste PDF images
image extraction from multiple page adobe PDF file in VB.NET. Extract multiple types of image from PDF file in VB.NET, like XObject Image, XObject Form, Inline
cannot save pdf form in reader; export pdf form data to excel
C# PDF Image Extract Library: Select, copy, paste PDF images in C#
Support PDF Image Extraction from a Page, a Region on a Page Extract various types of image from PDF file, like XObject Image, XObject Form, Inline Image
extract pdf data to excel; exporting data from pdf to excel
MicroStrategy and Database Support for Functions
MicroStrategy Functions Reference
A
520
Databases that a function can be evaluated on
© 2011 MicroStrategy, Inc.
Rank and NTile functions
None
String functions
•Concat
•ConcatBlank
•InitCap
•LeftStr
•Length
•Lower
•LTrim
•Position
•RightStr
•RTrim
•SubStr
•Trim
•Upper
Arithmetic operators
•-
•x
•+
•/
•U-
Comparison operators
•<
•<=
•<>
•=
•>
•>=
•Begins With
•Between
•Contains
•Ends With
•In
•Like
•Not Begins With
•Not Between
•Not Contains
•Not Ends With
•Not In
•Not Like
Comparison operators for rank
•*<=
•*<>
•*=
•*>=
•*Between
•Not*Between
Logical operators
•AND
•IF
•Not
•Or
Function type
Functions that can be evaluated on the database
VB.NET PDF Page Extract Library: copy, paste, cut PDF pages in vb.
VB.NET PDF - PDF File Pages Extraction Guide. Detailed VB.NET Guide for Extracting Pages from Microsoft PDF Doc. Free PDF document
extract data from pdf to excel; pdf data extractor
VB.NET PDF Library SDK to view, edit, convert, process PDF file
PDF Text Extraction. Mature and robust APIs are provided for programmers to integrate and perform PDF text extraction feature in .NET windows and web project.
extract data from pdf into excel; pdf form save with reader
MicroStrategy Functions Reference
MicroStrategy and Database Support for Functions   
A
© 2011 MicroStrategy, Inc.
Databases that a function can be evaluated on   
521
Data mining functions
None
Financial functions
None
Mathematical functions
•Abs
•Acos
•Acosh 
•Asin 
•Asinh 
•Atan 
•Atan2 
•Atanh 
•Ceiling 
•Cos 
•Degrees 
•Exp 
•Ln 
•Log 
•Log10 
•Mod
•Power 
•Quotient 
•Radians 
•Randbetween
•Round
•Round2
•Sin
•Sqrt
•Tan
•Trunc
Statistical functions
•Standardize
Function type
Functions that can be evaluated on the database
C# PDF File Permission Library: add, remove, update PDF file
Data. Data: Auto Fill-in Field Data. Field: Insert Choose to offer PDF annotation and content extraction Enable or disable copying and form filling functions.
saving pdf forms in acrobat reader; using pdf forms to collect data
VB.NET PDF File Permission Library: add, remove, update PDF file
Data. Data: Auto Fill-in Field Data. Field: Insert Choose to offer PDF annotation and content extraction Enable or disable copying and form filling functions.
extract pdf data into excel; extract table data from pdf
MicroStrategy and Database Support for Functions
MicroStrategy Functions Reference
A
522
Databases that a function can be evaluated on
© 2011 MicroStrategy, Inc.
Vertica 4.0 
Function type
Functions that can be evaluated on the database
Basic functions
•Add
•Average
•Avg
•Count
•Geomean
•Max
•Min
•Multiply
•Product
•Stdev
•StdevP
•Sum
•Var
•VarP
Date and time functions
•AddDays
•AddMonths
•CurrentDate
•CurrentDateTime
•CurrentTime
•Date
•DayOfMonth
•DayOfWeek
•DayOfYear
•DaysBetween
•Hour
•MilliSecond
•Minute
•Month
•MonthEndDate
•MonthsBetween
•MonthStartDate
•Quarter
•Second
•Year
•YearEndDate
•YearStartDate
Internal functions
•Coalesce
Null and Zero functions
•IsNotNull
•IsNull
•NullToZero
•ZeroToNull
OLAP functions
•FirstInRange
•Lag
•LastInRange
•Lead
•OLAPRank
C# PDF File Merge Library: Merge, append PDF files in C#.net, ASP.
Merge Microsoft Office Word, Excel and PowerPoint data to PDF form. PDF page deleting, PDF document splitting, PDF page reordering and PDF page image and
pdf data extraction tool; extract table data from pdf to excel
VB.NET PDF Password Library: add, remove, edit PDF file password
passwordSetting.IsAnnot = True ' Allow to fill form. passwordSetting.IsFillForm = True ' Content extraction is allowed. True ' Add password to PDF file.
pdf form save with reader; extract data from pdf
MicroStrategy Functions Reference
MicroStrategy and Database Support for Functions   
A
© 2011 MicroStrategy, Inc.
Databases that a function can be evaluated on   
523
Rank and NTile functions
None
String functions
•Concat
•ConcatBlank
•InitCap
•LeftStr
•Length
•Lower
•LTrim
•Position
•RightStr
•RTrim
•SubStr
•Trim
•Upper
Arithmetic operators
•-
•x
•+
•/
•U-
Comparison operators
•<
•<=
•<>
•=
•>
•>=
•Begins With
•Between
•Contains
•Ends With
•In
•Like
•Not Begins With
•Not Between
•Not Contains
•Not Ends With
•Not In
•Not Like
Comparison operators for rank
•*<=
•*<>
•*=
•*>=
•*Between
•Not*Between
Logical operators
•AND
•IF
•Not
•Or
Function type
Functions that can be evaluated on the database
MicroStrategy and Database Support for Functions
MicroStrategy Functions Reference
A
524
Databases that a function can be evaluated on
© 2011 MicroStrategy, Inc.
Data mining functions
None
Financial functions
None
Mathematical functions
•Abs
•Acos
•Acosh 
•Asin 
•Asinh 
•Atan 
•Atan2 
•Atanh 
•Ceiling 
•Cos 
•Degrees 
•Exp 
•Ln 
•Log 
•Log10 
•Mod
•Power 
•Quotient 
•Radians 
•Randbetween
•Round
•Round2
•Sin
•Sqrt
•Tan
•Trunc
Statistical functions
•Standardize
Function type
Functions that can be evaluated on the database
© 2011 MicroStrategy, Inc.
Glossary: Analytical Engine   
525
G
LOSSARY
Analytical Engine A component of the MicroStrategy Intelligence Server that 
performs all advanced analytical functions. The Analytical 
Engine evaluates functions not supported by the data 
warehouse RDBMS and it cross-tabulates reports.
application object MicroStrategy object used to provide analysis of and insight 
into relevant data. Application objects are developed in 
MicroStrategy Desktop and they are the building blocks for 
reports and documents. Application objects include (among 
others) these object types: report, document, template, filter, 
metric, custom group, consolidation, prompt.
attribute A data level defined by the system architect and associated 
with one or more columns in a data warehouse lookup table. 
Attributes include data classifications like Region, Order, 
Customer, Age, Item, City, and Year. They provide a means 
for aggregating and filtering at a given level. 
See also: 
• attribute element
• attribute form
attribute element A value of any of the attribute forms of an attribute. For 
example, New York and Dallas are elements of the attribute 
City; January, February, and March are elements of the 
attribute Month.
Glossary
MicroStrategy Functions Reference
526
Glossary: attribute form
© 2011 MicroStrategy, Inc.
attribute form One of several columns associated with an attribute that are 
different aspects of the same thing. ID, Name, Last Name, 
Long Description, and Abbreviation could be forms of the 
attribute Customer. Every attribute supports its own 
collection of forms.
banding A method of organizing values according to a set of 
descriptive or meaningful data ranges called buckets. For 
example, customers in the age ranges of 10–20, 21–30, and 
31–40, where each set of ages is a band. Banding is also used 
for display purposes, where every other row is a different 
color and the two colors alternate. Compare consolidation.
break by  An attribute or hierarchy where calculations for an OLAP 
function restart. To break by an attribute or hierarchy means 
to restart calculations that use OLAP, or Relative, functions 
when the analytical engine reaches the next instance of the 
specified attribute or hierarchy. Examples of OLAP functions 
include RunningStdevP, Rank, NTile, and various 
expressions that calculate percent values. To break by an 
attribute or hierarchy in an expression, you must set the 
BreakBy parameter.
compound metric A type of metric defined by a formula based on arithmetic 
operators and non-group functions. Arithmetic operators are 
+, -, *, and /; non-group functions are OLAP and scalar 
functions such as running sum or rank. The operators and 
functions can be applied to facts, attributes, or metrics. 
Examples are RunningAvg(Cost_Metric) and 
Sum(Cost_Metric) + Sum(Profit_Metric).
configuration objects A MicroStrategy object appearing in the system layer and 
usable across multiple projects. Configuration objects include 
(among others) these object types: users, database instances, 
database logins, schedules.
custom group An object that can be placed on a template and is made up of 
an ordered collection of elements called custom group 
elements. Each element contains its own set of filtering 
qualifications. 
Documents you may be interested
Documents you may be interested