Oracle Analytics Publisher

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

Categories

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

Help with XML BI Publisher Templates in Oracle

Received Response
11
Views
1
Comments
Martha Wasylynchuk
Martha Wasylynchuk Rank 1 - Community Starter
edited Jun 18, 2025 5:01PM in Oracle Analytics Publisher

Hi,

I'm trying to update my offer letter templates in Oracle. These are done through BI Publisher in Word.

I'm looking for a syntax that will print one paragraph if Location_Name = one of the 4 different locations, and if Location_Name is NOT = one of the 4 locations, then print a different paragraph.

This is what I had but it's not working:

C<?if: LOCATION_NAME IN('location A', 'location B', 'location C', 'location D')?>

Paragraph 1

EC

C<?if: LOCATION_NAME NOT IN('location A', 'location B', 'location C', 'location D')?>

Paragraph 2

EC

Answers

  • Gaurav Bharadwaj-Oracle
    Gaurav Bharadwaj-Oracle Rank 6 - Analytics Lead

    Hi @Martha Wasylynchuk ,
    It seems like your syntax is incorrect.
    Kindly look at this documentation for the correct syntax with examples.
    Conditional Formatting in RTF

    You need to use IF-ELSE-IF Statement here to achieve what you are looking for.

    An Example :
    <?xdofx:if AMOUNT > 1000 then 'Higher'
    else
    if AMOUNT < 1000 then 'Lower'
    else
    'Equal'
    end if?>

    If my response has answered your question or assisted you with your concern, please click"yes" below to accept the answer or comment with any additional queries. You can also read the Cloud Customer Connect Guidelines for Accepted Answer

    Regards,
    Gaurav