Handle two dates from two tables

[akpofureenughwu]

Hello everyone,

Here is my sample data sets

Expenditure Table

Date	Location	Expenditure Item	Expenditure Figure (Naira) PER	Expenditure Figure (Naira) YTD
01/12/2012	Lagos	CAPEX	1,184.69	1,184.69
01/12/2012	Lagos	OPEX	5,544.16	5,544.16

Cash Call

Date	Location	Partner	Equity	PER NGN	YTD NGN
01/12/2012	Lagos	John	80	-3,450.98	-3,450.98
01/12/2012	Lagos	Fred	20	-1,607.60	-1,607.60

The expenditure table shows the expenditure made on loca

In the above tables, to eliminate synthesis keys I used location and rename l date in cash call table to cashdate.

My questions are

1. Can I merge the two dates together while location is the primary key in this design?

[its_anandrjs]

You have to use Canonical Dates please read the thread of the HIC

Canonical Date

[effinty2112]

Hi Akpofure,

                         You can give your date fields different names and have two separate master calendars which is the simplest solution. However if you plan on charting Cash Calls and Expenditure together against a common date dimension then a canonical calendar is necessary.

Kind regards

Andrew

[akpofureenughwu]

Hello sir,

Can you explain this script below:

Orders:

LOAD *, 1 as OrderCounter INLINE [

OrderId, OrderDate, Quantity

1, 01/01/2012, 101

2, 01/01/2012, 102

3, 02/01/2012, 103

4, 03/01/2012, 104

5, 03/03/2012, 105

6, 03/04/2012, 106

]

;

I got it from this link : Linking to two or more dates