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

Powerplay Transformer

Started by Sridark, 28 Sep 2005 06:16:49 AM

Previous topic - Next topic

Sridark

Hi Team,

I have hands-of experience with impromptu.. I'm learning myself to work with Cognos Powerpaly Transformer. I did convert my RDBMS into access and inserted as a datasource in powerplay trans.
Say customer, country , products and sales as datasources. i successfully created even Dimensions and facts. when i try to generate categories im getting errors. I can understand there might be err while creating dimensions. but cant rectify it.

Tell me the steps to crate dimensions if we have multiple datasource and about unique key and how the join Will work while we have more datasources.

Thanks
Sridar K

CoginAustin

You need to place your unique key as the lowest level in the dimension and mark it unique. I would also mark it excluded since it probably doesn't make sense for reporting.