Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: HelloCognos on 13 Sep 2018 02:43:51 PM

Title: Relational - Crosstab with Columns from different Queries.
Post by: HelloCognos on 13 Sep 2018 02:43:51 PM
Hi,
I have a Crosstab but I need to have the data populated on the top edge from different Queries and not just main query.
Is there a trick to do this.

So First Column of the Crosstab comes from Query1 and the Second Column of the Crosstab comes from the second Query2.

Of course, the intersection from the Left Edge (Rows) is based on the same data items but the columns needs to come from
different Queries.

Thanks in advance for your time.
Title: Re: Relational - Crosstab with Columns from different Queries.
Post by: cognostechie on 13 Sep 2018 06:23:52 PM
Cognos allows you to join queries. 
Text only | Text with Images