COGNOiSe.com - The IBM Cognos Community

Hi ,

Can anyone help me in this regard.

I have two tables.

1st table - all the values are in columns ( Parent Table )
2nd table -  all the values are in rows ( Child Table) ie Attributes are in rows.

I would like to to know how the relationship and query subject can be created.

Thanks

I don't think you can solve this problem with a simple relationship.  You need to pivot the values in parent table from columns to rows in your data layer.

http://msdn.microsoft.com/en-us/library/ms177410(v=sql.105).aspx
http://www.oracle-base.com/articles/11g/pivot-and-unpivot-operators-11gr1.php

Thanks John!

I wonder if the pivot works..because all the values are in rows ( Child Table) ie Attributes are in rows.

In your case, you need to use UNPIVOT on the parent table to move the values from columns to rows.

Thank you John :)