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:
- Select the namespace folder and, from the Actions menu, click Create
Query Subject.
- In the Name field, type a name for the new query subject.
- Click Data Source and click OK. The New Query Subject wizard
window opens.
- 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.
- Click Finish.
- Right-click the query subject you created and click Edit Definition.
- Click the SQL tab, and from the Available database objects
box, drag objects to the SQL box.
- To insert a data source, click Insert data source.
- To insert a macro, click Insert macro.
- To provide control over granularity, click the Determinants tab.
- To test the query subject, click the Test tab.
- To view the SQL, click the Query Information tab.
- To view the system tables from the data source, select the Show System
Objects check box.
- Click OK. A warning appears if any modifications invalidated relationships,
other query subjects, calculations, or filters.
- 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.