Hi,
We have business analysts who create queries using the cognos web app to find clients of our business who they want to target for marketing purposes. they can export the data via csv and we can feed that into the automated system we're building for them but we expect the size of this data to be in the gigabytes and would like to be able to use the sdk to get at the query definitions of the queries they save in cognos so that we can execute the queries and import the data directly using federation in db2.
We can see from the documentation that a query object contains a reportVersion object which contains an SQL object which it says is the sql generated by the definition of the query.
Does anybody know how to get at this information using the SDK because the properties of the query object don't seem to provide access to the reportVersion object and the reportVersion object doesn't seem to provide access to the SQL object.
Regards,
Luke
