Per Period Metrics in MUX Reporting - error dwh_fin_plan_crv_facts does not exist

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Going in MUX Reporting and trying to create a report, getting an error:

Error: relation "dwh_fin_plan_crv_facts" does not exist Position: 2869.

Environment

Clarity 16.3.1 +

Cause

• SQL Curve Data is required for MUX Reporting Per Period Metrics:
  • SQL Curve tables are required in Object-based Data Providers to display Per-Period Metrics. 

Resolution

1. Go to Clarity Classic - System Options - Check the field Sql Curve Data (Beta) to set it to enabled
2. Run a Full Load of Load Data Warehouse job