Syntax of Analytica's OLE Link Monikers


When you paste a link from an Analytica table into Excel (or other application), a Moniker is stored identifying the source of the data. You can view these Monikers in Excel by looking either at the cell contents, or at the Links... dialog. This page describes the syntax of that moniker. This syntax may be relevant at some point since you can change the moniker using the "Change Source..." button in Excel's Links... dialog.

Excel names its source of data using a similar style moniker, as to other OLE link server applications.

The basic syntax looks like this (some parts may be absent in a particular link):

Analytica.Model|«filename»!«ident»!«view»(«params»)«*»[«slice»]C=«ci»,X=«cv»<«vert»;«horiz»>#«numberFmts»

where

Analytica.Model 
Identifies the registry setting that tells Excel which application to launch to get the data.
«filename» 
A path to the model file, quoted with single quotes.
«ident» 
The Analytica identifier of the variable containing the data
«view» 
The view that the data is coming from, possible values are:
Mid, Mean, Stats, ProbBands, PDF, CDF, Sample, EditTable, BrowseTable
(BrowseTable is an EditTable copied from Browse mode.)
«params» 
For certain views, additional parameters describing the view are specified between parens. For views with no extra parameters, this part does not show up.
Stats(«statList») : Identifies which statistics are being computed
ProbBands(«percentiles») : Identifies which percentiles are being computed
PDF(«ptsPerCurve» ,«method») : Method is 0 for Equal-X, 1 for Equal-wt-P, and 2 for Equal-Samp-P.
CDF(«ptsPerCurve», «method»)
«*» 
An astrisk appears if this is a full Multi-D table format (via Copy Table).
«slice»
A comma separated list of identifier=position pairs identifying which slice is being viewed. For example:
Mid[J = 2, K = 3]
C=«ci» 
The comparison index. This part appears only if there is a comparison index. «ci» is the index identifier.
X=«cv» 
The comparision value(s). This part only appears if there is one or more comparison values (as is used in an XY plot). Here «cv» consists of a comma-separate list of expressions, although the expressions are usually identifiers.
«vert» 
describes the vertical dimension. This may be just the identifier of the index, or it may specify a range of rows. It can also be just an astrisk when there is no vertical index. For example, this may appear as:
Ind {The full index range}
Ind=3:5 {Index Ind is the vertical, but only rows 3 through 5 are accessed}
* {There is no vertical index}
«horiz» 
Describes the horizontal dimension, using the same format as «vert»
#«numberFmts» 
A list of number formats that are used in the result. Each is prefixed with a # symbol. The syntax for this number format is exactly what appears in the NumberFormat attribute. Multiple number formats will appear when different columns have different number formats.

When pasting into Excel, the precision of numbers is not preserved -- so that the numbers are copied at full precision. However, information as to whether the data is rendered as numeric or as a date remains relevant.

See Also

Comments


You are not allowed to post comments.