What are the conditions for levels to be defined in a hierarchy? Provide some information

What are the conditions for levels to be defined in a hierarchy? Provide some information

1. Use the same parameter name, when the same column is used in different dimensions. 2. Use the same column name and parameter name, when same level name is used across different dimensions. 3. Use unique level names across different column names and parameter names. Typical problems encountered when these above conditions are not satisfied is exceptions during drill down in the KPI grid