How to create Cube from Power play transformer by using SQL Server Database(with out creating IQD file using Cognos Impromptu from SQL Server)

  • Interview Candidate
  • 2
  • 6019

Showing Answers 1 - 2 of 2 Answers

the_xxx

  • Oct 16th, 2007
 

Power Play transformer supports wide range of Local Data Sources, you cannot connect to SQL Server Directly without creating IQD's.  Below is he list of data sources which you can use as Data Sources.

• Impromptu query definition files (.iqd), which can query local or server-based databases• delimited ASCII files (.asc) and comma-separated variable files (.csv)• fixed-field text files• local databases, including Microsoft Access, which can specify SQL queries against local orserver-based databases, Clipper, dBase, FoxPro, and Paradox• PowerHouse portable subfiles• Spreadsheet crosstabs and databases, including Excel and Lotus 1-2-3

  Was this answer useful?  Yes

nilesh_tiwari

  • May 28th, 2009
 

From the 8.3 version of Cognos you can use even a more wider variety of datasources than you could use previuosly

You can just publish a package from Framework manager and use it as a source for creating cubes, no need of creating an IQD

You can also use any Cognos 8 Report as a source.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions