Recent content by galaxy0815

Hi drlex, I copied the impromptu.ini file from a machine where it it working to one where it is not working. Normally I would expect that the other machine has the same settings after the file copy was done. But still the same issue. The imr file looks different on both test PCs. Any other...

Hi, I have a strange issue with Cognos Impromptu 7.4.4 that I never faced before. What I have done: I have created an SQL Query(not via Catalog drag&drop, but via hardcoded SQL) and placed this query into an IMR file. Finally I formatted all columns in the way I wanted and saved the file...

Thanks!

Hi, Can you please let me know if there is an easier way of calculation from todays date the 12.th of last month as this one here: date(trim(Char(YEAR(CURRENT DATE - 1 MONTH)))||'-'|| trim(Char(MONTH(CURRENT DATE - 1 MONTH)))||'-12') Looks so complex for this simple task. Thanks

@MarcLodge, Your point is correct, but this issue just occured when I copied the statement here. Seems that it was missed when I did copy and paste. But the statement I try to execute (which contains the AND) still fails with above error message which I do not understand. Can anyone please...

Hello, Sorry to come back on this again, but I have an additional issue: I tried to write the above mentioned query here: SELECT t1.Clientnr, t1.Country as Old_Country, t2.Country as NEW_Country, t1.Stopdate as Changedate from ClientAddress t1, ClientAddress t2 where t1.Clientnr =...

This works perfectly! Thanks very much!

Hello, I have an issue with a query I need to create. The following in my Basic table with the name ClientAddress: Clientnr----------AddressLine---------Country---------Stopdate 47-----------------Mainstrett3---------GERMANY---------30.Nov.2010...

Hi, Still trying on my side, but maybe try with one of the below: SELECT replace(replace(XMLSERIALIZE(CONTENT xmlagg(xmlelement(Name a, CAR)) AS VARCHAR(32599)),'<A>',''),'</A>','; ') FROM car_availablility or SELECT replace(replace(xml2clob(xmlagg(xmlelement(NAME a...

Hello, Please be advised that I have a complex SQL Statement that joins various tables. Within this statement I want to do the following (not sure if this is possible): As 3rd field in the select part of that complex SQL statement, I want to enter a subselect that runs over a table called...

Sorry for this. I was not aware that this "truncation" of the Sql would have such an impact as I thought it would be enough to post just the part were I have the issue with. The next time I face such an issue I will post the full SQL statement. Thanks!

Hello, Please be advised that I tried to simplify the SQL a bit (so showed pseudocode). Therefore I just wrote select * from. The important part was the integration of the select max().. into my multiple joins. And this is the solution (again just showing the join part): ... LEFT JOIN...

Hi, here is the query without pseudocode and I tried to format it manually a bit better. Select Employeegroup.* FROM ( ( ( SRS.Employeegroup AS Employeegroup INNER JOIN SRS.Employeedetail AS Employeedetail ON Employeegroup.ID = Employeedetail.ID and Employeedetail.ENTITYTYPE='01'...

Hello, I searched already through the web and the forum but could not find a solution for my issue. The issue is I have a query with several left and inner joins and I want to limit one of the joins with a subselect. But obviously this is not working. Here is the pseydocode of my query: select...

Hello, Quick question on Cognos installation. We received new PCs in our Offices (better hardware, same OS (Windows XP SP3)) and since that we have the following issue: When we run Cognos Scripts (they run reports, create folders and save the files in there) we always get the following error...