Description:
Clarity does not pass parameters correctly to a Business Objects, Multi-Query WEBI Report.
We have a few user-defined BO reports, which have been written with multiple queries, which share prompts. When this is run from Business Objects it prompts for these once and supplies the values to all the queries. However, when this report is run from Clarity it only passes the parameters to the first query, while the other queries appear to pick up old values.
Steps to Reproduce:
Expected Result: Both queries in a two query report should process a common parameter, passed from Clarity, and return common results.
Actual Result: In a multi-query report, the first query in the report will process the passed parameter correctly but the second query returns erratic results. The returned value for the second query will return the expected value or a null value.
Solution:
Workaround:
Execute the report from Business Objects InfoView.
Status/Resolution:
Resolved in Clarity 12.0.6 Generic Patch (Reference TEC522707 for CLRT-53596) and in progress for resolution in an upcoming Clarity 12 Service Pack.
Keywords: CLARITYKB, CLRT-53596, CLRT-55416, clarity12resolved.