Why some iterations don't have the attribute Timeline in RRDI?
We are making a report where we use the timeline as a filter. Thing is that we have only 5 different timelines when we should have way more. We checked the data and saw that is the iteration that miss most of this information.
We checked in ODS>Iteration Area>Iteration>Timeline Name and brings only a few.
If we check ODS>Iteration Area>Timeline>Name it looks that is bringing the timelines.
We are missing most of the iteration's timeline info
Accepted answer
ODS>Iteration Area>Timeline is Timeline table loaded with all the timelines.
ODS>Iteration Area>Iteration is Iteration table loaded with all the iterations, and related timeline as a foreign key, so it only shows the timeline that this iteration belongs to.
If ODS>Iteration Area>Iteration>Timeline Name is empty, that must be something wrong with the ETL loading incorrect data.
Suggest to run a full load in data collection jobs to see whether it will fix the problem.
ODS>Iteration Area>Iteration is Iteration table loaded with all the iterations, and related timeline as a foreign key, so it only shows the timeline that this iteration belongs to.
If ODS>Iteration Area>Iteration>Timeline Name is empty, that must be something wrong with the ETL loading incorrect data.
Suggest to run a full load in data collection jobs to see whether it will fix the problem.
i