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 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.

主权项

1. A non-transitory machine-readable storage medium having stored thereon processor-executable instructions, to facilitate use of a spreadsheet application to access information stored in a multidimensional data source, that when executed by a processor perform a method, the method comprising:
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 local member comprising a name property, a formula, an insert property, and an attached to property, wherein the insert property indicates if the local member is inserted before the attachment element or inserted after the attachment element and the attached to property indicates a combination of members of the report; receiving, at the add-in module, a refresh from the spreadsheet application; and in response to the refresh indication, dynamically updating, by the add-in module, a reference in a spreadsheet cell based on a change associated with the attachment element wherein the attachment element comprises the combination of members of the report and wherein dynamically updating comprises displaying the local member when the combination of members of the report appears in the spreadsheet application.