Topic
  • 3 replies
  • Latest Post - ‏2012-11-19T20:22:24Z by SystemAdmin
SystemAdmin
SystemAdmin
15496 Posts

Pinned topic Cognos 7.3 Query

‏2012-11-16T22:00:50Z |
Hi all,

I am Brand new to Cognos and i have never worked on it. I am Migrating Cognos 7.3 reports into Microsoft Reporting tool so all my work is from scratch..

I have few reports that needs to be migrated from Cognos 7.3 to SSRS 2008. I know there are not any tools for this so i am trying to get started from scratch. I dont have anyone at work to direct in the right path however i was wondering if anyone knows where i should get started.

In SImple terms I would need a Datasource which i have, I need help with Dataset.. Is there a way i could retrieve query from Cognos Impromtu and re build it in SSRS... anyone whos familiar with this? Where can i find information on each field in COGNOS...
From http://pcnorb.blogspot.com/2010/02/allscripts-tiger-to-ms-sql-to-godaddy.html
After running a report, go to the Report pull-down menu item, and select Query.

In this window, select the Profile tab, and the SQL option. This will reveal the SQL query used to retrieve your data

When i did that I dont see the Profile TAB All i see in the query .. Data, Sort, Group , Filter Tabs..

Please help?
Updated on 2012-11-19T20:22:24Z at 2012-11-19T20:22:24Z by SystemAdmin
  • yangling
    yangling
    268 Posts

    Re: Cognos 7.3 Query

    ‏2012-11-19T18:51:07Z  
    Re: Is there a way i could retrieve query from Cognos Impromptu and re build it in SSRS?

    Open each of your Cognos Impromptu reports and go to Report | Query | Profle |SQL

    then copy this SQL code into your SSRS would perhaps save you a lot of work...

    See the attached image.
  • yangling
    yangling
    268 Posts

    Re: Cognos 7.3 Query

    ‏2012-11-19T18:55:09Z  
    First of all, ensure you are on Cognos Impromptu Administrator version.
  • SystemAdmin
    SystemAdmin
    15496 Posts

    Re: Cognos 7.3 Query

    ‏2012-11-19T20:22:24Z  
    • yangling
    • ‏2012-11-19T18:51:07Z
    Re: Is there a way i could retrieve query from Cognos Impromptu and re build it in SSRS?

    Open each of your Cognos Impromptu reports and go to Report | Query | Profle |SQL

    then copy this SQL code into your SSRS would perhaps save you a lot of work...

    See the attached image.
    Thank you Vangling, When i followed your steps the Profile tab as missing but I was able to follow the steps in the below link and was able to retrieve the query. Thank you

    http://www-01.ibm.com/support/docview.wss?uid=swg21351034