Skip to content

configure-measure-properties.md

Latest commit

 

History

History
70 lines (64 loc) · 4.62 KB

configure-measure-properties.md

File metadata and controls

70 lines (64 loc) · 4.62 KB
title Configure Measure Properties | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology analysis-services
ms.topic conceptual
helpviewer_keywords
additivity [Analysis Services]
ID property
ErrorConfiguration property
AggregateFunction property
DisplayFolder property
IgnoreUnrelatedDimensions property
FormatString property
Description property
semiadditive
properties [Analysis Services], measure groups
aggregate functions [Analysis Services]
DataType property
ProcessingMode property
MeasureExpression property
AggregationPrefix property
Visible property
properties [Analysis Services], measures
StorageLocation property
StorageMode property
formats [Analysis Services], measures
Source property
aggregations [Analysis Services], measures
measures [Analysis Services], properties
nonadditive [Analysis Services]
Name property
measures [Analysis Services], display formats
ProcessingPriority property
measure groups [Analysis Services], properties
Type property
ProactiveCaching property
ms.assetid e9031078-c4f5-4986-b0c9-4d064b622ab7
author minewiskan
ms.author owend
manager craigg

Configure Measure Properties

Measures have properties that enable you to define how the measures function and to control how the measures appear to users.

You can set properties in [!INCLUDEssBIDevStudioFull] when creating or editing a cube or measure. You can also set them programmatically, using MDX or AMO. See Create Measures and Measure Groups in Multidimensional Models or CREATE MEMBER Statement (MDX) or Programming AMO OLAP Basic Objects for details.

Measure Properties

Measures inherit certain properties from the measure group of which they are a member, unless those properties are overridden at the measure level. Measure properties determine how a measure is aggregated, its data type, the name that is displayed to the user, the display folder in which the measure will appear, its format string, any measure expression, the underlying source column, and its visibility to users.

Property Definition
AggregateFunction Required. Determines how measures are aggregated. Sum is the default aggregation. For more information, see Use Aggregate Functions for a description of each function.
DataType Required. Specifies the data type of the column in the underlying fact table to which the measure is bound. This value is inherited from the source column by default.
Description Provides a description of the measure, which may be exposed in client applications.
DisplayFolder Specifies the folder in which the measure will appear when users connect to the cube. When a cube has many measures, you can use display folders to categorize the measures and improve the user browsing experience.
FormatString You can select the format that is used to display measure values to users by using the FormatString property of the measure.

Although a list of display formats is provided in [!INCLUDEssBIDevStudioFull], you can specify many additional formats that are not in the list. You can specify any named or user-defined format that is valid in Microsoft Visual Basic.
ID Required. Displays the unique identifier (ID) of the measure. This property is read-only.
MeasureExpression Specifies a constrained MDX expression defining the value of the measure. The expression is evaluated at the leaf level before being aggregated, and allows for weighting of a value. For example, in currency conversion where a sales amount is weighted by the exchange rate.
Name Required. Specifies the name of the measure.
Source Required. Specifies the column in the data source view to which the measure is bound. See Data Sources and Bindings (SSAS Multidimensional).
Visible Determines the visibility of the measure in client applications.

See Also

Configure Measure Group Properties
Modifying Measures