I'm running the "SQL Server Analysis Services Tutorial" (see http://msdn.microsoft.com/en-us/library/ms170208.aspx
), using Visual Studio 2008 against the AdventureWorks database in SQL Server 2008. I have two sets of hierarchies I've defined: one for the customer and one for Calendar Time. The customer hierarchies show where the customer lives and is shown in the following levels: Country Region, State Province, City; whereas the Time hierarchy has these levels: Year, Semester, Quarter, Month, Date.
When I view the browser for the Customer Hierarchy, I see in the Hierarchy dropdown menu, in addition to the field names, the name of the hierarchy as a selectable item. When I choose this, I see a very nice tree structure by Country Region ("Australia", "Canada", "France", etc.) followed by the State Province within each Country Region (Within Australia: "New South Wales", "Queensland", "South Australia", etc.), followed by the Cities within each State Province (within New South Wales: "Coff's Harbor", "Darlinghurst", "Goulburn", etc.).
For some reason, however, when I view the "Time" hierarchy, I do not see the entire hierarchy listed in the Hierarchy dropdown menu, just the individual field names. When I choose a field name, I see only an alphabetical list of the contents of that one field (Month: "April", "August", "December", etc.).
One dimension allows me to see a nested view of the entire hierarchy while the other allows me to see the contents of only one individual field at a time. I am clearly missing whatever it is that permits or denies me the option of selecting a full hierarchal view.
Your assistance is most appreciated. Thank you, ~Peter Ferber