Data Loss in DWH Tables

Products

• Clarity PPM On Premise

Issue/Introduction

Table such as DWH_FIN_PLAN_PERIOD_FACTS has less records than prior.

What is the reason?

Environment

Release: All

Resolution

As the issue is related to data, the root cause cannot be known, especially if the issue cannot be reproduced again, i.e. the data record count came back to expected row count.

There is not a history kept, as the DWH is a snapshot and holds no prior runtime data.

Possible causes can be attributed to:
Momentary Clarity database changes
Incorrect DWH database restored or queried.