c# convert pdf to image free library : Online form pdf output application control tool html web page winforms online fcns142-part220

MicroStrategy Functions Reference
MicroStrategy and Database Support for Functions   
A
© 2011 MicroStrategy, Inc.
Analytical Engine support for functions   
387
OLAP functions
•ExpWghMovingAvg
•ExpWghRunningAvg
•FirstInRange
•Lag
•LastInRange
•Lead
•MovingAvg
•MovingCount
•MovingDifference
•MovingMax
•MovingMin
•MovingStdev
•MovingStdevP
•MovingSum
•OLAPAvg
•OLAPCount
•OLAPMax
•OLAPMin
•OLAPSum
•RunningAvg
•RunningCount
•RunningMax
•RunningMin
•RunningStdev
•RunningStdevP
•RunningSum
Rank and NTile functions
•NTile
•NTileSize
•NTileValue
•NTileValueSize
•Percentile
•Rank
String functions
•Lower
•Upper
Arithmetic operators
•All Arithmetic functions are supported by the MicroStrategy 
Analytical Engine
Function type
Functions supported by the MicroStrategy Analytical 
Engine
Online form pdf output - 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
save pdf forms in reader; extract data from pdf to excel
Online form pdf output - 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
exporting data from excel to pdf form; exporting data from pdf to excel
MicroStrategy and Database Support for Functions
MicroStrategy Functions Reference
A
388
Databases that a function can be evaluated on
© 2011 MicroStrategy, Inc.
Databases that a function can be evaluated on
The tables below list the function support for each database that is certified 
for use with MicroStrategy. If a function is listed for a database, the function 
can be evaluated within that database. If a function cannot be evaluated 
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
All data mining functions are supported by the MicroStrategy 
Analytical Engine. 
Financial functions
All financial functions are supported by the MicroStrategy 
Analytical Engine. 
Mathematical functions
All mathematical functions are supported by the MicroStrategy 
Analytical Engine. 
Statistical functions
All statistical functions are supported by the MicroStrategy 
Analytical Engine. 
Function type
Functions supported by the MicroStrategy Analytical 
Engine
C# PDF File Split Library: Split, seperate PDF into multiple files
Free download library and use online C# class source codes files with other PDF files to form a new starts from 0. For example, your original PDF file contains
c# read pdf form fields; how to extract data from pdf file using java
VB.NET PDF Password Library: add, remove, edit PDF file password
' Define input and output file path. As String = Program.RootPath + "\\" 3_pw_a.pdf" ' Create a passwordSetting.IsAnnot = True ' Allow to fill form.
extract pdf form data to excel; change font size pdf form reader
MicroStrategy Functions Reference
MicroStrategy and Database Support for Functions   
A
© 2011 MicroStrategy, Inc.
Databases that a function can be evaluated on   
389
within a database, the function may be able to be supported by the 
MicroStrategy Analytical Engine (see Analytical Engine support for 
functions, page 385).
Except where explicitly stated, only database that are certified to work with 
MicroStrategy are listed below. For information on the certification and 
support for databases, refer to the MicroStrategy Readme:
• Aster nCluster, page 389
• IBM DB2, page 396
• Greenplum, page 410
• HP Neoview, page 416
• Informix, page 428
• Microsoft Access, page 437
• Microsoft SQL Server, page 443
• MySQL, page 452
• Netezza, page 455
• Oracle, page 464
• PostgreSQL, page 481
• Red Brick, page 487
• Sybase, page 491
• Teradata, page 508
• Vertica, page 516
Aster nCluster
The tables listed below describe the MicroStrategy function support for Aster 
nCluster databases:
• Aster nCluster 4.0.2, page 390
• Aster nCluster 4.5.x, page 393
VB.NET PDF File Split Library: Split, seperate PDF into multiple
This online VB tutorial aims to illustrate the process of PDF document splitting. Split PDF File by Output File Size Demo Code in VB.NET.
how to fill pdf form in reader; save data in pdf form reader
C# Create PDF from Excel Library to convert xlsx, xls to PDF in C#
Quick integrate online C# source code into .NET class. RootPath + "\\" 1.xlsx"; String outputFilePath = Program.RootPath + "\\" Output.pdf"; // Load an
extract data from pdf form to excel; pdf data extraction
MicroStrategy and Database Support for Functions
MicroStrategy Functions Reference
A
390
Databases that a function can be evaluated on
© 2011 MicroStrategy, Inc.
Aster nCluster 4.0.2
Function type
Functions that can be evaluated on the database
Basic functions
•Add
•Average
•Avg
•Count
•Geomean
•Greatest
•Least
•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
•Year
•YearEndDate
•YearStartDate
Internal functions
•Coalesce
Null and Zero functions
•IsNotNull
•IsNull
•NullToZero
•ZeroToNull
OLAP functions
•RunningAvg
•RunningCount
•RunningMax
•RunningMin
•RunningSum
Rank and NTile functions
•Rank
C# PDF Convert to Tiff SDK: Convert PDF to tiff images in C#.net
C# class source codes and online demos are String inputFilePath = Program.RootPath + "\\" 1.pdf"; PDFDocument doc inputFilePath); // Convert and output to a
filling out pdf forms with reader; how to fill out pdf forms in reader
C# Create PDF from Tiff Library to convert tif images to PDF in C#
Online demo allows converting tiff to PDF online. Program.RootPath + "\\" 1.tif"; String outputFilePath = Program.RootPath + "\\" Output.pdf"; // Load a
how to save a filled out pdf form in reader; how to fill out a pdf form with reader
MicroStrategy Functions Reference
MicroStrategy and Database Support for Functions   
A
© 2011 MicroStrategy, Inc.
Databases that a function can be evaluated on   
391
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
C# PDF Password Library: add, remove, edit PDF file password in C#
Support to add password to PDF document online or in C# passwordSetting.IsAnnot = true; // Allow to fill form. and update password for an encrypted PDF file in
export excel to pdf form; how to save filled out pdf form in reader
C# PDF File Merge Library: Merge, append PDF files in C#.net, ASP.
Free online C#.NET source code for combining Word, Excel and PowerPoint data to PDF form. inputFilePath2, inputFilePath3 }; // Combine three PDF files and output
online form pdf output; extract data from pdf file to excel
MicroStrategy and Database Support for Functions
MicroStrategy Functions Reference
A
392
Databases that a function can be evaluated on
© 2011 MicroStrategy, Inc.
Financial functions
None
Mathematical functions
•Abs
•Acos
•Acosh
•Asin
•Asinh
•Atan
•Atan2
•Atanh
•Ceiling
•Cos
•Degrees 
•Exp 
•Floor 
•Int 
•Ln 
•Log
•Log10 
•Mod 
•Power 
•Quotient 
•Radians 
•Round
•Round2
•Sin
•Sqrt
•Tan
•Trunc
Statistical 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
Create editable Word file online without email. inputFilePath = Program.RootPath + "\\" 1.pdf"; PDFDocument doc inputFilePath); // Convert and output to a
extract pdf data into excel; vb extract data from pdf
C# Create PDF from PowerPoint Library to convert pptx, ppt to PDF
Free online PowerPoint to PDF converter without email. RootPath + "\\" 1.pptx"; String outputFilePath = Program.RootPath + "\\" Output.pdf"; // Load a
extracting data from pdf to excel; extract data from pdf using java
MicroStrategy Functions Reference
MicroStrategy and Database Support for Functions   
A
© 2011 MicroStrategy, Inc.
Databases that a function can be evaluated on   
393
Aster nCluster 4.5.x
Function type
Functions that can be evaluated on the database
Basic functions
•Add
•Average
•Avg
•Count
•Geomean
•Greatest
•Least
•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
•Year
•YearEndDate
•YearStartDate
Internal functions
•Coalesce
Null and Zero functions
•IsNotNull
•IsNull
•NullToZero
•ZeroToNull
MicroStrategy and Database Support for Functions
MicroStrategy Functions Reference
A
394
Databases that a function can be evaluated on
© 2011 MicroStrategy, Inc.
OLAP functions
•Lag
•Lead
•RunningAvg
•RunningCount
•RunningMax
•RunningMin
•RunningSum
Rank and NTile functions
•Rank
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
MicroStrategy Functions Reference
MicroStrategy and Database Support for Functions   
A
© 2011 MicroStrategy, Inc.
Databases that a function can be evaluated on   
395
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 
•Floor 
•Int 
•Ln 
•Log
•Log10 
•Mod 
•Power 
•Quotient 
•Radians 
•Round
•Round2
•Sin
•Sqrt
•Tan
•Trunc
Statistical functions
None
Function type
Functions that can be evaluated on the database
MicroStrategy and Database Support for Functions
MicroStrategy Functions Reference
A
396
Databases that a function can be evaluated on
© 2011 MicroStrategy, Inc.
IBM DB2
The tables listed below describe the MicroStrategy function support for IBM 
DB2 databases:
• DB2 UDB V9.5 for Linux, UNIX, and Windows, page 396
• DB2 UDB V9.7 for Linux, UNIX, and Windows, page 401
• DB2 for i 6.1, page 405
• DB2 for i 7.1, page 408
DB2 UDB V9.5 for Linux, UNIX, and Windows 
Function type
Functions that can be evaluated on the database
Basic functions
•Add
•Average
•Avg
•Count
•Geomean
•Max
•Min
•Multiply
•Product
•StdevP
•Sum
•Var
•VarP
Documents you may be interested
Documents you may be interested