Systems and methods to dynamically recognize a database member identifier entered into a spreadsheet cell
AssigneeSAP France S.A.
InventorsPierre Jean Le Brazidec, Florent Migeon
Life of this patent
Estimating the term…
Abstract
According to some embodiments, a system, method, means, and/or computer program code are provided to facilitate use of a spreadsheet application to access information stored in a multi-dimensional data source. Some embodiments include receiving, at an analyzer module, a change indication from the spreadsheet application, the change indication being associated with an identifier entered by a user into a spreadsheet cell. In response to the change indication, a member associated with the identifier in a multi-dimensional data source may be dynamically determined. Information in the spreadsheet may then be replaced with a formula based at least in part on the determined member.
Claims24
A non-transitory computer-readable medium having stored thereon processor-executable instructions, to facilitate use of a spreadsheet application to access information stored in a multi-dimensional data source, that when executed by a processor result in the following:
- pre-loading, at an analyzer module, information associated with a plurality of member names of the multi-dimensional data source;
- after said pre-loading, receiving, at the analyzer module, a change indication from the spreadsheet application, the change indication being associated with a portion of a member name entered by a user into a spreadsheet cell, wherein the pre-loaded information is not displayed in any spreadsheet cell before the change indication is received;
- in response to the change indication, dynamically determining a member in the multi-dimensional data source having a name matching the portion of the member name entered by the user;
- and
- replacing information in the spreadsheet with a formula based at least in part on the determined member.
A system, comprising:
- a database storing information about a plurality of members, including member names;
- a spreadsheet component, including a processor executing instructions to:
- receive from a user at least a portion of a name entered into a first cell, and
- generate a change event in response to the at least a portion of the name received from the user;
- and
- a spreadsheet add-in component, including the processor executing instructions to:
- pre-load information associated with a plurality of member names from the database,
- after the pre-load is performed, receive the change event from the spreadsheet component, wherein the pre-loaded information is not displayed in any spreadsheet cell before the change event is received,
- dynamically determine a member of the database have a name matching the at least a portion of the name received from the user;
- and
- replace content in a second spreadsheet cell with data from the database based on the determined member, wherein the second cell is different than the first cell.
A method to facilitate a display to a user of information associated with members stored in an external database, comprising:
- pre-loading, at an analyzer add-in, information associated with a plurality of member names of the external database;
- receiving, at the analyzer add-in, a change indication from a spreadsheet application, the change indication being associated with a first name entered by a user into a spreadsheet cell, wherein the pre-loaded information is not displayed in any spreadsheet cell before the change indication is received;
- in response to the change indication, dynamically matching the first name with a second name of a member of an external database;
- and
- replacing the first name in the spreadsheet cell with content generated based on the matched member.
Dependencies are inferred from the claim text.