This content has been marked as final. Show 5 replies
try to add other 2 tables to main table LTS and select left outer join.
Create the below joins in Physical layer
y_abc ->Z_abc b
In BMM layer create logica table with source y_abc and then General properties-> Add
other 2 tables and set out join for relation y_abc ->x_abc
once you done this pull/add required columns from Physical layer
If helps pls mark
x_abc is already there in BMM layer joined with fact table . If i created a new logical table with source y_abc and adding x_abc by providing outer join here, do i need to add z_abc here?
2) one more thing is that y_abc(new logical table) ,x_abc are in BMM now. do i need to maintain a join in bmm for these tables.
Can you please guide me on this
I'm not sure what is there in your BMM. I'm just telling how it suppose to be.
What ever you do make sure that on logical table source 'y_abc' general properties you should see other tables added with 1 inner join and other is with outer join.
hope this helps
Create a Opaque view in Physical layer. Where you can write your own Sql Query.