This content has been marked as final. Show 2 replies
Map those two tables to fact in BMM (Source properties->use Add button)
in this case that should work. Don not use distinct as in SQL.
This should work.
Do you have a 1to 1 relation between your table X and Y ?
If it is the case, you could :
- add a relation between your table X and an alias of table Y in the physical layer (if your table Y is used in another relation)
- add the alias of table Y directly in your source (dimension or fact) in BMM with an inner join between your 2 tables
After you can add a new column which is the concatenation of column A and column B.
Hope it helps,