Search results for query: *

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...

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...

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...

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...

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

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...

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...