What is the advantages of creating hierarchy in SSAS? What are the difference between drag and drop year,month one by one and single hierarchy on browser?
Mainly:
Aggregations: If you want the sum per year and you have aggregations per month, SSAS will sum all the monthly aggregations instead of summing all the values on that particuallar year
Its a Microsoft best practice to add big dimensions in some sort of hierarchy and set the AttributeHierarchyVisible property to false so the attribute is enable to be browsed through the hierarchy but not alone. That prevents the user of dragging a attribute with 1 million rows to the cube, which would break it