How To Implement Ragged Hierarchy In Obiee 11g
How To Implement Ragged Hierarchy In Obiee 11g --->>> https://urluss.com/2tabtB
2. Define the hierarchy. You define a hierarchy for a logical dimension by using SQL to create a hierarchy for the logical dimension. To create a hierarchy for the logical dimension, you use the SQL CREATE HIERARCHY statement, which must include a column name that stores the parent value, and an expression that returns the name of the child that has a value. You can specify a depth for the hierarchy. You can use the CREATE HIERARCHY statement to create a hierarchy in a logical dimension table. When you use the CREATE HIERARCHY statement, the table that is created to store the hierarchy receives a name with the prefix HYPER. The name of the parent column is the name of the logical dimension. A table is also created to store each level of the hierarchy. The hierarchy table has the same name as the logical dimension and the columns that are specified in the CREATE HIERARCHY statement become child columns of the logical dimension table.
3. Define the hierarchy for each level. You define the hierarchy for each level of the logical dimension by using the SQL CREATE LEVEL statement. For each level in the hierarchy, you specify a parent value, the name of the table that stores the hierarchy, and an expression that returns the name of the child level that has a value. You can also specify a depth for each level. You can use the CREATE LEVEL statement to create a hierarchy in a logical dimension table. When you use the CREATE LEVEL statement, the table that is created to store the hierarchy receives a name with the prefix LEVEL. The name of the parent column is the name of the logical dimension. A table is also created to store each level of the hierarchy.
1. Create the logical dimension tables. You create logical dimension tables by using the SQL CREATE TABLE statement. Each logical dimension table must contain a primary key, an optional parent-key column, a column to display name, and one or more columns for values. The values of the columns in a logical dimension table form a hierarchy. You can use the same procedure to create another table for each level of the hierarchy. The parent-key column of each table is optional. You use the parent-key column to create a hierarchical data model, which is required in order to define a level-based hierarchy for the logical dimension.
If you want to build a level-based query that returns all of the rows from a logical dimension, for example, all of the active customers in the Time dimension, you can create a logical dimension with a level-based hierarchy. In the Business Model or Mapping layer, create a logical dimension that represents a logical hierarchy and that includes a single level. For example, Customer represents a single level of the Customer dimension in the Business Model or Mapping layer.
1. In the Business Model or Mapping layer, create the logical dimensions you want to use. When you create a logical dimension, you can see what dimensions are mapped to the logical dimension and how many records are mapped to the logical dimension. 827ec27edc