Data source query subjects directly reference data in a single
data source. This section describes how to update query subjects.
About this task
To update the query subject do the following:
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.
Building relationships between query subjects
You can create a relationship to join logically related
objects that your users want to combine in a single report. This is
useful for relationships between objects that were not selected during
metadata import, were not joined in the data source, or are from multiple
sources.
Convert to a regular dimension or measure
All regular dimensions begin as query subjects. If you
converted a query subject to a regular dimension, note that determinant
information for the query subject is leveraged as a starting point
to define the levels of a single hierarchy.