Home > OLAP Dialog Boxes and Wizards > Create/Edit Cube Dimension:...
![]() Previous |
![]() Next |
These settings provide flexibility in naming dimension members and in applying data constraints.
Dimension Member Loading: Choose one of the following methods of creating dimension values. If you change this setting after loading dimension members, the change affects new members, but it does not change existing members.
Generate Surrogate Keys in the Analytic Workspace: Select this option unless you know that every dimension member is unique. During the load, the level name is added as a prefix to each value. You must define the dimension with at least two levels to use this option.
Use Keys from Data Source: If you are sure that dimension members are unique across levels, then you can use the exact key values from the source as dimension members in the analytic workspace. For example, if your relational schema uses numeric surrogate keys to assure uniqueness, then there is no need to create new surrogate keys for the dimension.You can use the source keys to define either level-based or value-based hierarchies. You must use source keys if you plan to map summary fact tables.
Hierarchy Data Constraints: Hierarchy data constraints enforce consistency among data values. Choose one of these levels of consistency:
Consistent: All hierarchies in a dimension are consistent with each other. For example, "Total Customer" represents the same list of customers in all measures. Consistency across all hierarchies ensures that the definition of an aggregate value is the same regardless of where it appears.
Solve Consistent: All hierarchies used in the aggregation of a single cube are consistent with each other. This is the minimal level of consistency and assures that the aggregated values of one hierarchy are not overwritten by the aggregated values of another hierarchy.
Star Consistent: All hierarchies of the dimension are consistent with each other. Moreover, if a parent has children at the same level in multiple hierarchies, those children must be identical. Star consistency assures that the dimension complies with the materialized view requirements of a star schema.
To create cube materialized views, use Analytic Workspace Manager. You can download this tool from the Oracle OLAP website at
http://www.oracle.com/technetwork/database/options/olap/olap-downloads-098860.html
Related Topics