Next-Generation Reporting & Business Intelligence Suite
for Retail Pro Prism
Turn your raw Oracle RPS data into beautiful, actionable insights. Self-service reports, live dashboards, and automated delivery — deployed as a Windows service in under 20 minutes.
Built for Retail Pro Prism®
Everything You Need. Nothing You Don't.
Every feature was designed for one purpose: getting the right numbers to the right people at the right time.
Self-Service Builder
Build any report without writing a single line of SQL. Point, click, publish — your team is empowered from day one.
Live Dashboards
Real-time KPI widgets that auto-refresh every 60 seconds. Your business pulse, always on screen.
Advanced CTE Engine
Chain complex Oracle CTEs visually. Union queries, computed columns, window functions — no DBA required.
Scheduled Delivery
Auto-email reports as Excel or PDF on any schedule — daily, weekly, monthly, or custom cron expressions.
Role-Based Access
Fine-grained permissions down to individual columns. Users see exactly what they're allowed to — nothing more.
White-Label Ready
Your logo, your colours, your brand. 18 built-in colour themes and full CSS customisation — zero code changes.
Build Any Report. Visually.
Your merchandisers, finance team, and store managers can build their own reports — without filing an IT ticket, without waiting days, without knowing SQL.
Browse all 200+ Oracle tables and columns visually. Drag any field into your report in seconds.
Date range, multi-select dropdown, text search, numeric range, and boolean toggles.
Add RANK, DENSE_RANK, LAG, LEAD, ROW_NUMBER — with partition and order controls built in.
Build multi-step WITH clauses by connecting query blocks. Complex logic made readable.
See the exact parameterized Oracle SQL your report generates — reviewed, clean, injection-proof.
Run any report against real data instantly before saving. No guessing, no surprises.
SQL Power. Zero SQL Required.
PrismIQ generates full Oracle SQL WITH blocks — including nested CTEs, window functions, and complex joins — from a visual interface your analysts can actually use.
Stack multiple SELECT statements across stores, regions, or date ranges
Multi-table JOINs encapsulated as a named, reusable query block
Derive new columns from prior CTEs — ratios, averages, conditional logic
Escape hatch for power users — write any valid Oracle SQL directly
Two Outer Query Modes
SELECT * FROM final_cte — your last named CTE becomes the output. Perfect for clean pipeline-style queries.
Build the outer SELECT yourself with a base table and additional joins, while all CTEs remain in scope.
-- Auto-generated by PrismIQ WITH store_sales AS ( SELECT s.store_code, SUM(t.net_amount) FROM rps.trs_transactions t JOIN rps.str_stores s ON s.sid = t.store_sid WHERE t.doc_date >= :p_date_from GROUP BY s.store_code ), ranked_stores AS ( SELECT *, RANK() OVER ( ORDER BY net_amount DESC) AS rnk FROM store_sales ) SELECT * FROM ranked_stores
Window Functions Available
Injection-Proof by Design
Table and column names come exclusively from trusted JSON configs. Every user value flows through Oracle bind parameters — no exceptions, no overrides, no bypass.
Your Business at a Glance — Always.
Personalised per-user, drag-and-rearrange, auto-refreshing every 60 seconds. Walk into any meeting already knowing the numbers.
Each user sees their own dashboard configuration, saved server-side.
Widgets silently refresh — no page reload, no disruption.
Powered by React Grid Layout. Your layout persists across sessions.
Export Anywhere. Automate Everything.
Reports in your inbox before you even open your laptop. That's not a promise — it's the default.
Export Anywhere
5 formats, instant or scheduled
Automate Everything
Set it and forget it
Enterprise-Grade Security. Out of the Box.
We didn't bolt security on as an afterthought. It's baked into every layer of the platform — from the database connection to the API response.
JWT Authentication
8-hour access tokens signed with HS256. Passwords hashed with bcrypt (12 rounds). No plain-text credentials, ever.
Role-Based Access Control
Assign users to groups. Each group gets granular access to specific reports and dashboard widgets — nothing bleeds over.
Column-Level Masking
Configure specific columns to return *** for specific groups. Enforced server-side in the query engine — no client-side bypass possible.
SQL Injection Proof
Oracle connection is read-only. Table and column names are whitelist-controlled. All user values go through cx_Oracle bind parameters.
Audit Trail
Every report execution is logged: user, timestamp, applied filters, row count returned, and execution time. Full accountability.
Inactive Account Blocking
Deactivated users are blocked at the JWT validation layer. Session tokens are invalidated immediately upon account suspension.
Hit the Ground Running — 34 Pre-Built Assets Included.
Day one productivity. No setup, no configuration. Just log in, and your most critical retail metrics are already waiting.
18 Reports
16 Dashboard Widgets
Make It Yours — Complete White-Label Control.
Your brand deserves to be front and centre. PrismIQ gets out of the way and lets your identity shine.
What's Coming — The Platform Keeps Growing.
PrismIQ is a living platform. Every release adds real capabilities shaped by real retail operations feedback.
Built on a Rock-Solid Foundation.
Every technology choice was made for production reliability, not trend-chasing. These tools are battle-tested in enterprise retail environments.
All packaged into a single Windows installer — no manual dependency setup, no environment configuration, no IT headaches.
Every Sale. Every Insight.
Every transaction processed through Retail Pro Prism holds answers your business needs. PrismIQ surfaces them — as executive-grade reports, live dashboards, and scheduled intelligence delivered to the right people before the workday begins.
Why teams switch to PrismIQ
Average deployment time — install, configure, connect, done.
18 production-ready reports available the moment you log in.
Your finance, ops, and sales teams build their own reports — no tickets, no waiting.
Read-only Oracle credentials. PrismIQ cannot touch your production data.