Skip to Content
0
Former Member
Apr 12, 2010 at 02:24 PM

dimension merging issue

28 Views

I have to queries: (D for dimension, M for measure)

Q1 returns D1, D2, M1 (D1 is order line item)

Q2 returns D1, D3 (D3 is the order number)

Merge Q1 with Q2 on D1 and try to display (D3, M1), we get M1 as the sum of everything. Any ideas? Thanks.