Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Combing OTBI Output in one row

edited Nov 25, 2019 3:04PM in Reporting and Analytics for ERP 1 comment

Summary

Combing OTBI Output in one row

Content

I'm using the subject area "Project Costing - Actual Real Time" to result Debits and Credits of Project Cost Expenditure Lines. The trouble is DRs are CRs are resulted in 2 separate rows. I wonder if anyone have attempted to result the data in a single row albeit in separate columns? 

The below is the SQL issued for this OTBI Report. Concatenated Segments field hols Accounting KFF values.

If so please advise.

--------------------------------

SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT
   0 s_0,
   "Project Costing - Actual Costs Real Time"."Expenditure Item and Cost Distribution Details"."Apps Document Currency Code" s_1,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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