7/3/2023 0 Comments Bi tools excelJust like we used MS Word to create RTF templates, we use Excel to create XLS templates with the same desktop helper (Template Builder). We just need leverage these within our PeopleTools environment. Luckily, there is plentiful documentation, demonstrations, and examples of Excel Templates available. They are just new to PeopleTools’ implementation of BI Publisher. What and Why Excel TemplatesĮxcel templates allow us to generate Excel spreadsheets in BI Publisher using Excel.Įxcel templates are not new to BI Publisher. This document will introduce the basics of using Excel Templates with BI Publisher. Now using the Excel templates, we can work directly in Excel to define the report which provides many of the features and tools that the users are requesting. However, this is more of a “Work Around” than a solution and left a few concepts to be desired. Before this release, if we wanted to create a spreadsheet using BI Publisher, the fastest way was to use an RTF template with a table and force the output to Excel through the report definition. Starting with the release of PeopleTools 8.58, PeopleTools can now use Excel Spreadsheets as BI Publisher templates. PT3-BI-Pub-Excel-Template-Demo-Objects Download Summary
0 Comments
Leave a Reply. |