Creating Analysis Services Cubes - SQL Server Analysis Services 2012 Cube Development - page 80

Measure property Explanation

ary 10th, you will see the data of January 10th
when browsing the data for January;
• LastNonEmpty : This reports the last semi-additive
non-null (non-empty) value.

By default, SSAS measures inherit the data type from the
underlying data source. However, the list of supported
data types varies from one relational platform to the next,
so you need to ensure that the relational type can be
mapped to the SSAS type.

DataType

By default, all the measures show up under the Measures
folder in the client application. If you have multiple meas-
ure groups within a single cube, measures would be listed
under the corresponding measure groups. If you have
many measures within a measure group, it makes sense
to organize related measures into folders, for example,
cost-related measures could be included in the COST
folder and price-related measures under PRICE . The
DisplayFolder property allows you to type in the folder
name. If you have used a folder name once, you can
choose the same name for another measure from a drop-
down box instead of having to retype it.

DisplayFolder

MeasureExpression This function allows specifying the MDX formula for deriv-
ing a measure's value based on another measure. Meas-
ure expressions are useful for many-to-many relationships
discussed later in this chapter. You will learn more about
measure expressions in Chapter 4 , Extending and Cus-
tomizing Cubes .