We are on Cognos 10.2
My goal is for a report to be able to run against either a SQL Server Database or an Oracle Database (btw, table structures are identical). There is a data field in the package which contains the name of the database that the report is being run against. Currently, that field is set up in Framework Manager using a SQL Server pass-thru SQL query. Of course, that query will not work when run against an Oracle database as it contains a specific to SQL Server function.
I want to, based on the connection (not the data source), have Framework Manager run one or the other query. I don't know if this is possible. First I can't find any parameter or means of obtaining the connection name and second, I don't know if one can conditionally run SQL statements within Framework Manager.
Has anyone been able to do this?
Thanks,
EJ