Clarity: Business Objects Resource Assignment Report has poor performance

book

Article ID: 50566

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL CA Identity Manager CA Identity Governance CA Identity Portal Clarity PPM SaaS - Application Clarity PPM On Premise

Issue/Introduction

Description:

The performance in generating the Resource Assignment Report is very poor. In our sample, large database, the report took approximately 3 hours to generate.

Steps to Reproduce:

  1. Login to Clarity using a large dataset with many resources assigned to many tasks

  2. Main Application > Reports and Jobs > Available Reports: Resource Assignment
    Parameters:
    Start Period: Beginning of last month
    Resource OBS: Select an OBS with many resources
    Period Type: Weekly
    Group By: Project
    Execute the report as 'Scheduled'

Expected Result: The Report should complete in a reasonable time.
Actual Result: The report completed in approximately 3 hours.

Solution:

Workaround:
Resolved in Clarity 13.1, PMO Accelerator 3.1, Clarity Solution Pack (CSP) 3.1

The new Clarity Solution Pack 3.1 has four new reports that serve as replacement reports for the Resource Assignments report. We did the four separate reports for more flexibility in generating useful output.

These are the four reports in CSP r3.1 that replace the previously released Resource Assignments Report (ID = RPT_PPM_ResourceAssignments)

  • Investment Allocations and Assignments (ID = CSP_INV_AllocationAssignment)
  • Investment Assignments by Task (ID = CSP_INV_AssignmentsByTask)
  • Resource Allocations and Assignments (ID = CSP_RES_AllocationAssignment)
  • Resource Assignments by Task (ID = CSP_RES_AssignmentsByTask)

Keywords: CLARITYKB, CLRT-48992, CLRT-51511, clarity13resolved, clarity1310resolved, pmo31resolved, cspreports.

Environment

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