Oracle Analytics

Get Involved. Join the Conversation.

Topic

    Carley Howell
    BIP Microsoft Word Repeating Value Suppression
    Topic posted May 16, 2017 by Carley HowellRed Ribbon: 250+ Points, last edited September 11, 2019 
    23 Views, 8 Comments
    Title:
    BIP Microsoft Word Repeating Value Suppression
    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:

    pastedImage_0.png

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

    Any suggestions welcomed!

    Thanks a lot

    Comment

     

    • Pavandattikumar

      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

    • Venkythota54

      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.

    • Carley Howell

      Great, that's worked! Thanks a lot!

    • Carley Howell

      Thank you!

    • Carley Howell

      Hi,

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

      pastedImage_1.png

      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

    • Pavandattikumar

      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

    • Carley Howell

      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,

    • Pavandattikumar

      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.