|name, displayName, description, disabled
||See Common Attributes in a Cube.
||Specify one of these attributes in almost the same way that you would specify Property or Expression in the Architect; see Specifying the Source Values for a Dimension or Level and Details for Source Expressions. Notes:
You can enclose the value in double quotes instead if the value itself does not contain any double quotes. For example: sourceExpression="%source.property/100"
For sourceProperty, use the same value you would enter for Property, enclosed within single quotes.
For example: sourceProperty='Age'
For sourceExpression, use the same value you would enter for Expression, enclosed within single quotes.
For example: sourceExpression='%source.property/100'
||(Optional) Specifies the data type for the measure. Most measures are numeric, which is the default. See Specifying the Measure Type.
|iKnowSource, iKnowDomain, iKnowDictionaries, iKnowParameters
||(Optional) See Using Text Analytics in Cubes in Advanced Modeling for InterSystems Business Intelligence.
||(Optional) Specifies how to aggregate values for this measure, whenever combining multiple records. If you specify this, use one of the following values:
For a boolean or a string measure, this attribute must be "COUNT".
"COUNT" — Counts the records for which the source data has a non-null (and nonzero) value.
"MAX" — Uses the largest value in the set.
"MIN" — Uses the smallest value in the set.
"AVG" — Calculates the average value for the set.
||(Optional) If hidden="true" then the measure is defined and can be used in queries, but is not listed as an available measure in the Analyzer. This lets you define measures that serve as intermediate calculations.
||(Optional) Specifies the number of decimal places to keep. By default, scale is 0, and the system rounds each measure value to a whole number before writing it to the fact table.
||(Optional) See Linking to Another Table.
||(Optional) If searchable="true" then the system displays this measure as an option in advanced filters, where you can create filter expressions that refer to the measure value (typically to compare the measure value to a constant).
For a searchable measure, the system adds an additional index, if appropriate, to support these expressions. See Measure Search Expressions in the InterSystems MDX Reference. A searchable measure cannot include square brackets or commas (,) in its name.
Note that it may be possible to use a measure as a searchable measure in a manual MDX query even if it is not marked as searchable="true".
In all cases, the measure is also available for use in the same way as any other measure.
(Optional) Name, in the generated fact table, for the column that corresponds to this measure. If this attribute is null, the system generates a name. This option does not apply to NLP measures. Be sure not to use an SQL reserved word. For a list of the SQL reserved words, see Reserved Words in the InterSystems SQL Reference. The name must start with either a letter or a percent sign (%). If the first character is %, the second character must be Z or z. For more details on restrictions, see Class Members. Also, do not use fact or listing, in any combination of lowercase and uppercase characters.
||Internal ID assigned to this measure. Required if namedFactNums is "true" for the cube.
||(Optional, not used by the system)Value to override the generated selectivity of the property in the fact table class. Business Intelligence queries do not use this parameter. This option is intended for cases where SQL is used directly against the generated fact table and the generated selectivity needs to be overridden.
Specify a positive value less than or equal to 1. For details, see SetFieldSelectivity() in %SYSTEM.SQLOpens in a new tab.
||(Optional) Controls how the values are displayed. See formatString Details.
||(Optional) Indicates the units in which the measure value is expressed. Currently this attribute is provided only for general information.
|listingFilterOperator and listingFilterValue
||(Optional) These attributes specify an optional additional filter that is applied when a user selects this measure in a pivot table and then displays a listing. For details, see Specifying Additional Filtering for Listings, in Defining Measures.