What difference between dimension and hierarchy>what is mean by maxl?Difference between esscmd and maxl?If we are using only dense dimension in outline what will be effect of cube structure?
Answered by: Sahil on: Oct 25th, 2011
Dimensions are like your lookup tables and Hierarchies forms Dimensions. Inside dimensions there exists hierarchies. Example Employee is a dimension , inside Employee dimensions there can be hierarchies such as Directors hierarchy, Managers Hierarchy and employees Hierarchy etc.,,
A dimention is nothing but a subject oriented meta data, just like hr section, employees section etc. and the hierarchy is depend on the data source, like "hour glassmodel"Account dime...
Dimensions are like your lookup tables and Hierarchies forms Dimensions. Inside dimensions there exists hierarchies. Example Employee is a dimension , inside Employee dimensions there can be hierarchies such as Directors hierarchy, Managers Hierarchy and employees Hierarchy etc.,,
A dimention is nothing but a subject oriented meta data, just like hr section, employees section etc. and the hierarchy is depend on the data source, like "hour glassmodel"Account dime...