Hi,
I have two tables where 3 columns in one table are joined to one column of the other.like
PrimInsu,
OrigInsu, joined to KeyInsu
CurrInsu,
now if I include any object from both tables all three joins are ‘and-ed’ and returns no data.How can I define these Objects so that I can get data regarding all types of insurances.
Without seeing your Universe and assuming the table with “keyinsu” is a dimension table you would want to create alias. 1 from prim, 1 for orig, and 1 for curr.
Yes KeyInsu is a dimension table,I have a similar situation for another 7 other columns,in other 2 fact tables (around 14 columns) so i was thinking of other ways then aliasing.