The Property View on the Analysis tab

In the Property view on the Analysis tab, you can define properties for the data source, measures and dimensions in the workbook. You can show or hide this section by choosing Start of the navigation path Display Next navigation step Show Property View End of the navigation path in the design panel group.

The properties can also be changed using the ribbon. If you change a property on the Analysis tab, the changes are also reflected in the ribbon.

The available properties depend on the selected data source element. At the top of the Properties section, you always find the description and technical name of the selected data source element. You can select the data source, measures, a single measures, dimensions, members and hierarchies.

For hierarchies, only the properties of the assigned hierarchy can be changed.

Table 1: Data Source Properties
Property	Options
Zero Suppression	Zero Suppression in Rows Zero Suppression in Columns
Compact Display	Compact Display in Rows Compact Display in Columns
Totals	Total Rows Above Members Total Columns Left of Members
General Format	Display of Negative Values Display Zero as

Table 2: Measures Properties
Property	Options
Members	Display Use
Currency Conversion	You can open the currency conversion dialog.

Table 3: Single Measure Properties
Property	Options
Scaling Factor	You can select the scaling factor that should be used.
Decimal Places	You can select the decimal places that should be used.

Table 4: Dimension Properties
Property	Options
Members	Display Use
Totals	Show Totals Hide Totals Hide Totals if Only One Member is Available
Sort	Sort Ascending Sort Descending You can also open the sorting dialog.

Table 5: Member Properties
Property	Options
Members	Display Use
Totals	Show Totals Hide Totals Hide Totals if Only One Member is Available

Table 6: Hierarchies Properties
Property	Options
Expand	Expand Downwards / Expand to the Right Expand Upwards / Expand to the Left
Show	Nodes with only One Lower-Level Node Values of Posted Nodes