Deployed, processed, but unbrowsable dimension

PeterFrb
PeterFrb used Ask the Experts™
on
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

DimensionStructure.bmp
AttributeRelationships.bmp
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Check properties of your attributes like IsAggregatable too.

There are a few ways you can render a dimension unreadable - IsAggregatable is one of my favourites. ;)

Rob
PeterFrbData anslyst, tableau visualization developer, vb certified

Author

Commented:
Not the problem, but I'm glad to have notice of other booby traps potentially lying on the road.  Cheers! ~Peter
PeterFrbData anslyst, tableau visualization developer, vb certified

Author

Commented:
As it turns out, I checked the next day after having turned off my machine and revisited it, and everything now works.  I'm giving you credit however: I"m glad to know what else to look for.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial