MembersWithDataValues

ms133429.note(en-US,SQL.90).gifNote:
  This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

Enumerates values for the MembersWithData property.

Constant Description

dataforLeafMembersOnly

Only leaf members can have data in the fact table. A processing error occurs if data for a nonleaf member appears in the fact table.

dataforNonLeafMembersHidden

Any member (except the All member) can have data in the fact table. Data for nonleaf members is hidden (totals may not appear to add up correctly).

dataforNonLeafMembersVisible

Any member (except the All member) can have data in the fact table. Data for nonleaf members is visible in system-generated leaf members.

Community Additions

ADD
Show: