A recursive relationship exists between SALES_STAFF_CODE and MANAGER_CODE in the
SALES_STAFF data source query subject. This query subject is provided in a model to report
authors. Using this query subject alone, report authors cannot create a report that includes
management staff and the sales staff that report to them. How can the existing recursive
relationship in the model be modified to provide this ability to report authors?
A.
Import a query subject that does not contain a recursive relationship.
B.
Create a star schema grouping that contains the SALES_STAFF data source query subject and
a shortcut to the SALES_STAFF data source query subject.
C.
Create a model query subject with the appropriate relationship to the existing SALES_STAFF
data source query subject and make both available to report authors.
D.
Create a shortcut to the SALES_STAFF data source query subject, and report authors will use
it instead of the underlying query subject to create the required report.
Explanation: