IBM DB2 Warehouse Cubing Services known issues: Modifying the structure of your cube hierarchy

Technote (troubleshooting)


Do not modify the structure of the cube hierarchies to be different from the cube model hierarchy. If you modify the cube hierarchies, any calculated members that are defined on that hierarchy might not be valid when you start the cube.

Diagnosing the problem

If you do modify the structure, you will create more hierarchies than you originally designed when you retrieve metadata from the repository.

Resolving the problem

To subset or modify the hierarchy, create a new hierarchy.

To create a new hierarchy:

    1. Within Design Studio, drill-down in the Project Explorer to Hierarchies.
    2. Right-click on Hierarchies and select Add Hierarchy.

Document information

More support for:

DB2 Cube Views

Software version:


Operating system(s):

Linux, Windows

Reference #:


Modified date:


Translate my page

Content navigation