How Western University Turned PeopleSoft Insights into Secure, Actionable Dashboards
-
Posted by Quest Customer Learning Team
- Last updated 11/18/26
- Share
PeopleSoft Insights offers organizations a way to transform operational data into meaningful visualizations, but delivering those insights securely to individual users can present challenges. At RECONNECT Dive Deep 2026, Albert (Ab) Birch, Director of Financial Information Systems, and Don Graham, Acting Team Lead of Western Information Systems at Western University, shared how their team overcame those challenges to build secure, user-focused PeopleSoft Insights dashboards.
Working with Gideon Taylor, Western University transformed existing electronic forms into interactive dashboards that help users track expense claims, identify approval bottlenecks, and access relevant information without compromising data security. Their implementation also established a reusable framework for future analytics across PeopleSoft.
From Administrative Reporting to User-Focused Analytics
Western University operates PeopleSoft Human Capital Management, Campus Solutions, and Financials and Supply Chain Management (FSCM). Within FSCM, the university has used Gideon Taylor eForms since 2021, with approximately 25–30 forms in production by 2025.
Two particularly important forms support expense claims for undergraduate students and non-university guests. Previously, administrators manually entered these expenses, creating additional administrative work. Moving to electronic forms improved self-service capabilities, but users still needed better visibility into claim status and approval workflows.
In December 2025, Western partnered with Gideon Taylor on a pilot project to explore whether eForms data could be transformed into actionable dashboards using OpenSearch and PeopleSoft Insights.
The initial dashboard provided administrative metrics, including total forms, processing times, and approval activity. Although technically successful, it lacked the departmental visibility Western needed.
Rather than creating another centralized reporting tool, the team wanted dashboards that administrators, claimants, and approvers could use to monitor information relevant to their responsibilities.
Solving the PeopleSoft Insights Row-Level Security Challenge
The most significant obstacle was security.
Western had previously experimented with Elasticsearch and Kibana dashboards but found their security limitations unsuitable for departmental reporting. Granting dashboard access could expose information beyond an individual user’s authorization.
Embedding user permissions directly into search indexes was also impractical. Every security change would require undeploying, redeploying, and recrawling the index. With thousands of users and potentially millions of financial records, that approach was not scalable.
The breakthrough came from leveraging Western’s existing financial security structure.
Each expense form contains a speed code, which identifies the underlying accounting distribution, including department and project ChartFields. Western already maintained a ledger security table identifying which users and roles could access specific department-project combinations.
Gideon Taylor developed an initial query and application package that connected indexed speed codes to this existing security framework. Graham subsequently expanded the solution into a reusable, query-driven security model.
Instead of storing individual user permissions in the search index, the system stores the relevant form attributes and evaluates authorization dynamically at runtime.
This separation provides several important advantages. Security changes do not require rebuilding indexes, users see only authorized records, and the same security framework can support additional dashboards.
The implementation also allows access based on form involvement. Users can view forms they created or approved even when they do not have broader departmental ledger authority.
Building a Unified Dashboard for Multiple eForms
Western initially developed its secured dashboard for guest expense claims before expanding it to include student expense claims.
Combining the two forms introduced another technical challenge: the team could not successfully use a UNION within PeopleSoft Connected Query.
Their workaround was to create an Application Designer view that combined both forms into a single record structure.
The view brought together form identifiers, financial amounts, currencies, payment details, speed codes, and drill-down URLs. A PeopleSoft Query then added calculated fields, including days since creation and days since the last action.
From there, the team created a Connected Query linking the form data to the security query, followed by a search definition using document-level security.
The configuration relies on an application package that evaluates authorized speed codes against Western’s ledger security data.
Graham’s reusable framework supports multiple security queries, allowing separate queries for guest and student forms without forcing all authorization logic into one complex query.
The presenters highlighted several practical configuration considerations:
- Security queries must be defined as process queries, with the authorized security value returned as the first field.
- Duplicate field names in search definitions require distinct PeopleSoft field labels.
- Each indexed record needs a unique drill-down URL; Western used the form ID to open the appropriate expense form.
These details proved important in moving from a working prototype to a production-ready solution.
Making Insights Part of the Everyday PeopleSoft Experience
After deploying the search definition and building visualizations in OpenSearch, Western needed to make the dashboard accessible through PeopleSoft.
The team imported the dashboard into PeopleSoft, configured its content reference, and placed it at the top of the existing expense claims navigation collection.
This made the Insights dashboard the default landing page for guest and student expense claims.
Users can now see active forms, approval statuses, departmental activity, weekly processing volumes, and forms awaiting action. They can filter by date, form type, or status and drill directly into individual expense claims.
For administrators supporting students who may submit an expense claim only once, this visibility is particularly useful. Instead of searching through individual records or responding to repeated status inquiries, administrators can identify outstanding claims and where they are stalled.
Importantly, the dashboard’s contents reflect each user’s authorization rather than exposing institution-wide information.
Balancing Data Freshness, Performance, and Security
Western’s implementation also demonstrates the importance of configuring refresh schedules appropriately.
The university runs incremental search indexing hourly, alongside hourly dynamic role processes. Its ledger security scope table is updated nightly.
However, the team configured the search instance cache interval to just five minutes.
This shorter interval reduces the risk of users seeing stale dashboard information after security or role changes. Graham also explained that a shorter cache interval helps PeopleCode changes take effect more quickly during development.
The team reported that incremental indexing typically completes in less than a minute, while a full index takes approximately 20 minutes. They had not observed significant performance issues with the five-minute cache interval.
Although real-time indexing remains a future goal, the hourly incremental approach currently provides an effective balance of simplicity and performance.
Creating a Foundation for Future PeopleSoft Analytics and AI
Western’s implementation earned a 2026 PeopleSoft Feature Innovator Award, recognizing the team’s approach to extending PeopleSoft capabilities.
More importantly, the project established a reusable security foundation for additional Insights dashboards.
Potential applications include employee expenses, research awards, capital-related processes, and existing query-based work centers. Graham also noted that Western’s graduate studies group is developing another dashboard using the same security concepts.
The team sees opportunities to connect analytics with AI. Western already uses Gideon Taylor’s Ida AI agent, called FINN internally, to answer financial questions through PeopleSoft. Although FINN is not currently integrated with Insights, Birch described a future where users could ask how many expense forms are awaiting approval in their department and receive an answer directly from the chatbot.
With PeopleTools 8.63 introducing additional capabilities for exposing OpenSearch indexes to AI tools, Western sees its current analytics investment as groundwork for future innovation.
Key Takeaways for PeopleSoft Organizations
Western University’s experience demonstrates that successful PeopleSoft Insights implementations require more than attractive visualizations. The underlying data model, security architecture, and user experience determine whether dashboards become useful operational tools.
By reusing existing ledger security, separating authorization from indexed data, and embedding dashboards directly into familiar PeopleSoft navigation, Western created a solution that is both practical and scalable.
For organizations exploring PeopleSoft Insights, the lesson is to begin with a specific operational challenge, build security into the architecture from the start, and design dashboards around what users actually need to accomplish.
Western’s approach shows how existing PeopleSoft investments can support more accessible analytics today while creating opportunities for broader automation and AI-enabled experiences in the future.
Want more?
Explore more content and resources to help you get the most from your PeopleSoft investment:
- Visit the Quest Learn Library for blogs, how-to demos, and on-demand sessions.
- Connect with peers in one of our Quest PeopleSoft Community User Groups to swap stories, ask questions, and share tips with other users facing the same challenges.
Not a Quest member yet? Join today and tap into the ultimate Oracle customer network.



