Users want to compare Actual Revenue and Sales Target values by Month. Actual Revenue
values are stored at the day grain in the Orders Fact table. Sales Target values are stored at the
month grain in the Sales Target Fact table.

In Framework Manager, which technique will best prevent Sales Target values from being doublecounted in Query Studio reports?

A.
Define both Month and Day determinant levels in the Time Dimension and Group By Day.

B.
Define both Month and Day determinant levels in the Time Dimension and Group By Month.

C.
Create separate star schema groupings for Orders Fact and Sales Target Fact, both at the
month grain.

D.
Set scope for Actual Revenue at the Day level and Sales Target at the Month level in the
Dimension Map.

Explanation: