Issues with dynamic cubes that contain members with duplicate level keys

In IBM® Cognos® Dynamic Cubes 10.2.1 and later versions, when you browse members with duplicate level keys in IBM Cognos Cube Designer, the member tree is constructed as you expand each member, and no check is done for members with duplicate level keys. However, when you start a dynamic cube that contains members with duplicate level keys, the cube might now fail with an error. This behavior is a result of improved validation in this release.

To avoid this error, you can update the hierarchy level that contains duplicate level key members by specifying more columns to ensure that the level key is unique.

If you don't want to update the dynamic cube, you can disable the new validation check. To do that, for every dispatcher that owns a query service, set the query service property Additional JVM arguments for the query service to -DdisableDuplicateLevelCheck=true, and restart the query service. For more information, see Setting query service properties for dynamic cubes.