Analysis Services
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.