We have a many to many scenario and we are trying to get the following
analysis scenarion enabled

Computer Table:
ComputerName
ComputerID
ComputerGroup Table:
ComputerGroupName
ComputerGroupID
ComputerToComputerGroup Table:
Computer GroupID
ComputerID

So the tables obviously join like this:
Computer.ComputerId -> ComputerToComputerGroup.ComputerId ->
ComputerGroup.ComputerGroupIdU

Then we have a fact table named ComputerStats:
Date,
ComputerId,
FailureInstanceCount

How do we setup the dimensions such that we can slice and dice using
[ComputerName] or [ComputerGroupName] and get the right aggregate (SUM)
values gor FailureInstanceCount?

Nevermind . . . I just neede to link the two related dimensions (Computer -
Computer Group) using a amny to many relationship in the Dimension Usage tab
<smile>

"Steven H" <heinz_steven (AT) emc (DOT) com> wrote