I have cube that has a fact table of web page hits. Each hit has a
product associated, and each product falls into 1 or more categories.
So in a typical M:M model, I create a bridge table between page hits
and product categories. So I have a table that has the page hits
counted multiple times Once for each associated product category).

I link the web page hits fact table to the bridge table, then the
bridge table to the dimension category table, make a measure group out
of the bridge table, then go to associate the product dimension to the
web page hits count. I select the Many-to-Many option and the Bridge
table (now measure group) is not listed. There are keys between the
bridge table and both the web page fact and the product category
tables, so I cannot figure why the table wouldn't be listed. My DSV and
Cube Structure diagram looks just like the Adventureworks sample,
except my bridge table is built in the DSV and not materialized in the
database.

What is the Dimension Usage wizard looking for in the M:M criteria for
listing the table?

Any insight into where I could look would be greatly appreciated.

to use the many-many feature, you have to create a measure group (with at
least 1 measure) based on the many-many table.
this measure group will have 2 dimensions: product & hit
then you can create your many-many relationship for your measure group "Hit
count" and the dimension product.

AS will propose the new measure group to do the many-many link because he
found that the HIT dimension is a common dimension of the 2 measure group.


<Steven.Muise (AT) gmail (DOT) com> wrote