Auto-Granularity for Multi-Dimensional Data

A non-transitory computer readable medium having instructions stored thereon that, when executed by a processor, cause the processor to configure data granularities for multi-dimensional data, wherein, when executed, the instructions cause the processor to:

• store planning granularities for data elements including a first granularity for a first data combination, the first data combination comprising a combination of multiple dimensions of data, wherein a user interface is configured to display data for the first data combination at the first granularity;
• calculate a comparison metric between planned data at the first granularity for the first data combination and actual data observed for the first data combination, wherein the observed data is stored at a different granularity than the planned data;
• adjust, based on the calculated comparison, the planning granularity for the first data combination from the first granularity to a second granularity based on the calculated metric;
• and
• receive a selection of a cross-section of data spanning a plurality of dimensions in the multi-dimensional data model, the selection including the first data combination, wherein a user interface is configured to display data for the first data element at the second granularity based on the adjusting.

A system for configuring data granularities for multi-dimensional data, the system comprising:

• a processor;
• and
• a memory storing instructions for execution by the processor, the instructions configuring the processor to:
• store planning granularities for data elements including a first granularity for a first data combination, the first data combination comprising a combination of multiple dimensions of data, wherein a user interface is configured to display data for the first data combination at the first granularity;
• calculate a comparison metric between planned data at the first granularity for the first data combination and actual data observed for the first data combination, wherein the observed data is stored at a different granularity than the planned data;
• adjust, based on the calculated comparison, the planning granularity for the first data combination from the first granularity to a second granularity based on the calculated metric;
• and
• receive a selection of a cross-section of data spanning a plurality of dimensions in the multi-dimensional data model, the selection including the first data combination, wherein a user interface is configured to display data for the first data element at the second granularity based on the adjusting.