Format Numbers in Insights Dashboards
by The Insights default number format can clutter charts with excessive precision.
What if you want just to show one, or maybe no decimals in your chart?
Author: Randall Groncki
Oracle ACE ♠
PeopleTools Developer since 1996
Lives in Northern Virginia, USA
Refresh Insights Index Patterns
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
Add URLs to Insights Dashboards
Every Insights dataset from PeopleSoft has a Drilling URL.
Use that URL in your Insights Dashboards to link the user back to PeopleSoft pages.
Are you missing data in your Insights Dashboards?
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.
BI Publisher TBAddin64 Error work around
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.
BI Publisher PDF Security
Using PeopleTools and PeopleCode, we can add additional security features to BI Publisher generated PDF reports to help safeguard your company’s data.
PSQuery Date Math
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.