﻿
MicroStrategy Functions Reference
Glossary
Glossary: fact
527
fact 1) A measurement value, often numeric and typically
aggregatable, stored in a data warehouse.
2) A schema object representing a column in a data
warehouse table and containing basic or aggregated
numbers—usually prices, or sales in dollars, or inventory
quantities in counts.
See also metric.
hierarchy A set of attributes defining a meaningful path for element
browsing or drilling. The order of the attributes is
typically—though not always—defined such that a higher
attribute has a one-to-many relationship with its child
attributes.
metric 1) A business calculation defined by an expression built with
functions, facts, attributes, or other metrics. For example:
Sum(dollar_sales) or [Sales] - [Cost].
2) The MicroStrategy object that contains the metric
definition. It represents a business measure or key
performance indicator.
See also fact.
schema object MicroStrategy object created, usually by a project designer,
that relates the information in the logical data model and
physical warehouse schema to the MicroStrategy
environment. These objects are developed in MicroStrategy
Architect, which can be accessed from MicroStrategy
Desktop. Schema objects directly reflect the warehouse
structure and include (among others) attributes, facts,
functions, hierarchies, operators, partition mappings, tables,
and transformations.
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
filling out pdf forms with reader; extract pdf data into excel
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
saving pdf forms in acrobat reader; how to make a pdf form fillable in reader
Glossary
MicroStrategy Functions Reference
528
Glossary: simple metric
simple metric A type of metric defined by a formula containing a
mathematical expression based on at least one group
function, such as sum or average, which is applied to facts,
attributes, or other metrics. It can also contain non-group
functions or arithmetic operators, in addition to the required
group function.
Examples are Avg(Sum((Cost_Fact +
Profit_Fact))) and Avg((Cost_Metric +
Profit_Metric))).
sort by The order of the return values of an expression in relation to
the order of the value or metadata object given. A sort by
includes whether to sort in ascending or descending order,
and which metadata object to sort by. Sort by may also be
performed on the value of the subexpression, which is the
input argument.
To sort by a value or metadata object in an expression, you
must set the SortBy parameter.
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.
exporting pdf form to excel; how to type into a pdf form in reader
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 into excel; html form output to pdf
529
I
NDEX
A
Abs  314
Accrint  259
Accrintm  261
Acos  314
Acosh  315
analytical engine  46
And  254
application object  defined on 2
Apply functions  5, 11
ApplyAgg  133
ApplyComparison  134
ApplyComparison in filter  16
ApplyLogic  134
ApplyOLAP  134
ApplySimple  135
example  12, 16, 134, 135, 136
syntax  132
using extra arguments in  132
ApplyAgg  133
example  133
ApplyComparison  134
example  12, 16, 134
in filter  16
ApplyLogic  134
example  134
ApplyOLAP  134
example  135
ApplySimple  135
example  15, 136
argument  24
arithmetic operator  236
Divide  237
Minus  236
Plus  237
Times  236
Unary Minus  238
Asin  315
Asinh  316
Atan  316
Atan2  316
Atanh  317
attribute  defined on 2, 24
attribute form expression  32
accessing  34
Average  93
average  94
moving  163
OLAP  175
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
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
extracting data from pdf into excel; pdf form field recognition
Index
MicroStrategy Functions Reference
530
running  192
Avg  94
AvgDev  334
B
banding functions  131
BandingC  139
BandingP  141
base formula  25
basic functions  92
Average  93
Avg  94
First  98
GeoMean  99
Greatest  100
Last  101
mathematical (arithmetic
operators)  236
Max  103
Median  105
Min  106
Mode  108
Product  110
StDev  112
StDevP  111
Sum  114
Var  117
VarP  115
Begins With  242
Between  243
Between Enhanced  252
BinomialDistribution  336
break by  defined on 9
parameter  19
confidence level  72
hypothesis testing  66
statistical descriptors - Simple  83
C
Case  144
case functions  132
Ceiling  317
ChiSquareDistribution  338
ChiSquareTest  340
Combine  318
comparison for rank operator  249
Between Enhanced  252
Equal Enhanced  251
Greater Equal Enhanced  251
Less Equal Enhanced  249
Not Between Enhanced  253
Not Equal Enhanced  250
comparison operator  239
Begins With  242
Between  243
Contains  243
Ends With  244
Equal  241
Greater  241
Greater Equal  242
In  244
Less Equal  239
Less Than  239
Like  245
Not Begins With  246
Not Between  246
Not Contains  247
Not Ends With  247
Not Equal  240
Not In  248
Not Like  248
compound metric  26
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
how to save fillable pdf form in reader; change font size pdf form reader
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.
exporting data from excel to pdf form; make pdf form editable in reader
MicroStrategy Functions Reference
Index
531
Confidence  340
configuration object  defined on 2
consolidation element expression  35
accessing  36
Contains  243
Correlation  341
Cos  319
Cosh  319
count
moving  164
OLAP  178
running  193
Coupdaybs  263
Coupdays  264
Coupdaysnc  265
Coupncd  266
Coupnum  268
Couppcd  269
Covariance  342
CritBinomial  343
Cumipmt  270
Cumprinc  271
CurrentDate  120
CurrentDateTime  120
CurrentTime  121
custom expression
ApplyComparison in filter  16
custom group  defined on 36
custom group expression  36
accessing  37
D
Data Mining functions  258
Date  121
date and time functions
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
MonthsBetween  127
MonthStartDate  126
Quarter  128
Second  128
Week  129
Year  129
YearEndDate  130
YearStartDate  130
DayOfMonth  121
DayOfWeek  122
DayOfYear  123
DaysBetween  123
Db  273
Ddb  274
Degrees  320
deviation
standard (population)  111
standard (sample)  111, 112
dimensionality  25
Disc  274
distribution, standard normal
cumulative  112
Divide  237
Dollarde  276
Dollarfr  276
Duration  276
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.
extracting data from pdf to excel; how to fill out a pdf form with reader
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.
exporting pdf data to excel; extract pdf data to excel
Index
MicroStrategy Functions Reference
532
E
Effect  278
Ends With  244
engine
analytical  46
query  46
SQL  46
Equal  241
Equal Enhanced  251
example
Apply function  12, 15, 16, 134, 135,
136
ApplyAgg  133
ApplyComparison  12, 134
ApplyLogic  134
ApplyOLAP  135
ApplySimple  15, 136
prompted date  12
Exp  321
ExponentialDistribution  344
ExpWghMovingAvg  151
ExpWghRunningAvg  152
F
fact expression  38
accessing  39
Factorial  321
FDistribution  346
filter  defined on 40
ApplyComparison function in  16
filter expression  40
accessing  41
financial functions
Accrint  259
Accrintm  261
Coupdaybs  263, 264
Coupdaysnc  265
Coupncd  266
Coupnum  268
Couppcd  269
Cumipmt  270
Cumprinc  271
Db  273
Ddb  274
Disc  274
Dollarde  276
Duration  276
Effect  278
Fv  279
Fvschedule  279
Intrate  280
Ipmt  282
IRR  282
Mduration  284
MIRR  285
Nominal  286
Nper  287
NPV  287
Oddfprice  288
Oddfyield  291
Oddlprice  292
Oddlyield  294
Pmt  296
Ppmt  296
Price  297
Pricedisc  299
Pricemat  300
Pv  302
Rate  303
Sln  305
Syd  305
Tbilleq  306
Tbillprice  307
Tbillyield  308
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
extract pdf form data to xml; sign pdf form reader
passwordSetting.IsAnnot = True ' Allow to fill form. passwordSetting.IsFillForm = True ' Content extraction is allowed. True ' Add password to PDF file.
extract data from pdf using java; extract data from pdf to excel online
MicroStrategy Functions Reference
Index
533
Vdb  309
Yield  309
Yielddisc  311
Yieldmat  312
First  98
first occurrence  229
FirstInRange  153
Fisher  345
Floor  322
Forecast  346
ForecastV  348
formula, metric  25
formula. See compound metric.
FTest  350
function
basics of  4
function plug-In  62
function type  5
Apply function  11
Apply functions
example  12
comparison function  10
group-value function  8
OLAP function  9
single-value function  5, 6
Fv  279
Fvschedule  279
G
GeoMean  99
Greater  241
Greater Equal  242
Greater Equal Enhanced  251
Greatest  100
Growth  352
GrowthV  353
H
HeteroscedasticTTest  355, 356
HomoscedasticTTest  355, 356
Hour  124
HypergeometricDistribution  357
I
If  145, 254
In  244
InitCap  224
initial capitalization  224
InitialCap  224
Input Metric Formula dialog box  31
Insert Function Wizard  43
Int  323
Intercept  358
internal functions
ApplyAgg  133
ApplyComparison  134
ApplyLogic  134
ApplyOLAP  134
ApplySimple  135
BandingC  139
BandingP  141
Case  144
international support  xxviii
Intrate  280
InverseChiDistribution  360
InverseFDistribution  361
InverseFisher  360
InverseLognormalDistribution  362
InverseNormDistribution  363
InverseNormSDistribution  364
InverseTDistribution  365
Ipmt  282
Index
MicroStrategy Functions Reference
534
IRR  282
IsNotNull  148
IsNull  149
K
Kurtosis  365
L
Lag  155
Last  101
LastInRange  160
LeftStr  225
Length  226
Less Equal  239
Less Equal Enhanced  249
Less Than  239
Like  245
Ln  324
Log  324
Log10  325
logical operator  254
And  254
If  145, 254
Not  255
Or  256
LognormalDistribution  366
Lower  227
LTrim  228
M
mathematical functions
Abs  314
Acos  314
Acosh  315
Asin  315
Asinh  316
Atan  316
Atan2  316
Atanh  317
Ceiling  317
Combine  318
Cos  319
Cosh  319
Degrees  320
Exp  321
Factorial  321
Floor  322
Int  323
Ln  324
Log  324
Log10  325
Mod  325
Power  326
Quotient  327
Randbetween  328
Round  329
Round2  330
Sin  331
Sinh  331
Sqrt  331
Tan  332
Tanh  333
Trunc  333
Max  103
maximum
moving  167
OLAP  181
running  194
Mduration  284
MeanTTest  367
Median  105
metric  defined on 2, 25