Business Objects Software Limited

Sap France S.a.

Sap France

Florent Migeon

Pierre Jean Le Brazidec

Sebastien Lavoignat

David Guillemet

Stéphane Debart

Stéphane Defauconpret

A computer-implemented method for disaggregating data in a spreadsheet or other data structure hosted on a client computing device includes providing an analyzer module as a plug-in or add-in to a spreadsheet application on a client computing device. The analyzer module locally performs disaggregation and aggregation processes on data in the spreadsheet on the client computing device. The method includes parsing, by the analyzer module, content entered in a subject cell of the spreadsheet to determine if sets of special syntax characters corresponding to a disaggregation instruction or command precede an amount in the entered content, and accordingly disaggregating or aggregating data in the spreadsheet.

Dynamic disaggregation and aggregation of spreadsheet data

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 multidimensional data source. Some embodiments include determining, at an add-in module, that a local member is to be attached to an attachment element of a report generated based on the multidimensional data source. The add-in module may receive a refresh indication from the spreadsheet application and dynamically update a reference in a spreadsheet cell based on a change associated with the attachment element.

Systems and methods to provide dynamic local members associated with an add-in for a spreadsheet application

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 multidimensional data source. Some embodiments include receiving, at an analyzer module, a change indication from the spreadsheet application. The change indication may be, for example, associated with a spreadsheet formula of the spreadsheet application entered by a user into a spreadsheet cell. In response to the change indication, the spreadsheet formula may be translated into a multidimensional expression calculation associated with the multidimensional data source. The spreadsheet formula in the spreadsheet cell may then be automatically replaced with information associated with the multidimensional expression calculation.

Systems and methods to create a multidimensional expression calculated member in a spreadsheet cell

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.

Growing community of inventors

Clichy, France

Florent Migeon