the Product Dimension to Verify the Modified Management of Unknown Members via
the modified dimension, and then leverage the convenience of the built-in Browser
to verify the effects of our handiwork.
the Product dimension within the Solution Explorer.
... from the context menu that appears, as depicted in Illustration 7.
Illustration 7: Process
the Product Dimension ...
when asked if we wish to ... save all changes first.
has successfully completed, click the Browser tab in Dimension
Designer for the Product dimension.
Click the Reconnect
button, once again.
Categories in the Hierarchy list.
Assembly Components appears as a new member of the Category
level, as shown in Illustration 8.
Illustration 8: Assembly
Components Appears as a Member of the Category Level ...
Expand the Assembly
Components member of the Category level.
Expand the Assembly
Components member that appears underneath the Assembly Components
member just expanded (itself a member of the Subcategory level).
We next see all the Assembly Components appearing
at the Product Name level, as partially depicted in Illustration 9.
Illustration 9: Assembly
Components Appears at the Product Name Level Product Category Hierarchy
10. Returning to the Hierarchy
list, select Product Model Lines.
11. Expand All Products.
12. Expand the Assembly Components
member of the Product Line level.
13. Expand the Assembly Components
member of the Model Name level.
We now see the Assembly Components appearing at the
Product Name level, as shown in Illustration 10.
Illustration 10: Assembly
Components Appears at the Product Name Level Product Model Lines Hierarchy
demonstrated the effectiveness of our settings in managing Unknown Members,
and having received confirmation from our client colleagues that their
immediate business requirements have been met through the solution we have demonstrated,
we conclude our two-part practice session. We have established the capability
to manage Unknown Members through settings modifications for a dimension
within our clients cube.
14. Close the Business Intelligence
Development Studio when ready.
In this two-part article, we embarked upon an examination of the
management of Unknown Members within Analysis Services. We noted
that the Unknown Member property settings offer us capabilities, similar
to those found in once dominant enterprise BI applications such as Cognos
PowerPlay / Transformer, for handling unmatched dimension keys. The
capabilities afforded by the Unknown Member options allow us to override
the processing failure that would occur in these cases of mismatch, to assign a
name other than Unknown to the Unknown Member within each
dimension, to control visibility of the Unknown Member, and more.
first half of our article, we gained some exposure to the default management of
Unknown Members by Analysis Services. Our examination included a discussion surrounding the general concepts and
properties underpinning Unknown Members, including what they define and
support, as well as the mechanics behind their management. We then prepared a
sample Analysis Services database with related objects, and began a hands-on
practice session, first reviewing Unknown Member properties settings at
the dimension level. Next we created new attributes within the Product
dimension, upon which we based a user-defined hierarchy, and upon which we intended
to establish, in the second half of the article, Unknown Member management
capabilities within the supporting properties.
processing the enhanced Product dimension and examining the mechanics
behind the exclusion of members without corresponding key values within the
underlying data, we moved to this, Part II, of our article. In this
half, we continued to gain an introduction and hands-on exposure to managing Unknown
Members, resuming our procedures with the sample cube that we
created in Part I.
Our continuing examination included further coverage, where appropriate, of the
general concepts and properties (including what they define and support, and
how we can manage them) underpinning Unknown Members. We established Unknown
Member management within the associated supporting properties for the Product
dimension attributes that we added to the sample cube, at the request of our
client colleagues, in the first half of our article. We then processed the enhanced Product
dimension, and used the Browser within the Dimension Designer
to verify the effectiveness of the results of our work. Finally, throughout
the article we discussed other considerations that surround our management of Unknown
See All Articles by Columnist William E. Pearson, III
Discuss this article in the MSSQL Server 2000 Analysis Services and MDX Topics Forum.