Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Business Insight Advanced / Cognos Workspace Advanced => Topic started by: gosoccer on 28 Oct 2016 05:49:13 AM

Title: Workspace Advanced and Reviewing the Join and Other Objects Involved
Post by: gosoccer on 28 Oct 2016 05:49:13 AM
Hi,
Does anyone know how to review a Join that was executed as a part of Workspace Advanced. In the other word,
we are trying to find out if there is a way to see what tables and joins are involved, or even Subject Queries within
the Workspace Advanced to see what is it doing? and then go after Framework Model if necessary?

Thanks in advance for your time. :) :)
Title: Re: Workspace Advanced and Reviewing the Join and Other Objects Involved
Post by: stan.parker on 28 Oct 2016 02:50:17 PM
Open the CWA report in Report Studio and choose Tools -> Show Generated SQL


Title: Re: Workspace Advanced and Reviewing the Join and Other Objects Involved
Post by: gosoccer on 28 Oct 2016 02:55:26 PM
Ahh! that's a good idea! Why didn't I think of that?  :o :oI'm just a gooffy! Thx a lot!
Text only | Text with Images