Reporting & Data Extraction
Any answer your planograms hold, in Excel, in seconds.
The Planogram Data Extractor
Point it at a folder — or at .psa files with no database at all — pick your fields from planogram, project, product, position, performance, and fixture data, and get a clean Excel workbook. Add aggregates (sum, average, min, max, count), group-by, per-column criteria, Excel-style format strings, and formula columns computed at extract time.
Report definitions save and reload, so the extract you built for last relay runs against this one in two clicks.
Grouped reports: past, present, and future in one row
Grouped reports pivot multiple planogram sets side by side: last relay, this relay, and the proposal — one row per product, one column set per group, with formulas across them. Future capacity minus past capacity is a column, not an afternoon.
Beyond the extractor: saved custom report definitions run against any folder, Add/Delete and Store Item List reports span nodes, relays, and categories with selectable keys — and every grid in the application exports exactly as you see it, filters and formatting included.
Everything reporting includes
- Planogram Data Extractor against the database or directly against .psa files
- Planogram, project, product, position, performance, and fixture fields
- Aggregates: sum, average, min, max, count
- Group-by, per-column criteria, and Excel-style format strings
- Formula columns calculated at extract time
- Grouped reports pivoting multiple planogram sets side by side
- Saved, reloadable report definitions
- Custom report definitions (.ccr) run against any folder
- Add/Delete report across nodes, relays, and categories
- Store Item List report with selectable keys (UPC, ID, UPC+ID, StandardCode)
- Grid export everywhere — exactly as displayed
- SQL Server underneath: bring your own BI tools whenever you want