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 a multi-dimensional data model, 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 variance 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;
• calculating a frequency of occurrence metric between planned data at the first granularity for the first data combination and actual data observed for the first data combination, wherein the frequency of occurrence metric comprises a frequency of occurrence of variance between the planned data for the first data combination at the first granularity and the actual data observed for the first data combination;
• automatically adjust the planning granularity for the first data combination from the first granularity to a second granularity when the variance metric meets or exceeds a first threshold and the frequency of occurrence metric meets or exceeds a second threshold;
• 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 combination at the second granularity based on the adjusting.

A system for configuring data granularities for a multi-dimensional data model, 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 variance 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;
• calculating a frequency of occurrence metric between planned data at the first granularity for the first data combination and actual data observed for the first data combination, wherein the frequency of occurrence metric comprises a frequency of occurrence of variance between the planned data for the first data combination at the first granularity and the actual data observed for the first data combination;
• automatically adjust the planning granularity for the first data combination from the first granularity to a second granularity when the variance metric meets or exceeds a first threshold and the frequency of occurrence metric meets or exceeds a second threshold;
• 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 combination at the second granularity based on the adjusting.