Oracle Analytics Cloud and Server

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

String Functions in RTF template is not working in our EBS environment.

Received Response
162
Views
15
Comments
2»

Answers

  • Rick Taylor
    Rick Taylor Rank 3 - Community Apprentice

    Hi Brajesh

    Thanks for your reply. When you said that it worked for you, do you mean it worked in template viewer or word preview? The code as posted works in both of those tools. The issue with changing the statement to <?if:contains(CategoryName,'/')?> is that it provides an incorrect answer in preview (There are two Category Names per item) and in our case it still does not work in our environment because of the contains command. Could you confirm that contains works in your EBS XML publisher environment.

    Regards

    Rick 

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    Hi Rick,

    Could you try instr() function instead of contains().

    Please keep field tag as it is and put the below content

    Replace <?if: contains(current-grouping-key(),'/')?>  with <xsl:if test="xdoxslt:instr(current-grouping-key(),string('/'),number(1),number(1)) != 0">

    Replace <?end if?> with </xsl:if>

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    Hi Rick,

    Strange behavior of  BIP

    I have used same condition and tag as current-grouping-key() and giving me below output, which I believe is correct as per expected output you shared. 

    Behavior of BIP should not different in the same version of the instance. This makes me to think that correct template is getting picked up?

    Could you please check in your concurrent program is picking correct template?

    image

  • Rick Taylor
    Rick Taylor Rank 3 - Community Apprentice

    You little genius. That worked. Thankyou so much.

  • Rick Taylor
    Rick Taylor Rank 3 - Community Apprentice

    Hi Brajesh

    The correct template is being picked up because if I take out the contains the template works just produces the output with both categories. I honestly think that it is to do with the Advanced pricing Price book generation that it is not recognising the string function.

    Regards

    Rick