This discussion is archived
3 Replies Latest reply: Jan 23, 2013 1:09 PM by 875076 RSS

limitation of complex join in physical layer

875076 Newbie
Currently Being Moderated
Hi All,

Is there a limitation on BMM modeling when we use complex join in physical layer. I have 1 Fact and 4 Dimension table having following relationship in physical table.


F-->D1-->D2-->D3-->D4

F.Col1=D1.Col1, D1.Col2=D2.Col2, D2.Col3=D3.Col3 and D3.Col4= case when D4.Col5 is null then D4.Col6 else D4.Col5 end)

I am using complex join for D3-D4. In the report I am getting the error [nQSError: 12002] Socket communication error at call=recv: (Number=10038) An operation was attempted on something that is not a socket

If I create the new calculated column CalCCol in D4 table in sql, containing the same logic (case when D4.Col5 is null then D4.Col6 else D4.Col5 end) and using this column for physical join D3-->D4 (D3.Col4=D4.CalcCol) in physical layer, the report works without any error.

Do we have to do modeling differently in bmm layer or just its a limitation with complex join in physical layer?

BMM layer



Fact table is joined with D1 dimension table which has four (D1,D2,D3,D4) Logical Table Source(LTS).

Thanks,

Virat

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points