Renaming Dimensions and Hierarchies

Currently, the Dimension names and the hierarchy names do not match between the Essbase cube in the physical layer and the existing Business Model and Mapping layer model. All Essbase cube dimensions and fact names must be renamed to be in synchronization with those in the Business Model and Mapping layer. This must be done in order for the Drag and Drop feature to work. See The Business Model and Mapping Layer Changes. The following figure displays the list of dimensions that have to be renamed.

Note:

Do not rename the External name.

Note:

In this example, it is assumed that Department is the cost center and is renamed Dim - -Cost Center. Department might also be different from Cost Center, in which case it should not be renamed Cost Center.

This table shows examples of renamed dimensions..

Also, the previous changes do not cover the Non Qualified Segment Dimensions. If a Non Qualified Segment Dimension is present in an Essbase cube, then the Dimension Name should be renamed Dim-GL SegmentX and Hierarchy to GL SegmentX, where X is from 1 to 10, depending upon which dimension it is mapped to.

For example, if Product Dimension is mapped to GL Segment 1, then Product Dim is renamed to Dim-GL Segment1 and Hierarchy to GL Segment1 in the physical layer. In addition, for Unqualified Segment Dimensions, rename the code attributes inside the dimension to match attributes of GL SegmentX in the Business Model and Mapping layer.

This screen shot shows renamed code attributes.

Note:

The attributes ending with Memnor, Ancestor Ref, and Member Key are not renamed, because they are deleted. See The Business Model and Mapping Layer Changes. For dimensions that share members across hierarchies, clear Use unqualified name for better performance. If you fail to do so, unknown member errors can occur.

Figure 39, Example of Essbase Hierarchy Displaying Dimensions as Shared Members shows a company Dimension with shared members.

Figure 39. Example of Essbase Hierarchy Displaying Dimensions as Shared Members

This screen shot displays an Essbase hierarchy with dimensions as shared members.

  To rename hierarchies and dimensions:

  1. For company Dimension (Renamed Dim–Balancing Segment), in the physical layer of the Oracle BI repository, double-click the dimension and select the Hierarchies tab.

  2. Select the hierarchy and clear Use unqualified name for better performance as shown in step step 4.

  3. Click OK twice.

  4. Click OK in the Physical Dimension-Balancing Segment dialog box.

This screen shot displays an example of how to change the name of a physical hierarchy for a dimension.