ssas - Understanding the Cube display in SQL Studio Manager -

i have built small data warehouse using adventure works database. have deployed sql studio manager. have written first mdx query

select  customer.[full name].members on rows, order (measures.[sales amount],asc) on columns [adventure works dw2012]  

please see screenshot below:

i understand top level of hierarchy dimensions i.e. customer, date, due date, interne sales, order date, product , ship date. understand dimensions have attributes. example: model name, product line, product name attributes of product dimension , product model lines hierarchy of product dimension.

what meant by: financial; history , stocking?

you've come against think genuinely confusing , ill-designed aspect of ssas.

you're correct model name, product line , product name attributes of product dimension. you're seeing here (in screenshot) hierarchies called model name, product line , product name.

these not "hierarchies" in sense people use term (a structure more 1 level). they're "attribute hierarchies" based on attributes of same name. have one level 2 levels. (edit: whytheq pointed out, have 1 leaf level, , have "all" level).

(edit) product model lines "real" (aka "user") hierarchy, multiple levels apart , leaf levels, based on multiple attributes.

financial, history , stocking "folders". "created" setting of attributehierarchydisplayfolder property of attribute in dimension design (or displayfolder property of "real" hierarchy). have nothing dimension structure - they're display convenience. necessary because, becomes clearer more try explain it, structure of dimensions in ssas unnecessarily complicated.

you can hide "attribute hierarchies" client applications (e.g. excel) setting attributehierarchyvisible property of attribute false. they'll still show in mdx "helper" screen you're looking at.