Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone
I am building a model and struggling with linking the dates data to my fact table.
I have used Year(DateField)*100+ Month(DateField) to join my calendar and fact tables but the data doesn't seem to have a relationship.
Please assist. I have attached my app and data files
You have concatenated the facts with Customers and with Items. I have loaded these in three different tables. Also, you had too many keys, so I have removed the redundant ones. Finally, I changed the definition of YearMonth.
See attachment.
HIC
Set you YearMonth as
MakeDate(Year(FIN_YEAR_ID),Month(FIN_YEAR_ID),Day(FIN_YEAR_ID))
Do the same with other data from other tables so that the date format on all date values is the same (MM/DD/YYYY without Hours and Minutes -- if that is your requirement)
You define your key incorrectly...
You should probably use
FIN_YEAR_ID*100+Month(FIN_YEAR_ID) as YearMonth,
instead of
Year(FIN_YEAR_ID)*100+Month(FIN_YEAR_ID) as YearMonth,
Hi Henric
I have changed the field expression as per your suggestion and the data still doesn't link.
Can you perhaps upload the app if you can get it right on your side?
You have concatenated the facts with Customers and with Items. I have loaded these in three different tables. Also, you had too many keys, so I have removed the redundant ones. Finally, I changed the definition of YearMonth.
See attachment.
HIC