IBM Cognos, User Manual, Page: 267 / 411

TR0137
Cube Group cube_group_name (and possibly others) contains cubes based upon
key orphanage categories. Due to the temporary nature of these categories, the
data in these cubes may belong to other cubes within their respective cube groups.
Cognos Transformer has created a key orphanage in the target level for a cube
group. This can happen in models for which the following conditions exist:
v The model uses multiple data sources.
v
The model contains one or more cube groups.
v
The data in the specified data sources does not provide sufficient information to
connect a category to one of the target categories in the cube group.
Procedure
1. In the PowerCubes list, Cognos Transformer generates a cube definition for the
key orphanage category within the cube group. You cannot delete this cube.
However, the problem will be automatically corrected if a subsequently
processed data source contains data that can provide the path from the
orphaned category to the source category in the target level.
2. Alternatively, you can resolve the problem by adding information to the model
that eliminates the need for both the key orphanage and the orphaned cube.
This can be done in one of the following ways:
v
Manually assign the categories in the orphaned category to one of the others
in the target level, assuming you know which one they belong to.
v
Determine what data is missing in your original data source, and either
supply that data or add a new source with the information needed to
complete the path from a category in the target level to the orphaned
categories.
If a key orphanage is created and later deleted during a single cube generation
process, the resulting cube group will have an invalid status.
Cognos Transformer can eliminate a key orphanage when all of its descendants
are placed under other categories in other cubes within the cube group. In such
cases, you must regenerate the cube group so that the data is moved into the
correct cubes. For more information, see “TR0713” on page 272.
TR0149
A data input conversion or overflow error has occurred.
This error occurs when the data for a measure is too large for the storage type that
is specified for it. This can arise if a measure includes decimals, or is assigned a
large input or output scale.
Procedure
To resolve the problem, try to minimize the Input scale property, as specified on
the
General
tab of the
Column
property sheet, and the corresponding
Output
scale
, as specified on the
General
tab of the
Measure
property sheet.
If this does not work for your model, change the
Storage Type
property on the
General tab of the Measure property sheet to a larger storage type.
Appendix C. IBM Cognos Transformer Error Messages
253