Hello
I have a Primary DB that have all the sales, brands, product category etc..
I build a report that show me the sales L3Y by region, and brand. But there are customers that haven't bought anything but they are in the DB.( A secondary DB)
I want that report show me all the customers.
Attached there are the examples
Thank you very much
RFM
Hi Ricardo -
You're looking for the equivalent of a RIGHT JOIN (Primary = Left, Secondary = Right), and unfortunately Blending doesn't support this.
If you make your Secondary DB your Primary, you'll be able to see all customers, at the cost of losing the use of your dimensions from the database that is now Secondary -- this won't work either.
Is there any chance you can actually do the join at the level of the data itself? For example, if this was SQL Server and two databases live on the same (or different) servers, you could do something like this:
Select PrimaryTable.*, SecondaryTable.*
FROM
PrimaryTable RIGHT JOIN SQLServerName.SecondaryDatabaseName.dbo.SecondaryTable SecondaryTable
ON PrimaryTable.Customer = SecondaryTable.Customer
Hi Russel
Sorry for this late thanks, but I didn´t see your post.
I will try with the help of some friends and let you know something.
Thank you once again
RFM