BI Pubisher Pivot Tables
by At design time, we don’t always know how many rows and columns a table will have, nor what their labels will be. Pivot Tables place a grid on a BI Publisher report that is data dependent.
Use XML Files in BI Publisher with PeopleSoft Batch Reporting
Running a BI Publisher report in batch doesn’t mean it has to use PSQuery as a data source. As per MOS (Doc ID 962712.1), an XML File is the most efficient way to feed the report data.
BI Publisher Bursting in PeopleSoft
Bursting BI Publisher reports breaks up a single report into multiple output files. Every time the value changes in a specific designated field, a new document is generated.
Create a BI Publisher Report in PeoopleSoft
Learn the basics of creating a BI Pub report for PeopleSoft
Install BI Publisher Desktop
The BI Publisher Desktop is the easiest way to create your report templates for BI Publisher Reports. Oracle provides Add-Ins for both Microsoft Word and Excel to help you quickly create new reports and modify existing reports.
PeopleTools Object Owner ID
Most PeopleTools objects allow a developer to classify and organize the object by the Owner ID field on the Object’s Properties page. This value doesn’t affect the object and is more Information Only. However, it does help during development and upgrades by providing the developer an idea of where this object is used.
PeopleTools 8.59 Notification Panel
The delivered PeopleTools 8.59 home page has a notification panel on the right. This is great if your organization wants a large notification panel on their home page.
… But how do you remove it if they don’t want it?
PeopleSoft Image Catalog Utility
The PeopleSoft Image Catalog is a simple utility allowing a developer to search for images by name or type and see the image object on the page instead of just relying on the image object name to be descriptive (it’s not).
BI Publisher Sub-Templates
Sub-Templates allow us to create a commonly used code block such as headers with logos and other information instead of recreating that header on every report. When an item in that header changes, we only need to change the header sub-template instead of every report that uses that common header.