Self Join

[Bonediggler]

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!

[cognostechie]

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.

[Bonediggler]

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.

[cognos810]

Hello Bonediggler,
You can create a separate query in report studio and join it to the existing query.

-Cognos810