Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2008
    Posts
    4

    Unanswered: Cognos Impromptu-Catalog Creation

    Hi

    I want to use Cognos Impromptu.
    I have query about creating Catalogs in impromptu.

    Is it possible to create Database in impromptu using two databases from MS SQL
    database.
    For example I want to create database in Impromptu with master and msdb fro MSSQL so I can create report with data from master and msdb tables.

    I want to create report from two tables of mssql which are in differennt database schema of MSSQL.

    is it possibel to achieve this?how can I create such a catalog?

    Regards.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    could you explain in clear language what you want to achieve
    this kind of explanation, nobody will understand
    please specify what is needed in db2 from ???
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Jun 2008
    Posts
    4
    HI

    Basically I want to have a report wherein I have to get fields from two database tables Table1 and Table2.For example,
    Table1 is from database NorthWind.(NorthWind.Table1)
    Table2 is from database MSdb (MsDB.Table2)

    I want to create database in Cognos Impromptu with connection to NorthWind and MSDb.

    Is it possible to achieve??

    In turn while I am creating Catalog I will be able to add and use both (NorthWind.Table1) ans (MsDB.Table2).

    I actually want to have report spanning like Cross Database schema in MSSQL
    from Cognos impromptu.

    DOEs Impromptu support such things?Is it possible to achieve?

    Regards.

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    this is a db2 forum and nothing todo with mssql...
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  5. #5
    Join Date
    Jun 2008
    Posts
    4
    HI

    Could you plz tell where can i put questions related to Cognos?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •