If you are unable to create a new account, please email support@bspsoftware.com

 

Drill Through Report From DMR report to DMR Report-Expand and Collpase function

Started by CognosBIUser1, 14 Jan 2019 07:19:00 AM

Previous topic - Next topic

CognosBIUser1

Hi Fellow Cognos Users.

I have two reports Summary and Detail where the detail report is a drill through report of the Summary.
I am having an issue with the expand and collapse functionality when I drill through from the summary report to detail I get the detail report but when I try to expand the hierarchy on the detail report by double clicking (or by using the expand member menu option) I get the following error message.
But if I were to run the detail report by it self and then try to expand then I am not getting an error message.
I have tried this with passing the parameter value from the summary to detail and even with disabling the prompt on the detail report and just simply doing a drill through to detail.
the detail report opens up but throws the error when I try to expand. But the expand will work if I were to drill down first and then try to expand.
Not able to see what the issue is here. (to me it looks like when drill though is happening the detail report doesn't know its parent. )

Below is the error message :

RSV-SRV-0003 The report specification contains an error at line ' 62', column ' 4,188'.
Duplicate unique value declared for identity constraint of element 'selection'.
RSV-SRV-0042 Trace back:
RSReportService.cpp(766): RSException: CCL_CAUGHT: RSReportService::processImpl()
RSReportServiceMethod.cpp(253): RSException: CCL_RETHROW: RSReportServiceMethod::process(): asynchRunSpecification_Request
RSASyncExecutionThread.cpp(873): RSException: RSASyncExecutionThread::checkException

RainerF

I have the same problem and found this:

PH02707: EXPAND MEMBER OPTION ON HTML REPORT OUTPUT RESULTS IN DUPLICATE UNIQUE VALUE ERROR *
APAR status
Closed as fixed if next.
Error description
When selecting the Expand Member option on a report built with
dimensional data that was run in HTML from the CA Welcome
Dashboard, users receive the error: RSV-SRV-0003 The report
specification contains an error at line ' 58', column ' 2,010'.
Duplicate unique value declared for identity constraint of
element 'selection'.
Local fix
Problem summary
****************************************************************
* USERS AFFECTED:                                              *
* All Users                                                    *
*                                                              *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
*                                                              *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to IBM Cognos Analytics 11.1.2                       *
****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR numberPH02707
Reported component nameCOG REPORT STUD
Reported component ID5724W12RS
Reported releaseB0A
StatusCLOSED FIN
PENoPE
HIPERNoHIPER
Special AttentionNoSpecatt / Xsystem
Submitted date2018-09-11
Closed date2019-06-05
Last modified date2019-06-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels