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

Help on relationship

Started by vivek_cyno, 28 Jul 2012 08:25:23 PM

Previous topic - Next topic

vivek_cyno

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

tjohnson3050

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

vivek_cyno

Thanks John!

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

tjohnson3050

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

vivek_cyno