
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Set up Master Calendar with Different Date Fields
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
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Have a look here: Why You sometimes should Load a Master Table several times and here: Canonical Date.
- Marcus


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Have a look here: Why You sometimes should Load a Master Table several times and here: Canonical Date.
- Marcus


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Download Rob Wonderlich's cookbook recipe for Tutorial - Using Common Date Dimensions:

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Perfect. Thank you Marcus! I will try create different master calendar for each date.
Best,
Becky
