Wednesday, February 08, 2012

BI Publisher enhancements in PeopleTools 8.52



Yesterday (January 7th 2012), I attended the online Web Seminar  Why to use BI Publisher? New Features in PeopleTools 8.52 and a few interesting topics were handled that are introduced in PeopleTools 8.52 for BI Publisher
  • Data entered in PeopleSoft using a Rich Text Editor for Long fields can now be incorporated in BI Publisher sustaining the formatting

  • Ability to transform data, using JDeveloper XSL mapper or any third party tool

Rich Text Editor

For a while now we have the ability to add a rich text editor toolbar to pages for Long fields, by setting this property in Application Designer on the desired page field.


This is a great feature, but the down-side also was that the html formatting was only usable for online PeopleSoft. When you want to use the formatted data is other places like exporting data to Excel or mails the data would be presented as plain data with html tags. With PeopleTools 8.52 you can now use the html formatting entered in PeopleSoft directly in BI Publisher.

How?

Import the subtemplate

<?import:psxmlp://HTML_SUB?>

and use the following syntax for each formatted field

<xsl:apply-templates select="FIELD_NAME"/>

XSLT Mapper

Like using JDeveloper XSL mapper to transform your XML for Integration Broker messages to more readable and usable XML, you can now use XSL to transform the data as input for BI Publisher templates. You can lauch JDeveloper XSL mapper straight from PeopleSoft and not just from Application Designer. Besides JDeveloper XSL mapper, you can also use any third party product to create XSL to transform your XML and upload this to PeopleSoft. See the first screenshot in this post.

See the full Web seminar in PDF format or playback the seminar including audio.

No comments:

Post a Comment