If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Transformer: Date Wizard and Surrogate Keys

Started by sleepy, 10 Jul 2007 07:26:54 PM

Previous topic - Next topic

sleepy

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