Project.Revenue_History

Purpose

For the calculation of Project Baseline Costs/Revenue

Use Case

Owner: Martyn Cole
Typical Use Case: Project Reporting Portal
Style: Fact

Code & Source related to Project.Cost(History)

Source

FACT_PROJECT_HISTORY_LOG_OL

WHERE [ELEMENT_TYPE_DB_KEY] = ‘REVE’

Key Parameters

Company
Project
Customer

Sample Exec

EXEC get.myView @dataMart = 'Project', @viewName = 'Revenue_History', @token = '<myToken>', @version = '<202404>'

Response

src.[COMPANY],
src.[PROJECT_ID],
src.[CUSTOMER_ID],

SEQ

[ACTIVITY_SEQ],
[CONTROL_CATEGORY] = [PROJECT_COST_ELEMENT],
[KEY_OBJECT_TYPE],
[ELEMENT_TYPE_DB_KEY] = [KEY_ELEMENT_TYPE_DB],

Dates

convert(date,[DIM_HISTORY_DATE_ID],23) as [HISTORY_DATE],

convert(date,[DIM_BASELINE_START_DATE_ID],23) as [BASELINE_START_DATE],
convert(date,[DIM_BASELINE_FINISH_DATE_ID],23) as [BASELINE_FINISH_DATE],

Entity

project_item_id,
customer_item_id = ent1.customer_id,

Measures

try_convert(numeric(15,3),cast([ESTIMATED_REVENUE] as float)) as  [ESTIMATED_REVENUE],
try_convert(numeric(15,3),cast([PLANNED_REVENUE] as float)) as  [PLANNED_REVENUE],
try_convert(numeric(15,3),cast([POSTED_REVENUE] as float)) as [POSTED_REVENUE],
try_convert(numeric(15,3),cast([ACTUAL_REVENUE] as float)) as  [ACTUAL_REVENUE],

Codes

Project

ent2.item_label AS PROJECT_NAME,
src.PROGRAM_ID,
src.SUB_PROJECT_ID,
ent2.PRU,
ent2.[Project Category],

Other Codes

COALESCE([BASELINE_REVISION_NUMBER],0) as [BASELINE_REVISION_NUMBER],
[EARNED_VALUE_METHOD],	
CURRENCY_CODE_ID as CURRENCY_CODE,