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

 

How do create relations between fact and dimensions in Transformer model

Started by srikanth.kamatala, 08 Apr 2009 12:49:32 PM

Previous topic - Next topic

srikanth.kamatala

Hi,

I have aframework manager with Resource dim,project dim,task dim,invoice dim and one fact table in the relational layer.The relations are defined in the import layer.
I created 5 iqd's one for each of them and published the package.
Then i impoted the iqd's into the transformer model and clicked on modify columns and evrything were matching.
Then i dragged the dimensions as single level and measures into the Measure section.
But when i click on the check model it shows that there are no relations betwenn the fact and dimesnions.

Can someone please help me how to create relations in the transformer model.

Regards,
Srikanth.K

timkline

Your data source column names need to be the same and the type the same.  Within, your measures data source you need to have column names and types that match the corresponding data source names and types for your dimensions.