Budget Information in the Data Warehouse

book

Article ID: 223671

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

Where can budget cost be found in the DWH database?

Environment

Release : 15.9.1

Component :

Resolution

After running the Load DWH job, the information can be found in the table: DWH_INV_SUMMARY_FACTS
Obtain the project internal database id (or from the URL, e.g. http://server/niku/nu#action:projmgr.projectProperties&id=5024041

select * from dwh_inv_summary_facts
where investment_key = 5024041