Suppressing measures with OTBI report does not work
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 Qty and remaining PO Amount in the lines but keep it in the totals?
| Project | Purchase Order | Vendor Invoice | PO Remaining | ||||||||||||||
| Project Number | Project Description | Task Number | Supplier Number | Supplier Name | Purchase Order Number | Open Date | Currency | Status | Open Ordered Quantity | Ordered Amount | Closed Date | Invoice Number | Invoice Date | Net Invoiced Quantity | PO Matched Amount | Remaining PO Amount | Remaining PO Qty |
| 123456 | Sample Project | 10.16 | S1234 | ABC LLC | 10006523 | 3/2/21 | USD | Open | 1,500.00 | $50,000.00 | INV160 | 3/29/21 | 120.00 | $6,000.00 | $44,000.00 | 1,380.00 | |
| 1,500.00 | $50,000.00 | INV164 | 4/26/21 | 56.00 | $2,000.00 | $48,000.00 | 1,444.00 | ||||||||||
| 10006523 Total | 1,500.00 | $50,000.00 | 176.00 | $8,000.00 | $42,000.00 | 1,324.00 | |||||||||||
| 10007365 | 6/10/21 | USD | Open | 1,200.00 | $94,000.00 | INV171 | 6/28/21 | 200.00 | $10,000.00 | $84,000.00 | 1,000.00 | ||||||
| 10007365 Total | 1,200.00 | $94,000.00 | 200.00 | $10,000.00 | $84,000.00 |
1,000.00
|
|||||||||||
Comments
-
Hello and good day!
Dearest Oracle Community friends,
I am also having problem with suppress value because it is column property defined properly but it is not giving the expected result. See image below:
Hope to hear from someone knowledgeable on this issue and provide possible solution.
Many thanks and best regards.
Regie
0 -
Hello @ravinat and @Regie Mercado ,
As it is 'Measure Column' OTBI will not allow to suppress the values.
Only alternative will be putting it as a pivot view.
Please review the below CCC discussion on a similar issue.
Thanks,
Praveen
0 -
@Praveena Kambhampati I disagree. Not everything can be turned into a pivot report.
I solved the problem by doing a workaround on the detailed PO info being repeated. I used a white font for the white background and ensured that the totals show up for the PO.
OTBI has several such limitations that I have reported here and it appears that Oracle has low priority for enhancing this product.1 -
Hello @ravinat ,
Can you please post the Enhancement/Idea in the Idea Labs for Oracle BI Development to review further.
Thanks,
Praveen
1