Oracle Exam 1Z0-1041-23 Topic 8 Question 22 Discussion

Two statements that are true about hierarchy and levels are:

Each level is based on one or multiple columns. A level is a logical grouping of one or more columns that represent a certain granularity or detail of data. For example, a level can be based on a single column, such as Year, or multiple columns, such as Year and Quarter.

Hierarchies enable drilling in reports. A hierarchy is a logical structure that defines the relationships among levels and shows how data can be aggregated or disaggregated from one level to another. For example, a hierarchy can show how Year, Quarter, Month, and Day are related in a time dimension. Hierarchies allow users to drill down or drill up in reports to see different levels of detail or summary of data. Reference: [Oracle Analytics Cloud - Data Visualization User's Guide], [Oracle Analytics Cloud - Data Visualization User's Guide]