I am looking for a way to create more than one Dynamic Time table so I can connect it to more than one date per dataset (ex: a date for each "begin" and "end" of a contract)
As I understand it, one date table can only connect to one date in the data model.
Trying to generate a second table in the ETL studio via "Period Table" leads to an error.
Ole Dyring Hi Thorsten,
In your scenario, you have a fact table with two different dates (Posting Date and Due Date in my example). You will need to relate these two dates to two different time dimension tables in your data model.
The two Period Tables are identical. It is correct that you will get problems with variable names etc. if you try to add two Period Table Tasks to your ETL project. However, since the two tables are identical, you can easily copy the first Period Table with an Import task:
I hope it makes sense.
BR / Ole
Thorsten Brochhaus That works. Thanks a lot!
Comments
2 comments