Search results for query: *

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

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

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

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

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

Hello, It might be a simple question, but I could not find any solution for this. We have several Cognos Script Macros (that run Impromptu Reports). As soon as you run such a Macro (.MAC) it saves automatically the compiled .MCX file in the same folder. Is there any way (either in Impromptu...

Hello, I tried in several ways to create a report field that should just show "" (double quotes) in the final csv/xls output but I was never able to get this working. Either nothing (blank) was shown in the output or I had """"" or """""""" in the output. Does anybody know what I need to...

Hi, Hope anybody here can help me. The Firm I am working in bought a few months ago "BusinessObjects Edge Standard XI 31" application. But as far as I understood till now the application has some limitations which are for us a requirement to have. Those are Scheduler: - Scheduling on...

Hi, I have a macro in place (Name: Macro1.mac) which runs several reports and saves them on the correct paths on the server. I have a second macro (Name: Macro2.mac) which copies afterwards those reports to many different folders. How can I call from “Macro1.mac” that it should start...

Hi, I have an issue with updating my folders in my impromptu catalog. When I started to use Imprompotu, I created 10 folders based on 10 different database tables. But in the meantime, I did some amendments on the tables and some new columns were added to the different database tables. The...

Hi, Does anyone know how to write just one line (like: "This is the line which should be entered to the file")to a file, so that the final file looks like: This is the line which should be entered to the file (The important thing is that the line in the file should not be surrounded by...

Hi, I am using Cognos Version 7.4.2025.0. Till now I just used it together with catalogs to connect against the database. Can somebody please let me know how I can directly write an SQL Query and run it against the database (without using a catalog)? I cannot find an option like this in...

Hi, I have an issue with the Cognos script language (Version 7.4.2025.0). The issue I have is that I have 2 .csv files saved in a folder which I want to copy with the help of Cognos script language automatically to one final .csv file. All my tests failed till now. The last code I tried was the...

Hi, I have a Problem with the Impromptu Scheduler. It runs several Reports at different times. After a Report has run, It will be list up on the "Completed" site of the scheduler. The problem is that some reports have really run and for some nothing happens. But on the completed site there is...