Properties

Properties

A level can have properties, which you can display in pivot tables.

1. Click New.

2. Expand the HomeD dimension in the Model Contents pane.

3. Expand the City level, then drag and drop City to Rows.

   The system displays something like the following:

   

   The measure shown is Count, which is a count of patients.

4. Drag and drop Population to Columns.

5. Drag and drop Principal Export to Columns.

   The system displays the following:

   

6. Click the X button in the Rows pane.

7. Drag and drop ZIP to Rows.

   The system displays something like the following:

   

   These properties do not have values for this level.

In pivot tables, properties are different from measures in several ways:

• Properties can have string values.

• Properties have values only for the level in which they are defined.

Depending on how a cube is defined, properties can also affect the sorting and the member names of the level to which they belong. There are examples later in this tutorial.