TR1700
The category category_name in the dimension dimension_name has n immediate descendants. This number should normally be close to 7. More levels may be appropriate in this dimension.
This message is a design recommendation and will not affect your ability to generate categories or create PowerCubes.
Categories with too many immediate descendants yield reports that are difficult to use. For example, in a time dimension with only two levels, Years and Days, each Year category has 365 immediate descendants. Navigating through the resulting reports would be difficult.
Procedure
To improve OLAP performance and usability, add manual levels
to create a structure that limits the number of immediate descendants
at each parent level. We recommend a child:parent ratio of 10:1 or
less. In the above case, add intermediate levels for Quarters and
Months.
Tip: You can change the warning level
by changing the default Warn when the number of child categories
exceeds setting located on the General tab
of the Preferences property sheet. The default
value is
35.