Viewing virtual levels

When you create a virtual cube, IBM® Cognos® Cube Designer adds levels from the source cubes to the virtual cube.

Source cubes containing identical levels in a hierarchy are merged as virtual levels. If levels in the source cubes are not identical, level names from the first source cube are used as the names of the virtual levels. If one source cube contains more hierarchy levels than the second source cube, the extra levels are added as the lowest levels of the virtual hierarchy. For examples of the merging process, see Virtual cubes.

Procedure

From the Project Explorer tree, right-click the virtual hierarchy for which you want to view virtual levels and select Open Editor. The editor tab shows the following columns:
  • Virtual levels - the virtual levels added to the virtual hierarchy.
  • Levels - the source levels in the source cubes to which the virtual level is mapped.
Tip: If the virtual hierarchy was created from one source hierarchy only (not merged), only one source level column is shown.