Calendar for 3 Tables with Three Dates

microwin88x — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have the following tables:

The thing is I need to create a Master Calendar to handle the following dates from the 3 tables.

- CUSTOMERS: CREATE_DATE

- TRANSACTIONS: TRANS_DATE

- AIRLINE_MILES: MILES_DATE

So that if I filter one Date (Year/Month/Day) I'd like to know:

- How many Customers were created on that period of time.

- How many Transactions were made and which amount.

- How many Miles where exchanged on that date.

Do you know how could I create the Data Model so that I could handle dates from all tables at a time?

Thanks!

Re: Calendar for 3 Tables with Three Dates

Anonymous — Tue, 04 Apr 2017 04:03:41 GMT

How about this??

In your calendar,

Load Date,

Date as CREATE_DATE,

Date as TRANS_DATE,

Date as MILES_DATE,

........

.......

....

From your master calender.

jonathandienst — Tue, 04 Apr 2017 05:46:35 GMT

You have two options:

These may also help