Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I need to use a shared Time Calendar that can join two separate tables on the DateID, without causing a loop.
I have the following Scenario:
I need the OrderCalandar to be join to both sales related tables (That in turn connect to the EmployeesTable)
This is neccesary so i can placea date filter on the page, and if a User choses all sales in May, they will be able to see all Sales and All RMA's that have happened in May
Like this:
You can filter on May - and theoretically - data for both datasets will come through
Any one able to help me on this please
Best option is to create a link table since you have two separate fact tables with shared dimensions:
Check this out: