Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: samcom on 28 Feb 2013 12:47:13 PM

Title: View External data Report output
Post by: samcom on 28 Feb 2013 12:47:13 PM
When joined to external data, I'm unable to view report output in excel 2013 which was otherwise working fine with previous version. All reports are working fine except for the ones wherein I bring external data.

Below is the error:

RQP-DEF-0388
Missing key projection for supporting the blob projection in the query
Details
DPR-ERR-2082 An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID:2013-02-28-13:44:55.389-#73

Any help is appreciated.
Title: Re: View External data Report output
Post by: Rahul Ganguli on 01 Mar 2013 05:37:31 AM
Are you using Excel as data source for External Data?
Can you try using csv file instead?
Title: Re: View External data Report output
Post by: samcom on 01 Mar 2013 09:20:48 AM
I'm using a csv file
Title: Re: View External data Report output
Post by: Rahul Ganguli on 04 Mar 2013 12:31:32 AM
Hi,

Can you create a simple list report whcih is based on external data, nothing from Existing package. Then create another list report which is based only on package data. And see if these two reports are performing well. If this is the case then there is some issue with the joins, you need to revisit the mappings. Else I think package report may give you the same error, I am thinking it is something to do with the existing package.

Let me know you findings.

Regards,
Rahul
Text only | Text with Images