Dates in multiple Fact tables

[Anonymous]

Hi All

I have few different dates coming from different fact tables in my Data model and I am trying to link those dates with the Master calendar.

Can anyone please give the solution on linking those dates.

[bhaskar_sm]

please share sample data from all the fact tables

[Anonymous]

You just need the dates right?

[bhaskar_sm]

okay- but i need from your row qvds

[Anonymous]

!!

[Anonymous]

Hope you got the attached Qvf?

[bhaskar_sm]

yes

[bhaskar_sm]

Hi,

Please find attached the  QVF for your reference.

please not that you have few invalid date that you need remove from your transaction date.

Regards,

Bhasker

[Anonymous]

Hi Bhasker

Thank you for the solution!

But now I am facing another challenge on selecting Invoice in Date Flag and it is giving me zero Outstanding amount as it is not getting linked with my Outstanding fact table.

Any suggestions?

[bhaskar_sm]

Hi,

i will recommend to check the fact table date and the format and if you found everything is okay then try to look into key combination which may require in this case- please look into Canonical Date even you couldn't able to resolve then please share the sample application with data and existing code.

Regards,

Bhasker Kumar  

[Anonymous]

Hi Bhasker

Due to security reasons I can't share the data. I am able to link all the dates with master calendar now but on making selections my data is coming wrong. For instance, I checked on the Invoice Year -  2014 with 'Invoice' Date Flag so the Outstanding value is coming wrong against it.

Can you please help in finding out the error?