Report Grid & Formulas
Report data grid with KPI formulas and product detail columns.
5 configurations
Reporting KPI Formulas
Edit in spreadsheetKPI formulas for reporting with variance types, contribution flags, FMOS config.
No reference value is available; use the guided form or ask the AI Agent for help.
Ask a simple question about this feature
Explanations use business language. To request a configuration change, say what you want to set, change, or add.
Column Labels & Hierarchy Allowlist
Configure in formDisplay labels for exports AND the reporting_hierarchy_levels allowlist (validation fails without it).
Important to know before configuring:
- If reporting_hierarchy_levels is missing, reporting grouping validation throws an error.
- dimensions labels should match the client's business labels (not always 'Department').
No reference value is available; use the guided form or ask the AI Agent for help.
Related setup to check
Complete first: Planning Levels & Duration
Ask a simple question about this feature
Explanations use business language. To request a configuration change, say what you want to set, change, or add.
Product Grouping Levels
Configure in formWhich hierarchy columns to include in GROUP BY at each view level.
No reference value is available; use the guided form or ask the AI Agent for help.
Ask a simple question about this feature
Explanations use business language. To request a configuration change, say what you want to set, change, or add.
Product Detail Columns
Edit in spreadsheetExtra product detail formulas at SKU level for exports.
No reference value is available; use the guided form or ask the AI Agent for help.
Ask a simple question about this feature
Explanations use business language. To request a configuration change, say what you want to set, change, or add.
Time Grouping Levels
Copy from referenceMaps time granularity to ClickHouse columns. Standard across clients.
No reference value is available; use the guided form or ask the AI Agent for help.
Ask a simple question about this feature
Explanations use business language. To request a configuration change, say what you want to set, change, or add.