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
My experiences with IBM COGNOS... Issues and Solutions ... The content on this blog is completely my interpretation and has nothing to do with IBM or my present / older employers
Monday, September 22, 2008
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.
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.
Subscribe to:
Posts (Atom)