My companymakes application softwarewith Microsoft technologies, andwe useReporting Services components since SQL 2005. Part of our offerings include Report Model for customers to use with Report Designer and Report Builder.Some of our big customers use Cognos as their DW and analysis platform, and ask us if Cognos can connect to our Report Models as data source instead of the database tables or database views. Where can I find answers to these questions?Besides SSRS Report Designer and Report Builder, what other reporting tools or ETL tools can use Report Models as data sources?Thanks in advance.

Hi Rose, I have tried my best to search whether Report Model can be use as data source in Cognos, however there is no solution. I suspect that it could not be use directly. But you may try to create a customized application to use report model. Managing Report Models http://msdn.microsoft.com/en-us/library/ms159752.aspx Accessing the SOAP API http://msdn.microsoft.com/en-us/library/ms154052.aspx Hope this helps.Garsy Liang - MSFT

Try downloading Stonefield Query SDK version.