Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Bonediggler on 04 Nov 2014 09:02:41 AM

Title: Self Join
Post by: Bonediggler on 04 Nov 2014 09:02:41 AM
Experts -

Is it possible to create a self-join with one query item?

I tried this but am getting an error which indicates it is not.


Thanks for the help!
Title: Re: Self Join
Post by: cognostechie on 04 Nov 2014 10:55:15 AM
What is meant by a self join? Are you trying to join the query subject to itself? If so, FM allows creating 'alias shortcuts' which are aliases of the same query subject but can be used to join.
Title: Re: Self Join
Post by: Bonediggler on 04 Nov 2014 11:01:03 AM
Thank you Cognostechie

Yes - a query subject joined to itself.  I am working in Report Studio only and do not have access to FM.  Any workarounds?

I tried looking for an alias option in the query subject properties but didn't find any.
Title: Re: Self Join
Post by: CognosAnalytics on 04 Nov 2014 06:36:01 PM
Hello Bonediggler,
You can create a separate query in report studio and join it to the existing query.

-Cognos810
Text only | Text with Images