When you create objects in the business layer, test them by creating and running queries with the Information Design Tool. There are three things to test:
- Do the objects exist?
If not, you may have forgotten to save your universe since the object you are testing was created.
- Does the SQL appear correct?
- Are the results of the query correct?