I am using Visual Studio 2008 Analysis Services and processing the AdventureWorks database to create and process a cube. I have defined the Product dimension that contains two hierarchies. In spite of having deployed and processed this dimension repeatedly and successfully, I am unable to browse this dimension.
From the Browser tab, I encounter these conditions: none of the attributes nor aggregations in the dimension show up in the Hierarchy dropdown menu; the screen shows an error message saying "The dimension does not contain hierarchies. Ensure that the dimension has been processed." That the dimension contains hierarchies and I have both processed the dimension and deployed the entire cube successfully has no bearing on this message, nor does clicking on "Click here to try loading the browser again" have any effect.
I think the problem has to do with a parameter I've been tweaking. The name of the tutorial on which I'm working is "Defining the Unknown Member and Null Processing Properties", and although the lesson is confusing, it asks me to reset the "UnknownMember" and "UnknownMemberName" properties of the dimension and the "NullProcessing" property of the key field. Having a great deal of trouble getting my dimension to deploy, I perused this lesson in chaotic order, and I think there's some combination of settings that's keeping me from seeing the dimension from the browser at the dimension level. The efforts I've made thus far have failed.
Perhaps helping me with these confusing parameters is the best place to start.
Best, ~Peter Ferber