Article ID: 2027628 - View products that this article applies to.
The UnknownMember property for an Analysis Services dimension is used to determine whether the unknown member of a dimension is visible, hidden, or disabled (Visible, Hidden, or None). The unknown member of a dimension can be used to store values for facts which had missing or unknown dimension key values at the time a partition was processed. Setting the UnknownMember property to hidden for a dimension is generally not recommened as it can result in query results that appear not to aggregate correctly when there are facts associated with the UnknownMember. This occurs because the totals returned for a query include the values from the visible members as well as the hidden UnknownMember. If the user doesn't realize that the UnknownMember is hidden they may think that the totals for the query are incorrect. Setting the UnknownMember property for dimensions to Visible or None is the recommended best practice, as it can help identify referential integrity problems with the source data or incorrect processes in the Extraction Transformation and Loading (ETL) processes for the data warehouse. A value of Visible provides a visual cue after processing by surfacing the UnknownMember in query results, while setting the property to None will result in processing errors when the dimension key from a fact record is missing or cannot be matched to an existing member in the dimension.
For more information about the products or tools that automatically check for this condition on your instance of SQL Server and on the versions of the SQL Server product, see the following table:
Collapse this tableExpand this table
Contact us for more help
Connect with Answer Desk for expert help.