Note: This question-is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question-in the series. Each question-is independent of the other questions in this series. Information and details provided in a question-apply only to that question.
You are implementing a Microsoft SQL Server data warehouse with a multi-dimensional data model.
Business users observe that the value displayed for the profit margin is the average profit margin across all products. The profit margin must be calculated per product.
You need to modify the existing model without changing the overall structure of the data model.
What should you use?
A. star schema
B. snowflake schema
C. conformed dimension
D. slowly changing dimension (SCD)
E. fact table
F. semi-additive measure
G. non-additive measure
H. dimension table reference relationship
