Hi there!
I'm stuck on an issue:
i have the ff. tables:
Date dim table
Products dim table
POS Orders Fact table
Purchase Orders Fact table
Requirements:
Create a report that shows:
Product purchased from supplier per year showing PO no., Order Reference, Date, Quantity and Total.
Product sold per month and per location per year showing Total
Dim Tables:
Date
Product
Fact Tables:
POS Orders (Merged POS Header and Details Table)
Purchase Orders (Merged Purchase Order and Details Table)
Model/Relationships:
Purchase Orders -> Date table (Many to one)
POS Order -> Date table (Many to One)
POS Order -> Products (many to many)
Purchase order -> Products (many to many)
Visuals:
Added slicer for year (from Date table)
Added text search (to search by vendor or product)
Matrix to show products from a vendor
Matrix to show Products sold per month for a year per value from year slicer
Matrix to show Products sold per location for a year per value from year slicer
Expected Results:
Should show products sold from a vendor, purchases, sales per location and per month per year
Issues Encountered:
When year is selected from slicer and vendor name is filled in,
sales per month and per location are not showing correctly. Nos. are not filtered by year.
Am I missing something here? Is the relationship done correctly?
Also, is there a search slicer that searches both text and numbers that you can recommend?
This is to be able search for product no. on the search slicer.
Any inputs are greatly appreciated.
Thanks in advance!
