How to Replace a Table with a Derived Table

This post describes the detailed steps to replace a database table with a derived table. Also it describes how Universe Documenter can help to achieve the perfect quality even for such complex modification of a universe. You may need to replace a table with a derived table if your universe is affected by the self-outer […]

Use of Outer Joins in Combination with Self Restricting Joins

Problem BusinessObjects use some algorithm for SQL generation based on objects selected in the query and the universe. There are a number of parameters that control SQL generation. The problem is that in some cases BO generates SQL that is not intuitively expected. What we would expect is that the self restricting joins are applied […]