Creating a data source query subject

Data source query subjects directly reference data in a single data source. Framework Manager automatically creates a data source query subject for each table and view that you import into your model. You can add any combination of objects to a query subject, such as query items, other query subjects, or dimensions. You can add stand-alone calculations and filters, and you can also embed calculations and filters in the query subject.
About this task
To create a data source query subject:
  1. Select the namespace folder and, from the Actions menu, click Create Query Subject.
  2. In the Name field, type a name for the new query subject.
  3. Click Data Source and click OK. The New Query Subject wizard window opens.
  4. Complete the steps in the New Query Subject wizard.
    Note: Note: To ensure that the data source is uniquely identified for a data source query subject, do not exit the wizard before the Finish button is displayed.
  5. Click Finish.
  6. Right-click the query subject you created and click Edit Definition.
  7. Click the SQL tab, and from the Available database objects box, drag objects to the SQL box.
  8. To insert a data source, click Insert data source.
  9. To insert a macro, click Insert macro.
  10. To provide control over granularity, click the Determinants tab.
  11. To test the query subject, click the Test tab.
  12. To view the SQL, click the Query Information tab.
  13. To view the system tables from the data source, select the Show System Objects check box.
  14. Click OK. A warning appears if any modifications invalidated relationships, other query subjects, calculations, or filters.
  15. Make sure that the Usage and Regular Aggregate properties are set correctly. You can do so by clicking a measure and viewing the Usage and Regular aggregate properties in the Properties view.
You can now customize this query object to create a model query subject.

Feedback