Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mhurkmans

  1. mhurkmans

    How can I get a result from a second table

    Thanks, I have a good start now. I searched in the red book from IBM and found the correct statement. Indeed it was an outer join (I thought too difficult) select b.workcenter,a.date from B left outer join A on B.workcenter=A.workcenter and date between 20100124 and...
  2. mhurkmans

    How can I get a result from a second table

    Thanks for your quick responce, But it is not that easy. Maybe I need to be more specific i.e.: Table A: 20091204, 9 20091215, 9 20091215, 10 20100105, 10 20091227, 11 20100124, 11 20100127, 12 20100131, 13 20100205, 14 and table B. Workcenter 9 10 11 12 13 14 The problem is when you...
  3. mhurkmans

    How can I get a result from a second table

    Dear, Maybe someone can help me with this one: I have one table i.e. A. A is populated with next records. Date, Workcenter 20091204, 9 20100105, 10 20100124, 11 20100127, 12 20100131, 13 20100205, 14 and table B. Workcenter 9 10 11 12 13 14 I want to select a date range between 20100124...
  4. mhurkmans

    Migrating Impromptu 7.4 reports and catalogs to Cognos 8.4

    Dear, I have problems with migrating Impromptu reports from Version 7.4 to Cognos 8.4. The first to steps went succesfully but the last step is little bitt difficult. The first two step were "impcat2xml" and "migratetoc8". The command "migratetoc8" created a foldername...
  5. mhurkmans

    How do I install the Cognos 8.4 samples on a SQL2008 database

    Dear, I have installed Cognos 8.4 with MS SQL2008. This is working fine but I want to install the sample files GOSALESDW and GOSALES on the MS SQL2008 server. Please can give someone me advise how to install the sample content on a MS SQL2008 database? Thanks in advance, Mario
  6. mhurkmans

    Content Manager is unable to access the content store.

    Thanks Ties for your reply. I found the solution. What I did was I removed the Cognos installation complete (otherwise it repeats with messages of old content stores and namespaces). I removed the content store database on the SQL 2008 server. I create a clean content store on the SQL 2008...
  7. mhurkmans

    Content Manager is unable to access the content store.

    Dear, I have the next configuration: Windows 2008 server - MS SQL 2008 - Cognos 8.4.27 I created a database (content store)in MS SQL 2008 and als a Schema. In Cognos 8.4 I configured the user sa/password in the content store and als the corresponding port address (thx Haripali). In Cognos...
See more

Part and Inventory Search

Back
Top