PSQuery Date Math
by PSQuery is a great tool for PeopleSoft ad hoc reporting. But it does have a challenge when it comes to working with Dates.
Use MetaSQL to manipulate dates in PSQuery
What if the next ERP UI is AI?
This is more than just chatbots with key words and behaviors.
Let it have the whole thing. Let it learn what and how from the system.
AI isn’t coming after me…
AI isn’t putting me out of my job today.
I’m feeling pretty good about tomorrow too.
Creating Materialized Views in PeopleTools
Use Materialized Views to improve poor performance of complex SQL Views
QR Codes in BI Publisher
QR Codes are machine-readable graphics that store information.
BI Publisher (theoretically) can print two types of codes: QR Codes and PDF417 codes.
Formatting DateTime Fields in BI Publisher Excel Templates
We’ll discuss how to bring in Date-time fields from an XML file and convert it to an Excel Date-time format making it more readable for your users and manipulable through Excel’s date-time math and formats.
BI Publisher Report Categories
PeopleSoft uses BI Publisher Report Categories to control if a user has access to run any specific BI Publisher report. This access controls whether a user can run a report and if they can even see the report definition.
PSQuery Record Security
… questions about which roles and permission lists have access to a specific record can be a trip down the multiple rabbit holes.
Search Record Overrides
Overriding the search record allows us to use the same component in different situations without modifying that component.
We can reuse a component for a specific user group with a targeted search record that doesn’t affect that same component with other users by attaching that component to a different menu and overriding the search record there.
ReConnect 23
PeopleTools Tech Tips will be at PeopleSoft ReConnect at Blueprint 4D in Dallas, Texas, USA from May 8 to 11.