Reporting

A report dataset is something a dashboard can ask questions of: the dimensions it can be grouped and filtered by, the measures it adds up, and the time grains it buckets by. Read one to render a report builder without hard-coding anything, then ask it a question with POST /report-queries.

A filter is always filled from a lookup, never typed. A dimension whose lookup is Search is found by typing part of a name into dimension-values; what comes back is the value to filter by, with the name beside it. That is how a merchant filter works: search Acme, pick Acme Pty Ltd, filter by its mcht_ id. The values page by cursor: pass nextStartingAfter back as startingAfter for the next page.

Only the dimensions this caller may see are listed, and a dataset this caller may not read is not listed at all.

A caller no tenant bounds, the platform's own staff, is shown only the datasets of the reporting areas it holds: ReportsAcquiring_Query for payments, funds and finance, ReportsLending_Query, ReportsCustomers_Query and ReportsOperations_Query for Cube health. A dataset outside them answers as one that does not exist, as does a question narrowed to a tenant outside the caller's reach.