I am trying to setup a Many-To-Many dimension. When setting it up, you
simply select the intermediate fact table. Behind the scenes, what is it
doing? How does it create the appropriate join? Is it however the DSV is
setup?

Thanks,

Joe

its not a DSV related feature.
the system "filter" the members of the dimension in the first measure group
regarding the existance of these members into the second measure group.

for example, you select a campaign, this campain is associated to 10
products, then you use the number of sales measure, the result is the sales
for these 10 products only.


"jgb23" <jgb23 (AT) discussions (DOT) microsoft.com> wrote

So here is my issue.

I have a fact table that has summary values (as a column) with details of
that total. For example

Product Cat Product Summary Detail
X X 500 250
X Y 500 250

There is one dimension called product that has attributes of both Product
Cat and Product included. The user wants to be able to see Product Category
Attributes at the Product level or vise versa. I built a summary fact table
and did a MTM based on the detail table. I loaded 2 product categories (X
and Y) , which covers products A,B, and C and did a MTM for my product
dimension. When I analyze the data, I get the summary total data (summary
measure group) for A,B, and C, but it also applies the summary for a totally
unrelated product.

I am totally confused as to why it would do this. Any thoughts?

"Jeje" wrote: