Cumulative totals in OTBI

Feb 13, 2023 11:41AM

Summary:

We want to create cumulative Actual costs in OTBI.

Please advise how to do this?

SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT

0 s_0,

"Projects - Performance Reporting Real Time"."Project"."Project Name" s_1,

"Projects - Performance Reporting Real Time"."Project"."Project Number" s_2,

"Projects - Performance Reporting Real Time"."Projects Calendar"."Project Period" s_3,

SORTKEY("Projects - Performance Reporting Real Time"."Projects Calendar"."Project Period") s_4,

"Projects - Performance Reporting Real Time"."Actual Cost Measures"."Actual Cost" s_5,

"Projects - Performance Reporting Real Time"."Budget Measures"."Budget Cost" s_6,

"Projects - Performance Reporting Real Time"."Calculated Measures"."Budget and Actual Cost Variance" s_7,