Creating Cubes and Cube-to-Cube Maps (Doc ID 1205549.1)

Last updated on JULY 28, 2016

Applies to:

Oracle Strategic Operational Planning - Version: 4.0.0.0.00 to 4.0.3.0.00 - Release: 4.0 to 4.0
Information in this document applies to any platform.

Goal

A cube is a subset of data organized in a multidimensional structure. Cubes are defined by a set of dimensions. A cube has at least two dimensions, one of which is a measure dimension. Other dimensions provide indexes to identify measure values in the cube.

Cube dimensions are based on categories of business data. Common dimensions are Fiscal, Manufacturing, Geography, Product, and Customer. Each dimension consists of members that can be organized into hierarchies with levels. For example, hierarchy levels in the FiscalCalendar dimension include Months, Quarters, and Years.

After creating cubes, you can map them to allow data values in one cube to flow to data values in another cube. Because cubes have different structures, the mapping defines how to flow the data. The mapping is like a table join in the relational world—it defines the common dimensions and how to map or join them.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms