Monday, September 22, 2008

Cognos 8.3 - Steps for Comma delimited file addition into Cognos Environment

The default format of the CSV is tab delimited.

The steps involved in adding it to the Cognos Connection is as follows:

1. Go to Cognos Connection.
2. In the upper-right corner, click Launch, Cognos Administration.
3. On the Status tab, click System.
4. From the System drop-down menu, click Set properties.
5. Click the Settings tab.
6. Next to Environment, Advanced Settings, click Edit.
7. Enter parameters and values from "CSV Properties and Values", as required.
ie.
RSVP.CSV.DELIMITER: ,
RSVP.CSV.ENCODING: windows-1252
8. Click OK.

Note:
It takes about 30 seconds after this change for the changes to take effect.
COOL!!! Right 

Tuesday, September 16, 2008

Framework Required Filter in Cognos 8.3 RSV-SRV-0042

One thing I have been observing is that, in 8.2 when we have required filters to access the metadata we would again filter the same filter in a logic manner with the ‘Usage’ set to ‘Optional’. So basically what is happening here is that, we are using the filter once in the prompt page and a filter in the query also. But in the Cognos 8.3 it throws an error when I try to do it that way.
The error looks something like this.
Prompt 'beginning_AR_date' is used multiple times with conflicting data types
In Details
RSV-SRV-0042 Trace back: RSReportService.cpp(747): QFException: CCL_CAUGHT: RSReportService::process() RSReportServiceMethod.cpp(217): QFException: CCL_RETHROW: RSReportServiceMethod::process(): promptPagingForward_Request RSASyncExecutionThread.cpp(690): QFException: RSASyncExecutionThread::checkException RSASyncExecutionThread.cpp(204): QFException: CCL_CAUGHT:…….and goes on.