Analytical previewing of multi-dimensional sales territory proposals

A system comprising:

• one or more processors;
• and
• a user interface subsystem, configured to:
• receive a modification to a set of proposed territory definitions at a territory management system, the set of proposed territory definitions representing a hierarchical set of proposed territories each as a set of cells of a hypercube, the hypercube defined according to a set of territory dimensions each having a set of dimension members, such that each cell represents an intersection of dimension members from each territory dimension, and at least some of the cells store metrics data corresponding to its intersection of the dimension members from each territory dimension;
• and
• receive a query, wherein the query identifies an opportunity defined by opportunity data;
• an analysis subsystem, communicatively coupled with the user interface subsystem, and configured to:
• update the proposed territory definitions according to the modification;
• execute the query against the proposed territory definitions to generate the query result by:
• generating an opportunity definition by transforming the opportunity data to corresponding dimension members of the hypercube;
• and
• determining a matching territory from the hierarchical set of proposed territories for assignment of the opportunity according to matching the proposed territory definition of the matching territory with the opportunity definition;
• execute the query against the proposed territory definitions to generate a query result, wherein determining a matching territory from the hierarchical set of proposed territories for assignment of the opportunity according to matching the proposed territory definition of the matching territory with the opportunity definition comprises:
• generating a set of de-normalized territory definitions by de-normalizing at least some of the proposed territory definitions according to their corresponding territory dimensions and dimension members;
• and
• determining the matching territory by identifying one of the hierarchical set of proposed territories for which the dimension members of its de-normalized territory definition at least encompass the dimension members corresponding to the opportunity definition;
• and
• output the query result, via the user interface subsystem, by generating an assignment preview of the opportunity to the matching territory.

A non-transitory machine-readable medium having stored thereon a series of instructions which, when executed by a processor in a territory management system, cause the processor to perform steps comprising:

• generating a set of proposed territory definitions in a territory management system, the set of proposed territory definitions representing a hierarchical set of proposed territories each as a set of cells of a hypercube, the hypercube defined according to a set of territory dimensions each having a set of dimension members, such that each cell represents an intersection of dimension members from each territory dimension, and at least some of the cells store metrics data corresponding to its intersection of the dimension members from each territory dimension;
• receiving a modification to the proposed territory definitions at the territory management system via a user interface;
• updating the proposed territory definitions in the territory management system according to the modification;
• receiving a query at the territory management system via a user interface, wherein receiving the query comprises receiving an opportunity defined by opportunity data;
• executing the query against the proposed territory definitions in the territory management system to generate a query result, wherein executing the query against the proposed territory definitions in the territory management system to generate the query result comprises:
• generating an opportunity definition by transforming the opportunity data to corresponding dimension members of the hypercube,
• determining a matching territory from the hierarchical set of proposed territories for assignment of the opportunity according to matching the proposed territory definition of the matching territory with the opportunity definition, and
• outputting the query result from the territory management system via the user interface comprises generating an assignment preview of the opportunity to the matching territory;
• determining a matching territory from the hierarchical set of proposed territories for assignment of the opportunity according to matching the proposed territory definition of the matching territory with the opportunity definition comprises:
• generating a set of de-normalized territory definitions by de-normalizing at least some of the proposed territory definitions according to their corresponding territory dimensions and dimension members, and
• determining the matching territory by identifying one of the hierarchical set of proposed territories for which the dimension members of its de-normalized territory definition at least encompass the dimension members corresponding to the opportunity definition;
• and
• outputting the query result from the territory management system via the user interface.