Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have two tabs in a QVW file. Each tab has one date field associate with it. For example, "Order Date" associate with "Order" table, "Receipt Date" associate with "Receipt" table.
Both date fields are very important and is the key to set up with master calendar. I know that a master calendar must be associate with a date field. However, if I set up my master calendar with "Order Date", the date range in my "Receipt" table won't be correct. So I will need to set up a master calendar with more than one date fields. Or is there a way to set up two master calendar with two different dates within the same QVW file?
Thank you for your help in advance!
Becky
Have a look here: Why You sometimes should Load a Master Table several times and here: Canonical Date.
- Marcus
Have a look here: Why You sometimes should Load a Master Table several times and here: Canonical Date.
- Marcus
Download Rob Wonderlich's cookbook recipe for Tutorial - Using Common Date Dimensions:
Perfect. Thank you Marcus! I will try create different master calendar for each date.
Best,
Becky