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
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.