meaopts

Use meaopts to set the options that apply to the following MDL verbs: MeasureAdd, MeasureMake, and MeasureUpdate.

ActivityMeasure
The ActivityMeasure option specifies the criteria used to determine the category count.
Allocation
The Allocation option specifies the type of allocation and a measure to which it applies.
Association
The Association option specifies the source column associated with this measure.
Calc
The Calc option specifies a calculation and the measure(s) to which it applies.
Decimals
The Decimals option specifies the number of decimal spaces in the source data.
Dimension
The Dimension option specifies the drill category, levels, and/or dimension to which the measure applies.
DrillThrough
The DrillThrough option specifies whether drill-through actions are enabled and lists the supported target reports, such as the relevant .imr file for Impromptu Query Definition (IQD) data sources.
DuplicateRollup
The DuplicateRollup option specifies how records with duplicate values will be rolled up or summarized.
DuplicateWeight
The DuplicateWeight option, along with the time state, specifies the weighting factors and functions used to obtain the weighted average of duplicate records for a measure.
Exclude
The Exclude option, followed by a list of excluded objects, restricts the scope of drill-through options so that only the non-excluded level(s) can serve as a starting point for drill-through operations. Use with the DrillThrough option to ensure that report users navigate directly to the relevant portion of the cube before they begin a drill-through operation.
Format
The Format option specifies the measure format and the number of decimal places to use.
IgnoreMissingValue
The IgnoreMissingValue option specifies whether to ignore null and missing (NA) values when performing certain kinds of time-state rollup (Average and Weighted Average). If you do not specify the option when you create, make, or update a measure, the default setting (include these values) applies.
IsCurrency
The IsCurrency option specifies whether the measure is a currency value.
IsFolder
The IsFolder option specifies whether the measure is a folder that groups several measures.
Label
The Label option specifies the label used for the measure.
MeasureInfo
The MeasureInfo option provides a description of the measure.
Missing
The Missing option specifies how records with missing or null values are to be represented in the reporting components.
Rollup
The Rollup option specifies how measure values are summarized or rolled up, across each reporting time period.
Parent
The Parent option uniquely identifies the parent object of the measure, where the model contains a hierarchy of measures.
Scale
The Scale option specifies the output scale for the measure.
ShortName
The ShortName option specifies the short name used to represent the measure.
Sign
The Sign option specifies whether the sign of a measure value is to be reversed, changing its value from a negative to a positive number, or from a positive to a negative number. Use this option to convert values into the form required by specific financial reports, such as debits and credits, or assets and liabilities.
Storage
The Storage option specifies the data type used to store the source values for this measure.
TimeStateRollup
The TimeStateRollup option specifies the function used to summarize or roll up measure values for a specific time period.
TimeStateWeight
The TimeStateWeight option specifies the object used to obtain the weighting for a time state rollup. Note that the TimeStateRollup option must be explicitly set to Average.
Timing
The Timing option specifies the timing that applies to the measure; that is, before or after roll-up.
Weight
The Weight option specifies the measure to use for weighting the time-state rollup. This option requires an object name, whereas the WeightID option uses the object identifier. For both, the TimeStateRollup option must be set to Average.
WeightID
The WeightID option specifies the measure to use for weighting the time-state rollup. This option requires an object identifier, whereas the Weight option uses the object name. For both, the TimeStateRollup option must be set to Average.

Parent topic: MDL options