Hello Experts,
I am developing a custom report in Oracle ARCS using BI Publisher. The report layout is created as an RTF template in Microsoft Word based on an XML data source generated from a SQL query.
Currently, I have a pivot table that displays aging buckets (0-30 Days, 31-60 Days, 61-90 Days, 91+ Days, Total) with Count and Amount columns, grouped by Account ID.
I need to add a Currency column immediately after the Account ID column, as shown below:
Account ID | Currency | 0-30 Days | 31-60 Days | 61-90 Days | 91+ Days | Total
The challenge is that the Currency information may come from a different dataset than the one currently used for the pivot table.
Could anyone advise on:
- Whether a BI Publisher Pivot Table supports adding a non-pivot column such as Currency between Account ID and the pivoted data columns?
- If Currency is sourced from another dataset, what is the recommended approach?
- Join Currency into the main SQL query/data model?
- Use a data set link?
- Use XDOXSLT lookup functions within the RTF template?
- Are there any examples or best practices for displaying additional attributes such as Currency alongside row-group fields in a BI Publisher pivot table?
Attached is a screenshot of the current layout for reference.
Any guidance or sample implementations would be greatly appreciated.
