BI Publisher Word Add-in

RajeshSai99

Hello,

I have built a custom report in ARCS where we have displayed all unmatched transactions in ARCS with their aging bucket, number of transactions and the amount.

We have columns for the Periods which holds the Period we run the report for (Period being one of the parameters) but in the SQL query, we have also included a calculation to include all 11 prior periods. These 11 prior periods are displayed as Period-11, Period-10 etc. but want these to be replaced by 2025-11, 2015-10 etc. assuming we run the report for 2025-10. These are the ARCS periods.

Is there any way we can do this in the BI Publisher Word add-in without tampering with the SQL query?

Also, we want to highlight the Total Number and Amount row. Is this conditional formatting?

Any help from a BI Publisher expert would be welcome.

Oracle has referred me to the BI Publisher community.

4-0001765354

Regards

Rajesh

RVohra

@RajeshSai99 , Welcome to the Oracle Analytics Community!

You can give it try by following steps:

1. Open Word template in BI Publisher Word Add-in.
2. Click inside the table header cell for period-11.
3. Insert a form field / BI Publisher field
4. Use this syntax: <?xdoxslt:set_column_name('Period-11','<?format-date:adjusted-period(Period, -11)?>')?>

Where adjusted-period() is a custom XSL function or you can use BI Publisher’s built-in date functions like: <?xdoxslt:set_column_name('Period-11', xdoxslt:format_date(add_months(xs:date($PARAM_PERIOD||'-01'), -11), 'yyyy-MM'))?>

$PARAM_PERIOD is your report parameter (e.g., 2025-10).

add_months(..., -11) calculates 11 months prior.

format_date(..., 'yyyy-MM') formats it as 2024‑11, etc.

Hope it helps!