Within the Data Source Model Editor, you can add member properties to any level of a data source model
for use in generating Interactive and Analyzer reports.
-
Click the Analysis tab.
-
Select a field from the
Available pane to the Analysis
pane.
-
With the field selected, click
the Add Member Property icon.
The New Member Property dialog box
appears.
-
Enter a name for the new member property. Click OK
-
Set the source column for the new member property. Expand the level with new member property and choose the member property.
A yellow caution icon appears next to the parent dimension, hierarchy,
and level of the new child member property. The icon indicates you need to
specify the source column for the new member properties before proceeding. Enter
a name for the new member property.
-
Specify the source column for the new member property. Click Fix Missing Column.
The Select Source Column dialog
appears.
-
Chose a column from the available list. Click OK.