search cancel

Where Can I find the Staffing Section Data in the OData Tables in PowerBI

book

Article ID: 202212

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

I have looked through the Odata Warehouse/feed to find the staffing section because I want to connect the employees staff hours to our PowerBI but I can not find the data tables in the Odata to connect that data to our PowerBI.  Can you let me know which data table(s) in the Odata contain the data/inputs found in the staffing section so we can report on employee staff hours and forecast.

Environment

CLARITY APPLICATION

Resolution

The Staffing Section Data in the OData Tables in PowerBI are as follows:

The Allocations are in the team facts table: DWH_INV_TEAM_PERIOD_FACTS
- If you want monthly data check the table: DWH_INV_TEAM_PER_FACTS_M_V
- If you want summarized data by month for the resource check: DWH_RES_PER_FACTS_M_V

Data Warehouse Fact Tables
The DWH_TEAM tables with SUMMARY in the name store summarized facts.
- Summary tables exist for many of the facts.
- If you are matching summary numbers to period facts, qualify the period facts by a period type.

In Clarity the Team/Staff page shows Allocations:

Attachments