Clarity: WEBI and Recurrent Parameters

book

Article ID: 51137

calendar_today

Updated On:

Products

CA Identity Manager CA Identity Governance CA Identity Portal Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

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:

  1. Open InfoView
  2. Create new WEBI document
  3. Open the ca_clarity universe
  4. Select data elements from Project Related Info / Project -Investment Info
  5. Select Name and Scheduled Start date
  6. Add a query1 to filter the start date
  7. Add a query2 to filter the start date
  8. Make sure each query is in a separate section of the report
  9. Add an "in list" filter to query1 on Scheduled Start and save as prompt
  10. Add an "in list" filter to query2 on Scheduled Start and save as prompt
  11. Purge last results before saving the report
  12. Save the file to the CA_Clarity folder
  13. Login to Clarity
  14. Navigate to Admin Tool > Reports and Jobs
  15. Create a job definition for this report
  16. Add a parameter for start_date
  17. Save the job definition
  18. Main Application > Reports and Jobs > Execute the report
  19. Observe the results
    Note that, in Clarity, the parameter is applied correctly to query1 but the results from query2 are erratic.
    Note that, in InfoView, the parameter is applied correctly to both queries.
    Note the Report History screen in InfoView: Observe that in the parameters Passed section shows two parameters. Normally there would only be one parameter for this.

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.

Environment

Release: ESPCLA99000-12.1-Clarity-Extended Support Plus
Component: