Troubleshooting: Computed field query direction performance

While in Cognos® it is possible to query up the relationship tree (that is, compute values based on ancestors), but it is strongly discouraged.

When exploring all the computation possibilities there is one large distinction in what can and should be done. The automatic framework generation is set up in such a way as to create joins that are conducive to better performance querying down the relationship tree. A query up the tree will result in bad computed field performance as well as place a large strain on the Database that can result in the entire application slowing down.