BIP Microsoft Word Repeating Value Suppression — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BIP Microsoft Word Repeating Value Suppression

Received Response
91
Views
8
Comments
2771861
2771861 Rank 4 - Community Specialist
in Oracle Analytics Cloud and Server

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:

image

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

Any suggestions welcomed!

Thanks a lot

Answers

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics Coach

    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.
    Pavan kumar. Rank 5 - Community Champion

    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
    2771861 Rank 4 - Community Specialist

    Great, that's worked! Thanks a lot!

  • 2771861
    2771861 Rank 4 - Community Specialist

    Hi,

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

    image

    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
    2771861 Rank 4 - Community Specialist

    Thank you!

  • 2771861
    2771861 Rank 4 - Community Specialist

    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.
    Pavan kumar. Rank 5 - Community Champion

    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.
    Pavan kumar. Rank 5 - Community Champion

    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.