nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

BIP Microsoft Word Repeating Value Suppression

2771861

Summary

BIP Microsoft Word Repeating Value Suppression

Content

Hi all,

When using the BIP plugin for Microsoft Word, is there a way to suppress repeating values?

e.g. in OBIEE we would use the following option:

But I can't find anything similar with the BIP Word plugin...

Any suggestions welcomed!

Thanks a lot

Find more posts tagged with

Accepted answers

All comments

Venkat Thota - BIP

put this code inside form field

1) <xsl:if xdofo:ctx="cell" test="position()=1"></xsl:if><xsl:attribute xdofo:ctx="block" name="number-rows-spanned"><xsl:value-of select="last()"/></xsl:attribute>

Or use below

<?C_AWAY[not(.=preceding::C_AWAY)]?> ----where c_away is field name that needs to be suppressed.

Pavan kumar.

Hi,

You can use the below example:

If your form field is <?Status?> then change the form field <?STATUS?> to <?STATUS[not(.=preceding::STATUS)]?>

Regards

Pavan

2771861

Great, that's worked! Thanks a lot!

2771861

Hi,

Do you know if there is a way to make this a bit more advanced, so in the below example:

The Actual Distance of lease 8373 has been suppressed, as it is 28250 (same as the one above), but ideally we would like it to only suppress the values for each Lease... does that make sense?

Thanks a lot

2771861

Thank you!

2771861

Hi,

Thanks for the response!

1. I want it to show the Allowed/Actual Distances for each Lease only once. What it was doing before is repeating the values for each "item" (report lowest granularity is "item" and each lease can have multiple items. What it is doing now is suppressing the distance values even when the lease has changed. Hope that makes sense?

2. "Allowed Distance" for lease 8374 and 8375 is 61333. "Actual Distance" for all leases is 28250.

Thank you,

Pavan kumar.

Hi,

Need to get some more understanding on below...

1.Do you mean that to suppress the lease distance explicitly ?

2.What are the values of actual distance before suppressing for each of the Lease distance.It means is there a list of actual distances for each Lease ?

If my understanding was correct ' Please have a try this model : <? STATUS [not(.=preceding::sum(STATUS))]?> '

It should perform the sum function for each Lease value

Pavan kumar.

Hi,

As you mentioned : The Actual Distance of lease 8373 has been suppressed, as it is 28250 (same as the one above), but ideally we would like it to only suppress the values for each Lease... does that make sense?

If there is a explicit actual distance covered in the data model (XML data),Then it would be possible or else it's somewhat typical to split the data into for the each lease.

Suggestion: Check the data model if the aggregate function is applied for the Actual distance column.if Yes remove the summation.Then you will get the distance splitted by the each lease.