You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Cumulative totals in OTBI

Accepted answer
87
Views
1
Comments

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!