Transformer 8.3 Cognos Report Datasource

Hello,
I'm trying to use this brand new functionality of using a Cognos 8 Report as a datasource (instead of an iqd) for a cube and having some issues.
When I try to import the Cognos Report I get a variety of errors.. anything from an Exclamation Point dialog box with no error text to parsing errors even if the report validates successfully in Report Studio.
Has anyone been able to make use of this functionality as yet?

Popular White Paper On This Topic

Hi there,
I have the same problem as you that I import a report as datasource (simple or complex it doesn't matter) and transformer only shows and Exclamation Point dialog box without the error text.
I hope you have the solution to let this work. Or maybe that someone else can help me out with it.
With kind regards,
Marc

I have used this functionality and not had a problem, however I think that like with IQD you need to have a simple 'list' report as the data source.
From what I can see all transformer does is extract the SQL from the report, so if you have a complex report which uses multiple queries to generate the output then transformer wil probbaly fail as it seems to take the source of the 'first' query in the report.

Hi Terence,
I have test it with the most simple list report that I can build, but still the problem. It only happends with reports. Packages, IQD's, XML or whatsoever works perfectly.
I have contacted Cognos now, and they think I found a bug in the version that I use Transformer 8.3.818.0. It's still under investigation by them.

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.