COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: otsizh on 16 Sep 2005 07:18:24 AM

Title: tabular set
Post by: otsizh on 16 Sep 2005 07:18:24 AM
How to use tabular set? where can I find more information about tabular set?

thanks, olha
Title: Re: tabular set
Post by: sir_jeroen on 16 Sep 2005 07:27:42 AM
Tabular set:
A relational set expression that combines two or more tabular structures. To specify a relational set expression using SQL, use the tabular SQL object instead.

A tabular set can be used in order to join queries together where there's no relation between them. You can use it in order to join (union) 2 result sets or to find corresponding rows between 2 result sets (intersect) or to find non-matching rows in 2 result sets.

That's all