Combing OTBI Output in one row
Summary
Combing OTBI Output in one rowContent
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,