User interface for a multi-dimensional data store
First Claim
1. A system for enforcing data integrity during editing of a multi-dimensional data store comprising:
- a server facility further comprising an application program, and a multi-dimensional data store in the form of a planning data repository with an associated calculation engine capable of both back-solving and forward-solving;
a client computer further comprising an application having the ability to show data derived from said database, and to request changes to the data to be made at said database; and
a network interconnecting the server and the client.
4 Assignments
0 Petitions
Accused Products
Abstract
The invention provides a means of interacting with a subset of a large amount of related information that assists in providing a user with the overall understanding necessary to execute rapid and knowledgeable decision-making. It consists of a spreadsheet-like client application which interacts with a planning data repository (PDR) and its associated computing resources. All of the data used in computing the values shown in the spreadsheet cells are derived directly from the PDR. Any changes made by the user to the displayed data are sent to the PDR and, when validated, incorporated into the overall data following a two-step process of ‘calculate’ and ‘save’. At the user'"'"'s desktop machine, the user views a window which contains information temporarily stored locally within the client computer for use by a script application. Not all of the information stored for the script application is necessarily visible on the display at any one time, and scroll bars are provided to permit the user to view information stored but not currently visible. The data shown on the client computer screen may be a representation of a planning cube (or data cube) that is a subset of the Planning Data Repository data. In a further embodiment of the invention the user is able to change the various relationships amongst the data and these alterations sent to the PDR for computation.
38 Citations
16 Claims
-
1. A system for enforcing data integrity during editing of a multi-dimensional data store comprising:
-
a server facility further comprising an application program, and a multi-dimensional data store in the form of a planning data repository with an associated calculation engine capable of both back-solving and forward-solving;
a client computer further comprising an application having the ability to show data derived from said database, and to request changes to the data to be made at said database; and
a network interconnecting the server and the client. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A method of enforcing data integrity during editing of a multi-dimensional data store in a system with a server operably coupled to a planning data repository, and a calculation engine capable of both back-solving and forward-solving, and a client computer containing a browser application, all interacting over one or more networks, the method comprising the steps of:
-
a. providing a spreadsheet-like display containing data for use by said method;
b. the browser obtaining data from the planning data repository;
c. in response to a user action, the browser sending a “
Request Calculate”
to the server, the requested calculation requiring the calculation engine to use back-solving;
d. the server obtaining from the calculation engine the result of the calculation;
e. the server passing the result received from the calculation engine to the browser;
f. the browser displaying the results of the changes;
g. in response to a user action, she browser sending a “
Request Save”
to the server; and
h. the browser receiving an Acknowledgement of a successful Save. - View Dependent Claims (12, 13, 14)
-
-
15. A method of enforcing data integrity during editing of a multi-dimensional data store in a system with a server operably coupled to a planning data repository, and a calculation engine capable of both back-solving and forward-solving, and a client computer containing a browser application, all interacting over one or more networks, the method comprising the steps of:
-
a. providing a spreadsheet-like display containing data for use by said method;
b. the browser requesting data from the server;
c. the server requesting the data from the planning data repository;
d. the planning data repository responding to the request of step c from the server with the data and metadata;
e. the server reformatting the data and metadata;
f. the server responding to the request of step b with the data and metadata;
g. in response to a user action, the browser sending a “
Request Calculate”
to the server;
h. the server forwarding the “
Request Calculate”
message including changed data to a calculation engine, the requested calculation requiring the calculation engine to use back-solving;
i. the calculation engine performing a series of Requests for data from the planning data repository;
j. the calculation engine performing the required calculations using the changed data and the data requested from the planning data repository;
k. the calculation engine ensuring that the appropriate data is compatible with the data and rules pertaining to the data as contained in the planning data repository;
l. the calculation engine forwarding the result of the calculation to the server;
m. the server passing the result received from the calculation engine to the browser in the format required;
n. the browser displaying the effect of the changes resulting from the calculation engine implementing the “
Request Calculation”
message;
o. in response to a user action, the browser sending a “
Request Save”
to the server;
p. the server forwarding the “
Request Save”
message including changed data to a calculation engine;
q. the calculation engine updating the planning data repository with data changed as a result of the Request Calculation;
r. the calculation engine sending an “
Acknowledge”
message to the server confirming successful completion of the “
Request Save”
; and
s. the server forwarding the Acknowledgement of successful completion to the browser. - View Dependent Claims (16)
-
Specification