Creating or modifying a model query subject

Model query subjects are based on query items in other query subjects or dimensions, including other model query subjects.
About this task
By using model query subjects, you can create a more abstract, business-oriented view of a data source. You can add any combination of objects to a query subject, such as query items, other query subjects, and dimensions. You can add stand-alone calculations and filters, and embed calculations and filters in the query subject.
Carry out the following steps to create a model query subject based on a data source object:
  1. Select the namespace folder and, from the Actions menu, click Create Query Subject.
  2. In the Name box, type a name for the new query subject.
  3. Click Model, and click OK.
  4. To add items to the model query subject, click the Query Subject Definition tab, and from the Available Model Objects box, drag objects to the Query Items and Calculations box. You can also embed a filter. If you add calculations or filters to a model query subject, IBM® Cognos® must go to the data source instead of simply accessing the model. You can change the order of items and calculations for a model query subject. However, if the query subject contains a query item folder, you can change the order only in the Project Viewer.
  5. If you want to test the query subject, click the Test tab.
  6. Click OK. A warning appears if any modifications invalidated relationships, other query subjects, calculations, or filters.
  7. Ensure that the Usage and Regular Aggregate properties are set correctly.
You can select existing model objects and merge them into a new model query subject. By doing so you can reuse existing metadata to quickly create query subjects. The objects that you can merge include:
  • Relational data source query subjects and their shortcuts
  • Model query subjects and their shortcuts
  • Query items, filters, and calculations in model and data source query subjects
  • Relationships and relationship shortcuts between model and data source query subjects
You can merge any number of the same type of objects into a new query in a single operation. The merge always creates a new model query subject. The new query subject contains any filters that exist in the original query subject. To create a new model query subject based on existing objects:
  1. Ctrl+click the objects that you want to merge into a single query subject.
  2. From the Actions menu, click Merge in New Query Subject.
Example
What to do next

Feedback