New MUX Reporting does not display Per Period Metrics

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

The new Clarity Reporting Data Providers in MUX are missing key Per Period Metrics such as Actuals, Planned Cost, and Forecast Cost etc. How can we add the metrics to be available? 

Environment

Clarity 16.3.0+

Cause

SQL Curve Data is not enabled on this environment and this is a prerequisite for displaying metrics in MUX Reporting as per Broadcom Documentation

• System Options for SQL Curve Data in Classic:
• To display Per-Period Metrics in the Preview Tab, ensure that Include SQL Curve Data  is enabled under System Options in Classic. Also, run the Data Warehouse Load jobs  as required.

Resolution

Enable SQL Curve Data in Clarity

1. Go to Clarity Classic – Administration – System Options
2. Select Include Sql Curve Data (Beta) to be enabled, Save
3. Run Load Data Warehouse – Full Load to completion

You should now be able to see the metrics in Reporting.