Purchase your Section 508 Compliance Support guide now!

Purchase your Section 508 Compliance Support guide now!

Cognos 8 -- planning your model

If you are modeling a normalized data source, you may become interested in generating Minimized SQL for your model. Minimized SQL will help to reduce the number of tables used in some requests and it can aid in performance.

You should consider creating relationships and determinants between the data source query subjects, and then create model query subjects that do not have relationships.

Some FM model developers believe that if you do not have relationships between objects, you cannot create star schema groups. This is not necessarily true. You can select the model query subjects to include in the group and use the Star Schema Grouping wizard. In addition, you can create shortcuts and move them to a new namespace in your model. There is no need to have shortcuts to the relationships; this feature is purely visual in the diagram. The affect on query generation and presentation in the both Query Studio and Report Studio is the same.