Relationship between Date dimension table and other fact tables

[Barath]

Hi,

I have a problem when joining my Calendar Dimensions table with the fact tables(Enquiries & Pipelines , Job Orders),

The relationships I created between calendar table and other two fact table are as below,

The problem I have is when I use my Calendar Dimensions - Date in matrix to find out the potential value from Enquiries & Pipeline table, it is just blank,

But when I use the date field(Created) from Enquiries&Pipeline table to generate the potential value, it does generates the proper values.

I have been stuck with this issue for about a day. Can anyone please help on this asap because this is delaying other things in my organisation. Many thanks people

Cheers

[Phil_Seamark · Accepted solution]

Hi @Barath,

A couple of thinks to check.  Make sure the datatype for all the columns used in this scenario are the same.  I suggest using DATE rather than DATETIME, and specify this in the Query Editor,

Then simply check that you have all the values in your calendar table that match your fact data.

[Barath]

It worked. Thanks Phil:)