ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

How to reset DWH data

book

Article ID: 227188

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS STARTER PACK-CLARITY PPM

Issue/Introduction

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

Environment

Release : Any

Component : CLARITY DATA WAREHOUSE

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