You are developing a SQL Server 2008 Analysis Services (SSAS) method for Company.com.
There is a table called Product which includes listed columns below:
* ProductKey
* Logger
* ProductNumber
Firstly you develop a dimension called DimProductOrders from the Product table, and then configure the ProductKey as a key column and the Logger column as a property.
At last you create a measure group called FactProductOrders from the Product table.
You should make sure that you could develop a dimension relationship .
Then you could make ProductNumber column gathered by the Logger column.
Which is the correct answer?
A.
Between the DimProductOrders dimension and the ProductNumber measure group, you should develop a virtual dimension relationship.
B.
Between the DimProductOrders dimension and the ProductNumber measure group, you should develop a fact dimension relationship.
C.
Between the DimProductOrders dimension and the ProductKey measure group, you should develop a fact dimension relationship.
D.
Before configuring the Granularity attribute to ProductKey and the measure group columns to ProductNumber, you should you should develop a fact dimension relationship.
Explanation:
Dimension Usage Relationship Types
Relationship type purpose
Regular Defines the relationship when a dimension is joined directly to a measure group through a specific attribute called the granularity attribute.
Fact Used when the dimension is based on the fact table used to define the measure group.
Referenced Used when a given dimension is related to a measure group through an intermediate dimension.
Many-To-Many Specifies that a dimension is related to a given measure group through an intermediate measure group.
Data Mining Defines the relationship between a dimension based on a data mining model and a given measure group.EXAM TIP
Sometimes after analyzing the database schema and designing fact and dimension tables, you will be left with columns in the fact table that do not justify moving them to designated dimension tables, such as Sales order number. yet reporting requirements might require you to let end users browse data by these columnsfor example, to see all sales order line items for a given sales order. you can meet such requirements by building dimensions directly from the fact table and then joining them to the related measure groups through a fact relationship.