Set Members with Data Property (Dimension Wizard)

In this step of the wizard, you can enable associated data for nonleaf dimension members, that is, dimension members with one or more descendants.

This step is displayed only if you selected Members with data in the Select advanced options step of the wizard.

Options

Nonleaf members have associated data

Select to allow dimension members to have associated data in the fact table.

• Data members are visible

  Select to display and aggregate data for nonleaf members as a visible data member.

• Data members are hidden

  Select to have data for nonleaf members override the aggregate value of the dimension's regular members.