Hello There,
Could anyone help me understand where am I doing mistake in achieving following task:
I tried to get Reseller-Name wise sales figure in AdventureWorksDW2019;
where
1. ResellerName a column in 'DimReseller' dimension table
2. Total_ResllerSales is the sum(SalesAmount) from FactResellerSales table
3. there is a one-to-many relation from dimension table to fact table over the column "ResellerKey". The figures indicate that the fact-table data were not being filtered based on the column 'ResellerName'.
I tried the similar approach between the tables 'DimProductCategory' and 'FactInternetSales' which is working; all these observations could be understood from the visuals -copy I attached to this email. Could anyone help me understand where is that I am missing the logic?
Thank you for giving your valuable time.
------------------------------
ArunaRamana Program
student
------------------------------