Hello,

I have a problem I need some assistance with. Firstly, I appoligise for
the terms used. I am reasonalbly new to this.

The issue is that the Group Dimension has multiple enteries of the
Machine dimension's key. ie. Machine 1 is related to Group 1, Group 2
and Group 4, etc. I have set this up as a regular relationship via the
fact table. However, when I pivot against the Group dimension, it only
picks up the first related entry of the group dimension, and ignores
all other enteries in the table. My question is how do I structure the
data and dimensions to work correctly for this type of relationship?

Machine Group
Profit/Loss Measure (MachineKey)

ProfitLossFactTable
-----------------------------
RecordKey MachineKey PLTotal
1 1 100.00

GroupTable
-----------------
RecordKey MachineKey GroupName
1 1 Group 1
2 1 Group 2
3 1 Group 4

I expect a pivot to show something like this:
Group 1 100.00
Group 2 100.00
Group 4 100.00

Thanks for looking at this.

Regards,
James

Hi James,

If you can use AS 2005, this MSDN paper should help you:

http://msdn.microsoft.com/library/de.../en-us/dnsql90
/html/sql2k5_mmdiminas.asp
Richard Tkachuk
Microsoft Corporation

June 2005

Applies to:

Microsoft SQL Server 2005 Analysis Services

Summary: See an example of using the Many-to-Many dimension in SQL
Server 2005 Analysis Services to analyze sales data, and get ideas for
other uses such as treating medical conditions, software testing, and
more.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***