Business Objects Software Limited

Sap France S.a.

Sap France

Pierre Jean Le Brazidec

Florent Migeon

David Guillemet

Stéphane Defauconpret

Stéphane Debart

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

Guichen, France

Pierre Jean Le Brazidec