How to reset DWH data

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

How to reset Data Warehouse (DWH), data is missing and Full Load does not address this

Environment

Release : Any

Resolution

1. In System Options, remove the Entity for Data Warehouse and save (Note the name of the Entity)

2. Now select it back and save

3. Run Update Reports Tables job (with all options selected)

4. Run Load Data Warehouse - Full Load

Note: Removing the Entity will recreate the fiscal periods with auto-populated values, it's recommended to take note of the From Date, Number of Periods before resetting the DWH entity