Getting things done with PeopleTools
Deleting and recreating your Insights Index Patterns removes all formatting and formulas. There also is a good chance to break all your visualizations using that Index Pattern.
Instead, refresh your Insights Index Patterns
Every Insights dataset from PeopleSoft has a Drilling URL.
Use that URL in your Insights Dashboards to link the user back to PeopleSoft pages.
Insights (Kibana) Dashboards provide valuable information to your users … but it only works if ALL the data you think you are sending to Insights has actually arrived …and has been indexed.
Microsoft Office 365 updates have disrupted the BI Publisher Desktop Add-In for Word and Excel, stopping the creation and support of BI Publisher RTF report templates. Oracle is working on a bug fix, but a comunity member has provided a workaround involving registry edits. The steps include adding registry keys and reactivating the Add-In.
Using PeopleTools and PeopleCode, we can add additional security features to BI Publisher generated PDF reports to help safeguard your company’s data.
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
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 putting me out of my job today.
I’m feeling pretty good about tomorrow too.
Use Materialized Views to improve poor performance of complex SQL Views
by 
