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

Suppressing measures with OTBI report does not work

5
Views
0
Comments

Summary

Any way to suppress measures while reporting with OTBI?

Content

I have a requirement to report the Purchase Orders and the related vendors invoices in Procurement for a project. A Purchase Order can have several vendor invoices against it. 

Here is how the report looks like with OTBI.

 

For the first case, PO # 10006523, there are two invoices, (INV 160, INV164). As all this information is reported from a single subject area, OTBI repeats the PO amount and PO Qty twice as there are two invoices. I included a calculated field on remaining PO amount and Qty, where the calculation goes haywire. However, at the PO number level totals, the values are fine. What I am looking for is two things: 1) how to suppress the PO amount and PO Qty from repeating? (these are both measures). and 2) How to suppress the calculated fields Remaining PO

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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