Update the data behind your reports, and know it fits your master data before you save
Your team edits in a familiar grid that writes straight to your data platform. Every value is checked while they are still in the field, and your reports show the change at once.
Typing part of a name finds the right value
In a cost center mapping, typing “logistics” into a cost center cell finds the logistics cost center of that row's company, with its key beside the name. The person picks what they mean, and the cell stores the key your platform expects.
Compound keys, shown in full
SAP master data often needs several values to name one object. Once the controller has chosen controlling area EU01, typing “export” in the form lists the export cost centers of every company in EU01, each with its full key: controlling area, cost center and company code.
Spreadsheet-like editing, on the platform
People edit in the table with keyboard navigation, copy and paste across rows and bulk changes. Master data columns show the text with its key, here the cost center, company code and business line of each mapping.
Upload a file to update the table
An Excel or CSV file maps to the table's fields, and the preview shows what will happen before anything is written: here three new rows, one update and two rows that fail a check, each marked at the cell with its reason. Duplicates inside the file are flagged the same way.
The form asks only for the figure that applies
In this ESG form the person picks the emission source first. For electricity the form asks for the consumption in kWh and whether the tariff is green, and it keeps the figure marked as required until it is filled in.
Designed by your key usersEnterprise
The form designer sets when a field is visible, read-only or required, what its default is and when it resets, each as a condition on other fields. Here the note becomes required as soon as a mapping starts during the year instead of on January 1.
The form designer is part of the Enterprise edition; the pricing page lists what each edition includes.
Every match with its path
Typing a few letters lists every matching node together with its full path in the tree, so a product group is found by name wherever it sits.
Illustration from our hierarchy video.
Drag a node to its new parent
Dragging a node onto its new parent moves the whole branch with it. Several hierarchies, such as 2026 and 2027, sit side by side in one directory, every node carries its validity period, and a reference date shows the structure valid on that day.
Illustration from our hierarchy video. Watch the hierarchy video on YouTube.
Embedded mode shows the grid alone
Opened in embedded mode, the app shows the table without the navigation and sidebar and fits into the dashboard tile. Filters and sort order travel in the link, so this tile opens on the six cost centers of company code 1100.
The dashboard's context filters the rows
The dashboard hands its current selection, such as a company code or a cost center, to the embedded app as a filter. The same validation and authorization apply whichever BI tool hosts the app.
See it with your own tables
Take the deck to the team first, or spend half an hour with us on your data, in your BI tool.