Oracle essbase oracle olap the guide oracles multidimensional solutiohere

156Oracle Essbase & Oracle OLAP: The Guide to Oracle’s Multidimensional Solutio

To change to a snowflake schema, select Snowflake Schema from the Type of Dimension Table(s) drop-down list. In Figure 4-6, there are two hierarchies: Region

Chapter 4: Building an Oracle OLAP Analytic Workspace 157

In the case of a value-based hierarchy, the mapping screen requires only the parent and member keys.