Abstract: Free form reports may be generated within a data array system such as a spreadsheet computer application. A user may select dimension members of a data source, such as an online analytical processing (OLAP) data cube. The user may position the dimension members as headers on the data array where multiple dimensions may be represented in one or both axes. Member formulas are generated that are representative of the headers and include identifiers that point to the dimension member location of the data source. Value formulas are generated within the report grid defined by the location of the headers where the value formulas are representative of the actual data values of the report and include identifiers that point to the data value locations of the dimension member locations within the data source.

Abstract: Architecture that employs a journal assignment that can be created on demand when journal is created, and operates outside the business cycle. The assignment is routed to reviewers and approvers based on predefined company policy that users define. The assignment encloses a changelist of data changes created by the journal. The changelist is used for rendition and calculation for reviewers and approvers (in addition to the journal contributor) to view/verify and modify the data as if the data is already written into the model. At the time that other users access this model, the data is not present. At the end of the successful workflow chain the changelist is written into the model. If failed, the changelist will be used as that basis for correction or the user can discard the changelist.

Abstract: Data processing architecture where submitters can write data and/or metadata changes to a destination through an asynchronous interface. The architecture includes a ticketing system that issues a ticket (a unique identifier) to the submitter in response to receiving a changelist from the submitter. When the changes are successfully completed at the destination, the cached destination data can be re-downloaded to the submitter, and the changes cached in the submitter, discarded. Absent this capability, a user has to manually manage the cached changes and cached data. The architecture can be distributed in that multiple submitters can submit changelists. The destination provides data integrity by managing submissions to assist in ensuring data integrity across multiple submissions. Automatic changelist cleanup is provided on the submitter so that changelists do not impact performance, memory, and storage.

Abstract: Embodiments are provided to use metadata to provide readable and/or writeable regions of a multi-dimensional space. In an embodiment, metadata can be used to define readable and/or writeable regions of a multi-dimensional data store. The various embodiments also use relational and/or multi-dimensional representations to resolve and validate readable and/or writeable regions of a multi-dimensional space. Metadata can also be used to in conjunction with writeback operations.

Abstract: Indirect persistent storage of data in a file that is associated with an application program and is capable of having an embedded OLEObject includes creating the OLEObject by way of a Component Object Model add-in that supplements the application program, and using the OLEObject to store the data in the file. The OLEObject is marked so that it is hidden from a user of the application program. After loading a file that was previously saved and closed, the OLEObject is initialized, and the stored data is retrieved. The add-in may be a reporting add-in that queries a database, such as an OLAP database.

Abstract: Tools and techniques are described for selecting member sets for generating asymmetric queries. User interfaces provided by this description may include representations of different dimensions that include respective members. These dimensions define hierarchical data structures against which queries are run to generate requested reports. The user interfaces may include representations of members associated with different dimensions, with members from different dimensions arranged in selected orders. The user interfaces may also provide selection tools that activate symmetrical or asymmetrical rendering modes for constructing the query. In the symmetrical rendering mode, the query cross-joins all of the members selected from one dimension with all of the members selected from the other dimension.

Abstract: A computer-implemented method includes selecting a first member of a first dimension of a database to be included at a first location in a report. The first member includes first data to be retrieved from the database. A blank space to be added at a second location relative to the first member is also selected. A database query is generated that includes a first instruction to retrieve first data included in the first member. The first instruction is located at a first position in the query and the first data will appear in the report at the first location. The database query also includes a second instruction to retrieve a null set of data. The second instruction is located at a second position in the query and the null set of data will appear in the report at the second location.

Abstract: When multiple contacts are detected for a phone number of an incoming call, a notification that multiple contacts matched the phone number is displayed. When the display area for displaying the notification is adequate to display a full list of the contacts that correspond to the phone number of the incoming call, the full list is displayed. When the display area is inadequate to display the full list, a scrollable list of the multiple contacts is displayed. Alternatively, when the display area is inadequate, a multiple contacts message is displayed that notifies a user that multiple stored contacts matched the phone number of the incoming phone call.

Abstract: An interface for designing a report is provided, with elements of the report being disposed at intersections of report positions and configured to present information derived from data in a database. A formula is associated with one or more selected elements in the report to generate a result for the one or more selected elements. A tuple identifying the report positions of the one or more selected elements is associated and stored with the formula in a formula list associated with the report. The report is configured so that, when the report is generated, it is determined whether identifying report positions corresponding to an identified element in the report correspond with the tuple in the formula list. Upon determining the tuple corresponds with the identifying report positions for the identified element, the formula associated with the tuple is applied to generate the result.

