ABC corporation’s data warehouse has a sales data fact table with columns containing the following
. Market
. Period
. Product Type
. Units
. Dollars
They want to include data on average unit revenue in their ad hoc reports. Which two of the following are valid ways to accurately fulfill this requirement?
A.
Modify the underlying physical data warehouse table to include a column for average unit revenue, modify the ETL process to calculate and store this value, and modify the logical and physical models in the repository to include this column
B.
modify the physical model in the repository and add a derived metric column to store this value. Define this column as dollar divided by units. Add a corresponding Column in the logical data model and associate with the newly added physical Model column
C.
Modify the logical model in the repository and ad a newly metric column define this column as calculation of dollars divided by units from physical mode.
D.
Modify the logical model in repository and add the derived metric column. Define this column as calculation of dollars divided by units from the logical model.