Data Warehouse Table Information For Planned Cost and Budget Cost Total

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