Abstract: Techniques to manage information for dynamic reports are described. An apparatus may comprise a business planning application module to update a current period reference to a time member of a time dimension, generate a rolling data entry form with actual data members and forecast data members based on the current period reference, and set a data locking mode for the actual data members and a data access mode for the forecast data members. Other embodiments are described and claimed.

Abstract: Embodiments are provided to use metadata to provide readable and/or writeable regions of a multi-dimensional space. In an embodiment, metadata can be used to define readable and/or writeable regions of a multi-dimensional data store. The various embodiments also use relational and/or multi-dimensional representations to resolve and validate readable and/or writeable regions of a multi-dimensional space. Metadata can also be used to in conjunction with writeback operations.

Abstract: Sharable extended cell information is used by multidimensional data models to enable cell annotations and line item details. Annotations are notes stored with a cell in a multidimensional dataset. Line item details permit levels of numeric detail below the lowest dimensional granularity. When receiving a multidimensional dataset in response to a query, a client application receives indicator information at the cell level, indicating to the client application that extended cell information is retrievable.

Abstract: A method and system provides reversibility of an operation performed by a user of an application program and associated with a modification to an object model of the application program, such as a spreadsheet program or other office productivity application program. The top item of a first undo stack associated with the application program is determined, saved, and copied to a second stack functioning as a replicated undo stack. According to one aspect of the invention, such steps are performed prior to calling an object model method that clears the first undo stack. The top item of the second replicated undo stack is placed back onto the first undo stack.

Abstract: A computer-implemented method includes selecting a first member of a first dimension of a database to be included at a first location in a report. The first member includes first data to be retrieved from the database. A blank space to be added at a second location relative to the first member is also selected. A database query is generated that includes a first instruction to retrieve first data included in the first member. The first instruction is located at a first position in the query and the first data will appear in the report at the first location. The database query also includes a second instruction to retrieve a null set of data.

Abstract: RDL (report description language) is an XML-based schema that has been designed and extended for standardizing report generation and maintenance. Reports can be generated that allow inspection of data that can come from several sources. The data can come from several arbitrary data sources, which can then be obtained and displayed using RDL. Implementations are provided for creating a mechanism to define how to present to end-users existing data, indicate where writing is possible, capture the user input, and later submit the changed data back to the data repository. Accordingly, a “Form” is defined, which provides a “report with data entry” areas.

Abstract: When multiple contacts are detected for a phone number of an incoming call, a notification that multiple contacts matched the phone number is displayed. When the display area for displaying the notification is adequate to display a full list of the contacts that correspond to the phone number of the incoming call, the full list is displayed. When the display area is inadequate to display the full list, a scrollable list of the multiple contacts is displayed. Alternatively, when the display area is inadequate, a multiple contacts message is displayed that notifies a user that multiple stored contacts matched the phone number of the incoming phone call.

Abstract: Methods of providing (1) additional functionality and/or (2) accessibility to user functions in a software application program are disclosed. Computer readable medium having stored thereon computer-executable instructions for performing methods of providing (1) additional functionality and/or (2) accessibility to user functions in a software application program are disclosed. Further, computing systems containing at least one application module, wherein the at least one application module comprises application code for performing methods of (1) additional functionality and/or (2) accessibility to user functions in a software application program are disclosed.

Abstract: Free form reports may be generated within a data array system such as a spreadsheet computer application. A user may select dimension members of a data source, such as an online analytical processing (OLAP) data cube. The user may position the dimension members as headers on the data array where multiple dimensions may be represented in one or both axes. Member formulas are generated that are representative of the headers and include identifiers that point to the dimension member location of the data source. Value formulas are generated within the report grid defined by the location of the headers where the value formulas are representative of the actual data values of the report and include identifiers that point to the data value locations of the dimension member locations within the data source.

Abstract: Data cells in a spreadsheet report are collapsed and expanded without disrupting other spreadsheet data. A user may want to drill down on data corresponding to a parent member of the report to display more detailed information about the parent member. Likewise, a user may want to drill up the displayed information corresponding to the parent member to hide detailed information associated with the parent member. Before expanding or collapsing a report, the spreadsheet is scanned for information to determine whether the display of other data in the spreadsheet would be disrupted by the expansion/collapse. The information may include cross-join information associated with the parent member, the number of child members associated with the parent member, the dimension of the report created by the parent member and the associated child members, and other reports that may be linked to the report that includes the parent member.

Abstract: Current cell values are provided to a client using two-passes. When a first request to provide values is received during a first pass, default values are provided to the client. Upon receiving each value request, the formula parameters are collected that are associated with the cell. The formula parameters are parsed to determine data that is to be retrieved from a database. Once the locations for all of the data to be retrieved has been determined, the data is retrieved from a database in as few as hits as possible. After obtaining the current values from the database, the client is informed to request the values a second time. When the second request to provide values is received, the client is provided with the calculated values during the second pass.