Recent content by ict2000

The problem could be caused by Cognos 8 optimisation to remove unused items from the query. To fix, try the following: 1. select the List object in the Properties pane 2. In the Data section, click ... next to Properties 3. Click the query item A then click ok The problem should be fixed then...

Assume you are using Cognos 8. To reference a prompt, you need to put ? before and after the prompt name. So if your prompt is called for example param_option, then it will look like this: ?param_option?.

Check if your email address is set correctly in your login account used for authentication (check with your network admin if you use AD for example). Otherwise Cognos will use the default email address. Also make sure you are the owner of the Event Studio agent.

Try the following option: 1. First create the following query item (say Filter1): CASE WHEN (?Option? = 'Short Term' AND Payment Date between today & nextyear same day) THEN (1) WHEN (?Option? = 'Long Term' AND Payment Date greater than nextyear same day) THEN (1) WHEN (?Option? = 'Both'...

You need to look at the Mid Function/Statement in the documentation "Macros and the CognosScript Language" to remove the quotation mark from the line before writing it to a file.

One option is: using UDF (User-Defined Function). Check out this document "How To Create User-Defined Functions". First you need to create a function in your database to return the number of weekdays only. Then follow the instructions in the above document to make the database function visible...

Try to add a second filter with the "maximum ... for" function like the following: transaction_date = maximum(transaction_date) for employee_number This should work in both Impromptu and Report Studio.

Have you tried to modify the query item that is used as the crosstab measure? Change it to something like: Case when (row = 'Z' and col = 'B') then your calculation expression else normal End

You might want to try this option: Use 2 lists, instead of 1, and create the total line manually. The first list uses a new query with the filter to remove the "All" and the second list uses the existing query just to return the total line. Make sure you remove un-used query items from the query...

The Excel output file is saved with MHT extension, instead of XLS. Thus you need to add a section in the script to rename the extension to XLS. The sample section below is written in VBScript where strFileExt will be later used to rename the output file. If UCase(strFileExt) = "MHT" Then...

Hi Vinod, If saving report outputs in a file system (instead of in Content Store) is an option you are looking for, then it is possible to save all scheduled reports in the naming convention you mention (reportname_date). First you need to set the option "Save report outputs..." to True in...

If you use Cognos 8, and have access to Cognos KB, try to search for HTML and Javascript keywords. There are many documents telling you how to set default values for many prompt types. You need to know a bit of JavaScript to customize the sample script to fit your report.

After speaking with my ISP regarding the IP address, I have configured my modem to use NAT. This also changes the lease time from 1 minute to 3 days. Thus the disconnection problem goes away. Thanks a lot for all your help.

Hi Bob, I currently have the following problem. Please see "Citrix Secure Access VPN keeps disconnecting on DSL" in this forum. I wonder if you can tell me how I can do similar thing to "uncheck 'Use default gateway on Remote Network' on VPN connection" in Citrix Secure Access. Thanks.

That is not my modem model. Before I try a router to give my pc a fixed IP, do you think if my ISP could increase the interval from 1 minute to 1 or 2 hours, or more, that will temporarily fix the problem? But why are all traffic forced onto VPN? Is there something locally I can check?