You are adding dimensions and a new measure group named Accounts Receivable 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 InvoiceDate DueDate and
PaymentDate.
You need to ensure that users can slice the Accounts Receivable measures by InvoiceDate,
DueDate, and PaymentDate. 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 three new perspectives named InvoiceDate, DueDate, and PaymentDate.
B.
Create three independent dimensions named InvoiceDate, DueDate and PaymentDate
and then link all three of them to the Accounts Receivable measure group.
C.
Create cube dimensions named InvoiceDate, DueDate, and PaymentDate by using the
existing Date dimension in the database.
D.
Add three attributes named InvoiceDate. DueDate, and PaymentDate to the existing Date
dimension in the database.
“B” & “C” are ok, but “C” means less work for us…