Databases Reference
In-Depth Information
Figure 8-20
UnknownMember is a property for each dimension in your database. If there
are referential integrity issues in your relational database, then during parti-
tion processing Analysis Services will raise appropriate errors. If you have set
specific processing options to ignore errors, but include the fact data corres-
ponding to errors in the cube, then Analysis Services allocates the fact data
to a member called the Unknown member in the dimensions for which it is un-
able to find members due to referential integrity issues. You have the option
of allowing the Unknown member to be visible or hidden, using the dimension
property UnknownMember. When the UnknownMember is set to be visible,
the member name is set to UnknownMember and will be included in the res-
ults of the MDX queries that contain the hierarchy. Similar to the All member
name, Analysis Services gives you the option of changing the name of the
Unknown member to a more meaningful name corresponding to that specific
dimension.
Search WWH ::
Custom Search