Comparing NULLs in Oracle SQL
by Nulls are special in Oracle SQL – we can’t directly compare them since they won’t equal anything including themselves.
Use Oracles NVL() function to compare fields that may contain Null values
Category: PeopleTools
PeopleSoft PUM: Map the Tools_Client folder
You’ve successfully installed your PeopleSoft PUM. Now map to the PUM’s /tools_client/ folder and install the latest PeopleTools on your local machine.
PeopleTools 8.62 Available in HCM PUM 53
Time to get your PeopleTools Geek on and update your home labs to the latest PeopleTools 8.62 version
Use Insights Dashboards in Navigation Collections
Use a PeopleSoft Fluid Navigation Collection to organize multiple Insights Dashboards
So, you want better Technicals?
… Then invest in your Functionals.
(another bloviating opinion piece)
Format Numbers in Insights Dashboards
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?
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.
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
Creating Materialized Views in PeopleTools
Use Materialized Views to improve poor performance of complex SQL Views