Patent ID: 8145990

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