I have sales and Inventory tables.
I have concatenated both the fact tables and It is perfectly fine but the only thing is when i link Customer Dim table to fact table then I am getting Measure(Inventory) whcih shd be zero.
Can you help me out how I can proceed in resolving this Issue?
we need to have some more details about your Data Model.
so can you attached sample file with your existing Data Model
concatenate two tables
but add flags in both the tables to get correct result in front end
0 as Flag
from sql ;
1 as flag
I did that but My question is how to connect Customer Table to only sales fact table and not with the Inventory.
I just removed the Null values were creating the problem.
Thanks for your help.
Retrieving data ...