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
|
