Database Reference
In-Depth Information
At this point, we create a new measure group named Bridge Sales Reasons ,
containing a single, hidden measure named Bridge Sales Reasons Count
that will count the number of rows of the BridgeOrdersSalesReasons table;
this measure might never be used in queries, but every measure group has to
contain at least one measure. This will be our intermediate measure group in the
many-to-many dimension relationship. In the Dimension Usage tab, we add
the Sales Reason dimension, which will have a regular relationship with the
Bridge Sales Reasons measure group. What is less intuitive is how to create the
relationship between the Sales Order dimension and the new measure group.
The Sales Order dimension is a degenerate dimension and its content is stored
in the fact table. Moreover, the granularity of the bridge table is the order number,
while the granularity of the Sales Order dimension is the order line number.
However, we can define a regular relationship with a non-key granularity attribute,
such as Order Number using the SalesOrderNumber column, as we can see in the
following screenshot:
 
Search WWH ::




Custom Search