COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: CommandoCognos on 21 Mar 2014 09:43:41 AM

Title: Link Free-Hand SQL to Data Source Connection
Post by: CommandoCognos on 21 Mar 2014 09:43:41 AM
Hi,

is it possible to link a Free-Hand SQL Query to a Data Source Connection if there exists multiple Connections underneath one Data Source? As I can see it is possible to connect to to a Data Source but not a Data Source Connection. But I'm wondering if you can "pre-select" the prompt which comes up asking for the Data Source Connection. Is it possible to put the DB Schema in the SQL?

As far as I can see one option would be to create separate Data Sources, right?

Thanks a lot for you input and best regards,
Timm