Displaying Data from Multiple Datasets in BI Publisher RTF Template with Hyperlink Support
We have a business requirement to include hyperlinks in the output of an Oracle Fusion BI Publisher report, enabling users to directly navigate to specific application pages from the report.
To manage large data volumes, we are using an RTF template with a style sheet that splits the output across multiple sheets. This approach was suggested by oracle Support on an SR and resolves the improper hyperlink issue beyond 65K, but introduces a limitation—RTF templates with sheet splitting can reference only one dataset from data model
However, our data model includes a secondary dataset specifically designed to extract period-wise beginning and ending balances. We need to display data from this additional dataset along with the main dataset in the report.