pdf free library c# : Extract data from pdf to excel SDK control API .net web page asp.net sharepoint fcns10-part183

MicroStrategy Functions 
Reference
Version: 9.2.1
Document Number: 09410921
Extract data from pdf to excel - 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
edit pdf form in reader; how to type into a pdf form in reader
Extract data from pdf to excel - 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
extracting data from pdf into excel; cannot save pdf form in reader
Twenty-third Edition, June 2011, version 9.2.1
To ensure that you are using the documentation that corresponds to the software you are licensed to use, compare this version number with the software 
version shown in “About MicroStrategy...” in the Help menu of your software.
Document number: 09410921
Copyright © 2011 by MicroStrategy Incorporated. All rights reserved.
If you have not executed a written or electronic agreement with MicroStrategy or any authorized MicroStrategy distributor, the following terms apply:
This software and documentation are the proprietary and confidential information of MicroStrategy Incorporated and may not be provided to any other 
person. Copyright © 2001-2011 by MicroStrategy Incorporated. All rights reserved.
THIS SOFTWARE AND DOCUMENTATION ARE PROVIDED “AS IS” AND WITHOUT EXPRESS OR LIMITED WARRANTY OF ANY KIND BY EITHER 
MICROSTRATEGY INCORPORATED OR ANYONE WHO HAS BEEN INVOLVED IN THE CREATION, PRODUCTION, OR DISTRIBUTION OF THE 
SOFTWARE OR DOCUMENTATION, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR 
A PARTICULAR PURPOSE, GOOD TITLE AND NONINFRINGMENT, QUALITY OR ACCURACY. THE ENTIRE RISK AS TO THE QUALITY AND 
PERFORMANCE OF THE SOFTWARE AND DOCUMENTATION IS WITH YOU. SHOULD THE SOFTWARE OR DOCUMENTATION PROVE 
DEFECTIVE, YOU (AND NOT MICROSTRATEGY, INC. OR ANYONE ELSE WHO HAS BEEN INVOLVED WITH THE CREATION, PRODUCTION, OR 
DISTRIBUTION OF THE SOFTWARE OR DOCUMENTATION) ASSUME THE ENTIRE COST OF ALL NECESSARY SERVICING, REPAIR, OR 
CORRECTION. SOME STATES DO NOT ALLOW THE EXCLUSION OF IMPLIED WARRANTIES, SO THE ABOVE EXCLUSION MAY NOT APPLY TO 
YOU.
In no event will MicroStrategy, Inc. or any other person involved with the creation, production, or distribution of the Software be liable to you on account 
of any claim for damage, including any lost profits, lost savings, or other special, incidental, consequential, or exemplary damages, including but not limited 
to any damages assessed against or paid by you to any third party, arising from the use, inability to use, quality, or performance of such Software and 
Documentation, even if MicroStrategy, Inc. or any such other person or entity has been advised of the possibility of such damages, or for the claim by any 
other party. In addition, MicroStrategy, Inc. or any other person involved in the creation, production, or distribution of the Software shall not be liable for 
any claim by you or any other party for damages arising from the use, inability to use, quality, or performance of such Software and Documentation, based 
upon principles of contract warranty, negligence, strict liability for the negligence of indemnity or contribution, the failure of any remedy to achieve its 
essential purpose, or otherwise. The entire liability of MicroStrategy, Inc. and your exclusive remedy shall not exceed, at the option of MicroStrategy, Inc., 
either a full refund of the price paid, or replacement of the Software. No oral or written information given out expands the liability of MicroStrategy, Inc. 
beyond that specified in the above limitation of liability. Some states do not allow the limitation or exclusion of liability for incidental or consequential 
damages, so the above limitation may not apply to you.
The information contained in this manual (the Documentation) and the Software are copyrighted and all rights are reserved by MicroStrategy, Inc. 
MicroStrategy, Inc. reserves the right to make periodic modifications to the Software or the Documentation without obligation to notify any person or entity 
of such revision. Copying, duplicating, selling, or otherwise distributing any part of the Software or Documentation without prior written consent of an 
authorized representative of MicroStrategy, Inc. are prohibited. U.S. Government Restricted Rights. It is acknowledged that the Software and 
Documentation were developed at private expense, that no part is public domain, and that the Software and Documentation are Commercial Computer 
Software provided with RESTRICTED RIGHTS under Federal Acquisition Regulations and agency supplements to them. Use, duplication, or disclosure 
by the U.S. Government is subject to restrictions as set forth in subparagraph (c)(1)(ii) of the Rights in Technical Data and Computer Software clause at 
DFAR 252.227-7013 et. seq. or subparagraphs (c)(1) and (2) of the Commercial Computer Software—Restricted Rights at FAR 52.227-19, as applicable. 
Contractor is MicroStrategy, Inc., 1850 Towers Crescent Plaza, Vienna, VA  22182. Rights are reserved under copyright laws of the United States with 
respect to unpublished portions of the Software.
The following are either trademarks or registered trademarks of MicroStrategy Incorporated in the United States and certain other countries: 
MicroStrategy, MicroStrategy 6, MicroStrategy 7, MicroStrategy 7i, MicroStrategy 7i Evaluation Edition, MicroStrategy 7i Olap Services, MicroStrategy 8, 
MicroStrategy 9, MicroStrategy Distribution Services, MicroStrategy MultiSource Option, MicroStrategy Command Manager, MicroStrategy Enterprise 
Manager, MicroStrategy Object Manager, MicroStrategy Reporting Suite, MicroStrategy Power User, MicroStrategy Analyst, MicroStrategy Consumer, 
MicroStrategy Email Delivery, MicroStrategy BI Author, MicroStrategy BI Modeler, MicroStrategy Evaluation Edition, MicroStrategy Administrator, 
MicroStrategy Agent, MicroStrategy Architect, MicroStrategy BI Developer Kit, MicroStrategy Broadcast Server, MicroStrategy Broadcaster, 
MicroStrategy Broadcaster Server, MicroStrategy Business Intelligence Platform, MicroStrategy Consulting, MicroStrategy CRM Applications, 
MicroStrategy Customer Analyzer, MicroStrategy Desktop, MicroStrategy Desktop Analyst, MicroStrategy Desktop Designer, MicroStrategy eCRM 7, 
MicroStrategy Education, MicroStrategy eTrainer, MicroStrategy Executive, MicroStrategy Infocenter, MicroStrategy Intelligence Server, MicroStrategy 
Intelligence Server Universal Edition, MicroStrategy MDX Adapter, MicroStrategy Narrowcast Server, MicroStrategy Objects, MicroStrategy OLAP 
Provider, MicroStrategy SDK, MicroStrategy Support, MicroStrategy Telecaster, MicroStrategy Transactor, MicroStrategy Web, MicroStrategy Web 
Business Analyzer, MicroStrategy World, Application Development and Sophisticated Analysis, Best In Business Intelligence, Centralized Application 
Management, Information Like Water, Intelligence Through Every Phone, Intelligence To Every Decision Maker, Intelligent E-Business, Personalized 
Intelligence Portal, Query Tone, Rapid Application Development, MicroStrategy Intelligent Cubes, The Foundation For Intelligent E-Business, The 
Integrated Business Intelligence Platform Built For The Enterprise, The Platform For Intelligent E-Business, The Scalable Business Intelligence Platform 
Built For The Internet, Industrial-Strength Business Intelligence, Office Intelligence, MicroStrategy Office, MicroStrategy Report Services, MicroStrategy 
Web MMT, MicroStrategy Web Services, Pixel Perfect, Pixel-Perfect, MicroStrategy Mobile, MicroStrategy Integrity Manager and MicroStrategy Data 
Mining Services are all registered trademarks or trademarks of MicroStrategy Incorporated.
All other company and product names may be trademarks of the respective companies with which they are associated. Specifications subject to change 
without notice. MicroStrategy is not responsible for errors or omissions. MicroStrategy makes no warranties or commitments concerning the availability 
of future products or versions that may be planned or under development.
Patent Information
This product is patented.  One or more of the following patents may apply to the product sold herein: U.S. Patent Nos. 6,154,766, 6,173,310, 6,260,050, 
6,263,051, 6,269,393, 6,279,033, 6,567,796, 6,587,547, 6,606,596, 6,658,093, 6,658,432, 6,662,195, 6,671,715, 6,691,100, 6,694,316, 6,697,808, 
6,704,723, 6,741,980, 6,765,997, 6,768,788, 6,772,137, 6,788,768, 6,798,867, 6,801,910, 6,820,073, 6,829,334, 6,836,537, 6,850,603, 6,859,798, 
6,873,693, 6,885,734, 6,940,953, 6,964,012, 6,977,992, 6,996,568, 6,996,569, 7,003,512, 7,010,518, 7,016,480, 7,020,251, 7,039,165, 7,082,422, 
7,113,993, 7,127,403, 7,174,349, 7,181,417, 7,194,457, 7,197,461, 7,228,303, 7,260,577, 7,266,181, 7,272,212, 7,302,639, 7,324,942, 7,330,847, 
7,340,040, 7,356,758, 7,356,840, 7,415,438, 7,428,302, 7,430,562, 7,440,898, 7,486,780, 7,509,671, 7,516,181, 7,559,048, 7,574,376, 7,617,201, 
7,725,811, 7,801,967, 7,836,178, 7,861,161, 7,861,253, 7,881,443, 7,925,616, and 7,945,584. Other patent applications are pending.
Various MicroStrategy products contain the copyrighted technology of third parties. This product may contain one or more of the following copyrighted 
technologies:
Graph Generation Engine Copyright © 1998-2011. Three D Graphics, Inc. All rights reserved.
Actuate® Formula One. Copyright © 1993-2011 Actuate Corporation. All rights reserved.
XML parser Copyright © 2003-2011 Microsoft Corporation. All rights reserved.
Xalan XSLT processor. Copyright © 1999-2011. The Apache Software Foundation. All rights reserved.
Xerces XML parser. Copyright © 1999-2011. The Apache Software Foundation. All rights reserved.
FOP XSL formatting objects. Copyright © 2004-2011. The Apache Software Foundation. All rights reserved.
Portions of Intelligence Server memory management Copyright © 1991-2011 Compuware Corporation. All rights reserved.
ASIHTTPRequest library. Copyright © 2007-2011, All-Seeing Interactive. All rights reserved. 
This product includes software developed by the OpenSSL Project for use in the OpenSSL Toolkit. (http://www.openssl.org/)
VB.NET Create PDF from Excel Library to convert xlsx, xls to PDF
Image: Insert Image to PDF. Image: Remove Image from PDF Page. Image: Copy, Paste, Cut Image in Page. Data: Read, Extract Field Data. Data: Auto Fill-in Field
how to make a pdf form fillable in reader; export excel to pdf form
VB.NET PDF Text Extract Library: extract text content from PDF
PDF ›› VB.NET PDF: Extract PDF Text. VB.NET PDF - Extract Text from PDF Using VB. How to Extract Text from PDF with VB.NET Sample Codes in .NET Application.
pdf data extractor; pdf data extraction to excel
International Components for Unicode
Copyright © 1999-2011 Compaq Computer Corporation
Copyright © 1999-2011 Hewlett-Packard Company
Copyright © 1999-2011 IBM Corporation
Copyright © 1999-2011 Hummingbird Communications Ltd.
Copyright © 1999-2011 Silicon Graphics, Inc.
Copyright © 1999-2011 Sun Microsystems, Inc.
Copyright © 1999-2011 The Open Group
All rights reserved.
Real Player and RealJukebox are included under license from Real Networks, Inc. Copyright © 1999-2011. All rights reserved.
C# PDF Image Extract Library: Select, copy, paste PDF images in C#
Image: Extract Image from PDF. |. Home ›› XDoc.PDF ›› C# PDF: Extract PDF Image. How to C#: Extract Image from PDF Document.
how to fill out a pdf form with reader; make pdf form editable in reader
C# PDF Text Extract Library: extract text content from PDF file in
XDoc.PDF ›› C# PDF: Extract PDF Text. C# PDF - Extract Text from PDF in C#.NET. Feel Free to Extract Text from PDF Page, Page Region or the Whole PDF File.
exporting pdf form to excel; change font size pdf form reader
VB.NET PDF Image Extract Library: Select, copy, paste PDF images
Image: Extract Image from PDF. |. Home ›› XDoc.PDF ›› VB.NET PDF: Extract PDF Image. VB.NET PDF - Extract Image from PDF Document in VB.NET.
how to flatten a pdf form in reader; pdf data extraction tool
C# Create PDF from Excel Library to convert xlsx, xls to PDF in C#
Create PDF from Excel. |. Home ›› XDoc.PDF ›› C# PDF: Create PDF from Excel. Export PDF from Excel with cell border or no border.
pdf form field recognition; how to save a filled out pdf form in reader
© 2011 MicroStrategy, Inc.
v
C
ONTENTS
Description of guide..................................................................xv
About this book.............................................................................xv
Additional formats..................................................................xvi
How to find business scenarios and examples.....................xvii
What’s new in this guide......................................................xviii
Prerequisites........................................................................xviii
Who should use this guide.....................................................xix
Resources....................................................................................xix
Documentation.......................................................................xix
Education............................................................................xxvii
Consulting...........................................................................xxviii
International support...........................................................xxviii
Technical Support...............................................................xxviii
Feedback..................................................................................xxxiii
1. Understanding 
Functions in 
MicroStrategy
Introduction..................................................................................1
The basics of MicroStrategy objects, object definitions, and 
functions........................................................................................2
Function syntax and formula components.....................................4
Function types.........................................................................5
About function parameters.....................................................17
About arguments...................................................................24
Using functions in expressions....................................................24
Metric expressions.................................................................25
Attribute form expressions.....................................................32
Consolidation element expressions.......................................35
Custom Group expressions...................................................36
C# PDF Page Extract Library: copy, paste, cut PDF pages in C#.net
Page: Extract, Copy and Paste PDF Pages. Easy to Use C# Code to Extract PDF Pages, Copy Pages from One PDF File and Paste into Others in C#.NET Program.
extract data from pdf; pdf data extraction
VB.NET PDF Page Extract Library: copy, paste, cut PDF pages in vb.
VB.NET: Extract PDF Pages and Save into a New PDF File. You VB.NET: Extract PDF Pages and Overwrite the Original PDF File. Instead
extract data from pdf to excel; extract data from pdf file
Contents
MicroStrategy Functions Reference
vi
© 2011 MicroStrategy, Inc.
Fact expressions....................................................................38
Filter expressions...................................................................40
Subtotal expressions.............................................................41
Transformation expressions...................................................42
Adding functions to expressions with the Insert Function 
Wizard....................................................................................43
How MicroStrategy processes functions......................................46
Types of function processing.................................................46
How Intelligence Server uses functions.................................47
Using group-value functions..................................................47
Using single-value functions..................................................50
Using OLAP functions............................................................54
Using custom plug-in functions..............................................62
Additional examples of functions in expressions.........................66
Hypothesis Testing example..................................................66
Confidence Level example....................................................72
Statistical Descriptors - Simple example................................83
Forecasting example.............................................................86
2. Standard Functions
Introduction................................................................................91
Basic functions.............................................................................92
Add........................................................................................92
Average.................................................................................93
Avg (average)........................................................................94
Count.....................................................................................95
First........................................................................................98
GeoMean (geometric mean)..................................................99
Greatest...............................................................................100
Last......................................................................................101
Least....................................................................................102
Max (maximum)...................................................................103
Median.................................................................................105
Min (minimum).....................................................................106
Mode....................................................................................108
Multiply.................................................................................109
Product................................................................................110
StDevP (standard deviation of a population).......................111
StDev (standard deviation of a sample)...............................112
Sum.....................................................................................114
VarP (variance of a population)...........................................115
Var (variance of a sample)...................................................117
MicroStrategy Functions Reference
Contents
© 2011 MicroStrategy, Inc.
vii
Date and time functions.............................................................118
AddDays..............................................................................118
AddMonths...........................................................................119
CurrentDate.........................................................................120
CurrentDateTime.................................................................120
CurrentTime.........................................................................121
Date.....................................................................................121
DayofMonth.........................................................................121
DayofWeek..........................................................................122
DayofYear............................................................................123
DaysBetween.......................................................................123
Hour.....................................................................................124
Millisecond...........................................................................124
Minute..................................................................................125
Month...................................................................................125
MonthEndDate.....................................................................126
MonthStartDate....................................................................126
MonthsBetween...................................................................127
Quarter.................................................................................128
Second.................................................................................128
Week....................................................................................129
Year.....................................................................................129
YearEndDate.......................................................................130
YearStartDate......................................................................130
Internal functions.......................................................................131
Apply (Pass-Through) functions...........................................132
Banding functions................................................................137
Case functions.....................................................................143
NULL/Zero functions..................................................................148
IsNotNull..............................................................................148
IsNull....................................................................................149
NullToZero...........................................................................149
ZeroToNull...........................................................................150
OLAP functions..........................................................................150
ExpWghMovingAvg (exponential weighted moving 
average)...............................................................................151
ExpWghRunningAvg (exponential weighted running  
average)...............................................................................152
FirstInRange........................................................................153
Lag.......................................................................................155
LastInRange........................................................................160
Lead.....................................................................................161
Contents
MicroStrategy Functions Reference
viii
© 2011 MicroStrategy, Inc.
MovingAvg (moving average)..............................................163
MovingCount........................................................................164
MovingDifference.................................................................166
MovingMax (moving maximum)...........................................167
MovingMin (moving minimum).............................................169
MovingStDevP (moving standard deviation of a  
population)...........................................................................170
MovingStDev (moving standard deviation)..........................172
MovingSum..........................................................................173
OLAPAvg (OLAP average)..................................................175
OLAPCount..........................................................................178
OLAPMax (OLAP maximum)...............................................181
OLAPMin (OLAP minimum).................................................184
OLAPRank...........................................................................187
OLAPSum............................................................................189
RunningAvg (running average)............................................192
RunningCount......................................................................193
RunningMax (running maximum).........................................194
RunningMin (running minimum)...........................................195
RunningStDevP (running standard deviation of a  
population)...........................................................................196
RunningStDev (running standard deviation)........................198
RunningSum........................................................................200
Rank and NTile functions...........................................................201
NTile....................................................................................202
NTileSize.............................................................................204
NTileValue...........................................................................206
NTileValueSize....................................................................214
Percentile.............................................................................216
Rank....................................................................................217
String functions..........................................................................221
Concat (concatenate)..........................................................222
ConcatBlank (concatenate plus blank space)......................223
InitCap (initial capitalization)................................................224
LeftStr (left string selection).................................................225
Length (length of string).......................................................226
Lower (lower case)...............................................................227
LTrim (left trim).....................................................................228
Position (position of substring).............................................229
RightStr (right string selection).............................................230
RTrim (right trim)..................................................................231
SubStr (substring selection).................................................232
Trim......................................................................................233
MicroStrategy Functions Reference
Contents
© 2011 MicroStrategy, Inc.
ix
Upper (upper case)..............................................................234
3. Operators
Introduction..............................................................................235
Arithmetic operators...................................................................236
Minus (-)...............................................................................236
Times (*)..............................................................................236
Divide (/)..............................................................................237
Plus (+)................................................................................237
Unary minus (U-)..................................................................238
Comparison operators...............................................................239
Less than (<)........................................................................239
Less than or equal (<=)........................................................239
Not equal (<>)......................................................................240
Equal (=)..............................................................................241
Greater (>)...........................................................................241
Greater than or equal (>=)...................................................242
Begins with..........................................................................242
Between...............................................................................243
Contains...............................................................................243
Ends with.............................................................................244
In..........................................................................................244
Like......................................................................................245
Not begins with....................................................................246
Not between.........................................................................246
Not contains.........................................................................247
Not ends with.......................................................................247
Not in...................................................................................248
Not like.................................................................................248
Comparison for rank operators..................................................249
Less than or equal enhanced (*<=).....................................249
Not equal enhanced (*<>)....................................................250
Equal enhanced (*=)............................................................251
Greater than or equal enhanced (*>=).................................251
Between enhanced (*Between)...........................................252
Not between enhanced (Not *Between)...............................253
Logical operators.......................................................................254
And......................................................................................254
IF..........................................................................................254
Not.......................................................................................255
Or.........................................................................................256
Contents
MicroStrategy Functions Reference
x
© 2011 MicroStrategy, Inc.
4. Plug-In Package 
Functions
Introduction..............................................................................257
Data mining functions................................................................258
Financial functions.....................................................................259
Accrint (accrued interest).....................................................259
Accrintm (accrued interest at maturity)................................261
Coupdaybs (coupon period, beginning to settlement).........263
Coupdays (coupon period, number of days with  
settlement)...........................................................................264
Coupdaysnc (coupon period, settlement to next coupon)....265
Coupncd (next date after settlement)...................................266
Coupnum (coupon, number payable between settlement  
and maturity)........................................................................268
Couppcd (coupon date, previous)........................................269
Cumipmt (cumulative interest paid).....................................270
Cumprinc (cumulative principal paid)...................................271
Db (fixed-declining balance (asset depreciation))................273
Ddb (double-declining balance (asset depreciation))...........273
Disc (discount rate for a security)........................................274
Dollarde (dollar price, converted from fraction to 
decimal)...............................................................................275
Dollarfr (dollar price, converted from decimal to fraction)....276
Duration...............................................................................276
Effect (effective annual interest rate)...................................278
Fv (future value)...................................................................279
Fvschedule (future value schedule).....................................279
Intrate (interest rate)............................................................280
Ipmt (interest payment)........................................................281
IRR (internal rate of return)..................................................282
Mduration (modified duration)..............................................283
MIRR (modified internal rate of return)................................285
Nominal (nominal annual interest rate)................................286
Nper (number of investment periods)..................................287
NPV (net present value of an investment)...........................287
Oddfprice (odd-first-period price).........................................288
Oddfyield (odd-first-period yield)..........................................291
Oddlprice (odd-last-period price).........................................292
Oddlyield (odd-last-period yield)..........................................294
Pmt (payment).....................................................................296
Ppmt (principal payment).....................................................296
Price (price per $100 face value).........................................297
Pricedisc (price, discounted)................................................299
Pricemat (price at maturity)..................................................300
Pv (present value)................................................................302
Documents you may be interested
Documents you may be interested