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.

Data Warehouse Table Information For Planned Cost and Budget Cost Total

book

Article ID: 219124

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

Planned Cost and Budget Cost information is not found in the following tables DWH_FIN_PLAN_SUMMARY_FACTS

 

Environment

Component : CLARITY DATA WAREHOUSE

Resolution

The plans can be found in the DWH_FIN_PLAN table.

In the Administration > System Options > Data Warehouse Options , make sure the field (Include only Financial Plan or Record) so the it will reduce the number of financial plans entering the DWH database.

 

 

 

 

 

 

Additional Information

If a cost plan does not exist for a project, the Financial Summary page can be populated.

The following query can be used:
select * from dwh_inv_summary_facts
where investment_key = 5xxxxxx