I have 2 iqds in my transformer model..
One is Time Dimension (Dimension Table)
Which includes a surrogate key called Time ID (e.g., 1,2,3)
…and ToDate (e.g., 20070101, 20070201) as its summarized at monthly level
The Second is Project (Fact Table)
Which includes a surrogate key called Time ID (e.g., 1,2,3)
Several attributes such as Project
And various measures such as Resource Amount)
When I run DATE WIZARD with ToDate as source I get the ONE value repeated across months and years eg
Jun July
567990 567990
Does anyone know what Im doing wrong and can surrogate keys even be used/referenced when using DATE WIZARD?
Cheers,
Steve