MicroStrategy Functions Reference
MicroStrategy and Database Support for Functions   
A
© 2011 MicroStrategy, Inc.
Databases that a function can be evaluated on   
437
Microsoft Access
The tables listed below describe the MicroStrategy function support for 
Microsoft Access databases. Microsoft Access database are:
• Microsoft Access 2000, 2002, or 2003, page 438
• Microsoft Access 2007, page 440
Mathematical functions
•Abs
•Acos
•Asin
•Atan
•Atan2
•Ceiling
•Cos
•Exp
•Floor
•Int
•Int2
•Ln
•Log10
•Mod
•Power
•Round
•Round2
•Sin
•Sqrt
•Tan
•Trunc
Statistical functions
None
Function type
Functions that can be evaluated on the database
Pdf form save in reader - 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
pdf data extractor; save pdf forms in reader
Pdf form save in reader - 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
pdf form data extraction; extract pdf data to excel
MicroStrategy and Database Support for Functions
MicroStrategy Functions Reference
A
438
Databases that a function can be evaluated on
© 2011 MicroStrategy, Inc.
Microsoft Access 2000, 2002, or 2003
Microsoft Access 2000, 2002, or 2003 are only supported for demonstration 
purposes.
Function type
Functions that can be evaluated on the database
Basic functions
•Add
•Average
•Avg
•Count
•Max
•Min
•Multiply
•Sum
Date and time functions
•AddDays
•AddMonths
•CurrentDate
•CurrentDateTime
•CurrentTime
•Date
•DayOfMonth
•DayOfWeek
•DayOfYear
•DaysBetween
•Hour
•Minute
•Month
•MonthEndDate
•MonthsBetween
•MonthStartDate
•Quarter
•Second
•Week
•Year
•YearEndDate
•YearStartDate
Internal functions
•Banding
•BandingC
•Coalesce
Null and Zero functions
•IsNotNull
•IsNull
•NullToZero
•ZeroToNull
OLAP functions
None
Rank and NTile functions
None
C# PDF: PDF Document Viewer & Reader SDK for Windows Forms
SaveFile(String filePath): Save PDF document file to a specified path form (Here, we take a blank form as an open a file dialog and load your PDF document in
pdf data extraction open source; save data in pdf form reader
VB.NET Image: How to Save Image & Print Image Using VB.NET
printing multi-page document files, like PDF and Word is used to illustrate how to save a sample RE__Test Public Partial Class Form1 Inherits Form Public Sub New
extract data from pdf forms; exporting pdf form to excel
MicroStrategy Functions Reference
MicroStrategy and Database Support for Functions   
A
© 2011 MicroStrategy, Inc.
Databases that a function can be evaluated on   
439
String functions
•Concat
•ConcatBlank
•InitCap
•LeftStr
•Length
•Lower
•Position
•RightStr
•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
Data mining functions
None
Financial functions
None
Function type
Functions that can be evaluated on the database
C# PDF File Merge Library: Merge, append PDF files in C#.net, ASP.
Merge Microsoft Office Word, Excel and PowerPoint data to PDF form. Append one PDF file to the end of another and save to a single PDF file.
extract data from pdf file; make pdf form editable in reader
VB.NET PDF Page Delete Library: remove PDF pages in vb.net, ASP.
this RasterEdge XDoc.PDF SDK, you can simply delete a single page from a PDF document using VB.NET or remove any page from a PDF document and save to local
export pdf form data to excel; flatten pdf form in reader
MicroStrategy and Database Support for Functions
MicroStrategy Functions Reference
A
440
Databases that a function can be evaluated on
© 2011 MicroStrategy, Inc.
Microsoft Access 2007
Microsoft Access 2007 is only supported for demonstration purposes.
Mathematical functions
•Floor
•Int
•Int2
•Ln
•Mod
•Quotient 
Statistical functions
None
Function type
Functions that can be evaluated on the database
Basic functions
•Add
•Average
•Avg
•Count
•Geomean
•Max
•Min
•Multiply
•Stdev
•StdevP
•Sum
•Var
•VarP
Function type
Functions that can be evaluated on the database
C# PDF Page Extract Library: copy, paste, cut PDF pages in C#.net
to extract single or multiple pages from adobe PDF file and save into a The portable document format, known as PDF document, is a widely-used form of file
pdf form save with reader; extract data from pdf file to excel
C# Image: Save or Print Document and Image in Web Viewer
or image, you can easily save the changes to DLL Library, including documents TIFF, PDF, Excel, Word string fileName = Request.Form["saveFileName"]; string fid
exporting data from pdf to excel; how to make pdf editable form reader
MicroStrategy Functions Reference
MicroStrategy and Database Support for Functions   
A
© 2011 MicroStrategy, Inc.
Databases that a function can be evaluated on   
441
Date and time functions
•AddDays
•AddMonths
•CurrentDate
•CurrentDateTime
•CurrentTime
•Date
•DayOfMonth
•DayOfWeek
•DayOfYear
•DaysBetween
•Hour
•Minute
•Month
•MonthEndDate
•MonthsBetween
•MonthStartDate
•Quarter
•Second
•Year
•YearEndDate
•YearStartDate
Internal functions
•Banding
•BandingC
•Coalesce
Null and Zero functions
•IsNotNull
•IsNull
•NullToZero
•ZeroToNull
OLAP functions
None
Rank and NTile functions
None
String functions
•Concat
•ConcatBlank
•InitCap
•LeftStr
•Length
•Lower
•LTrim
•Position
•RightStr
•RTrim
•SubStr
•Trim
•Upper
Function type
Functions that can be evaluated on the database
C# PDF Convert to Tiff SDK: Convert PDF to tiff images in C#.net
Description: Convert to DOCX/TIFF with specified zoom value and save it into stream. Parameters: zoomValue, The magnification of the original PDF page size.
how to fill pdf form in reader; how to save a filled out pdf form in reader
C# Create PDF from Tiff Library to convert tif images to PDF in C#
Description: Convert to PDF and save it on the disk. Parameters: Name, Description, Valid Value. Description: Convert to PDF and save it into stream. Parameters:
c# read pdf form fields; filling out pdf forms with reader
MicroStrategy and Database Support for Functions
MicroStrategy Functions Reference
A
442
Databases that a function can be evaluated on
© 2011 MicroStrategy, Inc.
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
Data mining functions
None
Financial functions
None
Function type
Functions that can be evaluated on the database
C# PDF Convert to Word SDK: Convert PDF to Word library in C#.net
key. Quick to remove watermark and save PDF text, image, table, hyperlink and bookmark to Word without losing format. Powerful components
saving pdf forms in acrobat reader; how to make a pdf form fillable in reader
C# Create PDF from PowerPoint Library to convert pptx, ppt to PDF
Description: Convert to PDF/TIFF and save it on the disk. Parameters: Description: Convert to PDF/TIFF and save it into stream. Parameters:
extract table data from pdf to excel; how to fill out pdf forms in reader
MicroStrategy Functions Reference
MicroStrategy and Database Support for Functions   
A
© 2011 MicroStrategy, Inc.
Databases that a function can be evaluated on   
443
Microsoft SQL Server
The tables listed below describe the MicroStrategy function support for 
Microsoft SQL Server databases:
• Microsoft SQL Server 2000, page 444
• Microsoft SQL Server 2005, page 446
• Microsoft SQL Server 2008, page 449
Mathematical functions
•Abs
•Cos 
•Exp
•Floor
•Int
•Int2
•Ln
•Log
•Log10
•Mod
•Power 
•Quotient
•Round
•Round2
•Sin
•Sqrt
•Tan
Statistical functions
None
Function type
Functions that can be evaluated on the database
MicroStrategy and Database Support for Functions
MicroStrategy Functions Reference
A
444
Databases that a function can be evaluated on
© 2011 MicroStrategy, Inc.
Microsoft SQL Server 2000
Function type
Functions that can be evaluated on the database
Basic functions
•Add
•Average
•Avg
•Count
•Max
•Min
•Multiply
•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
•Week
•Year
•YearEndDate
•YearStartDate
Internal functions
•Banding
•BandingC
•Coalesce
Null and Zero functions
•IsNotNull
•IsNull
•NullToZero
•ZeroToNull
OLAP functions
None
Rank and NTile functions
None
MicroStrategy Functions Reference
MicroStrategy and Database Support for Functions   
A
© 2011 MicroStrategy, Inc.
Databases that a function can be evaluated on   
445
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
Data mining functions
None
Function type
Functions that can be evaluated on the database
MicroStrategy and Database Support for Functions
MicroStrategy Functions Reference
A
446
Databases that a function can be evaluated on
© 2011 MicroStrategy, Inc.
Microsoft SQL Server 2005
Financial functions
None
Mathematical functions
•Abs
•Acos
•Asin
•Atan
•Atan2
•Ceiling
•Cos
•Degrees
•Exp
•Floor
•Int
•Int2
•Ln
•Log10
•Mod
•Power
•Quotient
•Radians
•Round
•Round2
•Sin
•Sqrt
•Tan
Statistical functions
•None
Function type
Functions that can be evaluated on the database
Basic functions
•Add
•Average
•Avg
•Count
•Geomean
•Max
•Min
•Multiply
•Stdev
•StdevP
•Sum
•Var
•VarP
Function type
Functions that can be evaluated on the database
Documents you may be interested
Documents you may be interested