# US 2018/0322435 A1 · Performance & predictive dimensions for business intelligence data > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 2018/0322435 A1 - Document ID: US20180322435A1 - Status: Published application - Kind: A1 - Application number: 15/968,140 - Filed: 2018-05-01 - Published: 2018-11-08 - Earliest claimed: 2017-05-03 - Assignees: Aurora Predictions, LLC - Applicants: Aurora Predictions, LLC - Inventors: Robert J. Zwerling - Web page: https://patentgrep.com/patent/US20180322435A1 ## CPC - G06Q 10/06393: {Score-carding, benchmarking or key performance indicator [KPI] analysis} - G06N 5/02: Knowledge representation; Symbolic representation - G06N 5/046: Forward inferencing; Production systems - G06Q: INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR - G06N: COMPUTING ARRANGEMENTS BASED ON SPECIFIC COMPUTATIONAL MODELS ## Abstract Disclosed is a non-RDB geo-spatial database with a display interface enabling the computation of performance and predictive mathematical dimensions without requiring a dramatic increase in computational resources for every fourth dimension. Accordingly, dimensions can be added at any time and combined in an intelligent hierarchy to filter, segment, and predict data. The creation of performance dimensions and a hierarchical drill path can be developed without the aid of IT programming. ## Claims ### Claim 1 A business performance measurement and prediction system providing a user an ability to produce a business intelligence (BI) performance dimension (PD) in a geo-spatial database, wherein a dimension is defined as a structure to categorize data in the geo-spatial database, wherein a PD is a dimension characterizing data based on a performance of said data, according to one or more business rules, over a time period, wherein the system provides the user an ability to readily access the PD or a nonperformance dimension (NPD) via a drill path, the system comprising: (a) the geo-spatial database (101) comprising a plurality of data records storing business data, wherein each data record is categorized by a unique combination of one or more dimensions, wherein each data record contains one or more data attributes, wherein a data attribute is a the business related data assembled in an interval of time over a period of time, wherein data characterized by each data attribute has a numeric value; (b) a display interface (“PD wizard”) (103), operatively coupled to the geo-spatial database (101), receiving a set of criteria, on which to base a new PD, from a user, wherein the set of criteria comprises a selected dimension, a selected data attribute, a selected time period, and one or more selected business rules, wherein the PD wizard (103) comprises: (i) a memory unit (105) storing a main algorithm, a set of performance algorithms for executing a set of pre-defined business rules, a set of dimensions from which the user may select, a set of data attributes from which a user may select, and a set of time periods from which a user may select; and (ii) a processor (107), operatively coupled to the memory unit (105), executing the main algorithm, wherein during execution the main algorithm calls one or more performance algorithms according to the one or more business rules selected by the user from the set of pre-defined business rules, wherein the main algorithm: (A) acquires a unique data set from the plurality of data records, having the selected dimension, the selected data attribute, and the selected time period; (B) receives from the user the one or more business rules selected; and (C) calls the one or more performance algorithms, which calculates a performance of the unique data set according to the one or more business rules selected; wherein the new PD comprises the performance, wherein a label characterizing the new PD is applied as a name of the new PD, wherein the new PD is added to each of the data records and stored in the reference table attached to the geo-spatial database (101), wherein a drill path is formed for the new PD to expose performance results by creating a hierarchical order for one or more selected dimensions by listing, without programming, wherein a plurality of drill paths exist for the geo-spatial database (101) for a plurality of PDs and NPDs, wherein PDs of a predictive statistical nature can be included in a drill path; e.g. to identify good trends that are predicted to deteriorate. ### Claim 2 (depends on 1) The system of claim 1, wherein the set of criteria comprises a plurality of data attributes. ### Claim 3 (depends on 1) The system of claim 1, wherein the one or more pre-defined business rules are grouped by time comparisons, statistics, or rolling periods. ### Claim 4 (depends on 3) The system of claim 3, wherein the set of pre-defined business rules grouped by time comparison are configured to compare a performance of the unique data set during a first user defined time period to a performance during a second user defined time period. ### Claim 5 (depends on 3) The system of claim 3, wherein the set of pre-defined business rules grouped by rolling periods are configured to calculate a performance of the unique data set over a user defined rolling period. ### Claim 6 (depends on 3) The system of claim 3, wherein the set of pre-defined business rules are further categorized, for user selection, by methods of count, percent or standard deviation, wherein Boolean logic is employed to allow the user to define one or more cut-offs for each method. ### Claim 7 (depends on 6) The system of claim 6, wherein the label characterizing the new PD further comprises the one or more cut-offs. ### Claim 8 (depends on 1) The system of claim 1, wherein the user provides a name for the label characterizing the new PD. ### Claim 9 A business performance measurement and prediction method providing a user an ability to produce a business intelligence (BI) performance dimension (PD) in a geo-spatial database, wherein a dimension is defined as a structure to categorize data in the geo-spatial database, wherein a PD is a dimension characterizing data based on a performance of said data, according to one or more business rules, over a time period, wherein the system provides the user an ability to readily access the PD or a nonperformance dimension (NPD) via a drill path, the method comprising: (a) providing the geo-spatial database comprising a plurality of data records storing business data, wherein each data record is categorized by a unique combination of one or more dimensions, wherein each data record comprises one or more data attributes, wherein a data attribute is business related to an interval of time and a series of points in time, wherein data characterized by each data attribute has a numeric value; (b) specifying a set of criteria on which to base a new PD via a display interface (“PD wizard”) operatively coupled to the geo-spatial database, wherein the set of criteria comprises a selected dimension, a selected data attribute, a selected time period, and one or more selected business rules, (c) extracting a set of data adhering to the set of criteria, wherein the new PD comprises the set of data, (d) storing the new PD to each of the data records, wherein the new PD is labeled according to the set of criteria used to extract the new PD; and (e) exposing performance results by creating a new drill path for the new PD by creating a hierarchical order of the selected dimensions by listing (without programming), wherein a plurality of drill paths may exist in the geo-spatial database for a plurality of PDs and NPDs, Wherein, for example, a prediction of a trend of the selected data attribute can be assembled in the drill path comprising the new PD. ### Claim 10 (depends on 9) The method of claim 9, wherein the set of criteria comprises a plurality of data attributes. ### Claim 11 (depends on 9) The method of claim 9, wherein the one or more pre-defined business rules are grouped by time comparisons, statistics, or rolling periods. ### Claim 12 (depends on 11) The method of claim 11, wherein the set of pre-defined business rules grouped by time comparison are configured to compare a performance of the unique data set during a first user defined time period to a performance during a second user defined time period. ### Claim 13 (depends on 11) The method of claim 11, wherein the set of pre-defined business rules grouped by rolling periods are configured to calculate a performance of the unique data set over a user defined rolling period. ### Claim 14 (depends on 11) The method of claim 11, wherein the set of pre-defined business rules are further categorized, for user selection, by methods of count, percent or standard deviation, wherein Boolean logic is employed to allow the user to define one or more cut-offs for each method. ### Claim 15 (depends on 14) The method of claim 14, wherein the label characterizing the new PD further comprises the one or more cut-offs. ### Claim 16 (depends on 9) The method of claim 9, wherein the user provides a name for the label characterizing the new PD. ### Claim 17 A business performance measurement and prediction method providing a user an ability to produce a business intelligence (BI) performance dimension (PD) in a geo-spatial database, the method comprising: (a) providing the geo-spatial database comprising a plurality of data records, wherein each data record is categorized by a unique combination of one or more dimensions, wherein each dimension comprises one or more data attributes; (b) specifying a set of criteria on which to base a new PD via a display interface (“PD wizard”) operatively coupled to the geo-spatial database; (c) extracting a set of data adhering to the set of criteria, wherein the new PD comprises the set of data, (d) storing the new PD to one or more data records comprising data that adheres to the set of criteria; and (e) exposing performance results by creating a new drill path for the new PD by creating a hierarchical order of the selected dimensions by listing (without programming). ### Claim 18 (depends on 17) The method of claim 17, wherein the set of criteria comprises a plurality of data attributes. ### Claim 19 (depends on 17) The method of claim 17, wherein the one or more pre-defined business rules are grouped by time comparisons, statistics, or rolling periods. ### Claim 20 (depends on 17) The method of claim 17, wherein the user provides a name for the label characterizing the new PD.