What is the correct Measurement Source to pull hourly allocations into an Ad Hoc Jaspersoft report?

Products

• CLARITY PPM FOR ITG
• CLARITY PPM FEDERAL
• Clarity PPM SaaS - Application
• Clarity PPM On Premise

Issue/Introduction

Question:

What is the correct measurement source to pull hourly allocations into an Ad Hoc report in PPM?

 

I am creating an Ad Hoc view that pulls in resources and investments with their hourly allocations similar to the weekly detail portlet, however I can not seem to pull in individual resource allocations.

 

Answer:

The measurements that allocation hours are found under are Weekly Periods, Calendar Periods, and / or Fiscal Periods.

 

Below are the steps on how to pull in these measurements.

1. In Advanced Reporting, select Create then Ad Hoc View
2. Click Domains
3. Drill down in CA PPM->Domains->Investment Management and click 'Choose Data' 

<Please see attached file for image>

4. Select your desired fields for the report, being sure to include the period types you want to use in allocations: Weekly Periods, Calendar Periods, and / or Fiscal Periods (For this example: Weekly Periods) 

<Please see attached file for image>

5. Click the desired report type. (For this example: Table)

6. Under the "Measures" section on the bottom left hand side of the page, drill down into the following: Investments->Weekly Periods->Team->Hours

<Please see attached file for image>

7. Drag and drop the desired allocation hour types (Such as Team Allocation Hours) over to the New Ad Hoc window

 

Environment

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