Print Page - Analytics Report Ad-Hoc SQL Configuration

Title: Analytics Report Ad-Hoc SQL Configuration
Post by: gab400 on 16 Sep 2019 10:42:16 AM

I knew how to do this in 10 and don't quite see it in 11. I am creating a new report using the SQL object to use custom sql for a report. In 10 you could set the db connector in the properties. How do you do this in 11?

When i Validate I get the error "RQP-DEF-0500 No database name is specified for the SQL query of 'native' type"

Title: Re: Analytics Report Ad-Hoc SQL Configuration
Post by: Francis aka khayman on 16 Sep 2019 02:18:07 PM

select the SQL, open properties. Under "Data" is the Data source property

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: gab400 on 16 Sep 2019 10:42:16 AM