You are adding dimensions and a new measure group named Service Quality to an existing SQL Server Analysis Services (SSAS) cube.
Date is one of the existing dimensions in the SSAS database. The underlying fact table for the measure group is associated with multiple dates, including FirstServiceDate, SecondServiceDate, and ThirdServiceDate.
You need to ensure that users can slice the Service Quality measures by FirstServiceDate, SecondServiceDate, and ThirdServiceDate. You also need to ensure that the time required to process the database is minimized.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Create cube dimensions named FirstServiceDate, SecondServiceDate, and ThirdServiceDate by using the existing date dimension in the database.
B. Create three independent dimensions named FirstServiceDate, SecondServiceDate, and ThirdServiceDate and then link all three of them to the Service Quality measure group.
C. Create three new perspectives named FirstServiceDate. SecondServiceDate, and ThirdServiceDate.
D. Add three attributes named FirstServiceDate, SecondServiceDate, and ThirdServiceDate to the existing date dimension in the database.
