Queries in the Business layer

In the previous section, we learned how to use the Check Integrity wizard to find integrity problems. The integrity issues can be automatically discovered and corrected by the IDT. On the other hand, the functional problems cannot be identified without human intervention. We will use the Queries tab in the Business layer left panel to generate test queries to test our Business and Data Foundation layers. We can build some queries and validate the results to make sure that our Business model is correct.

We can also build queries in the Business layer to analyze data and check the validity of the SQL query generated from this Business query. It is a useful tool to explore data and simulate what will happen in the Business object reports based on this Universe, without the need to create a customized report to perform functional tests.

Tip

The Queries feature has many usages and we will use it heavily in Chapter 7, The Data Foundation Layer – Advanced Topics, to check...