Microsoft Technology Licensing, LLC

Mark Xiaohong Yang

Patrick John Baumgartner

Peter Eberhardy

LuMing Wang

Rou-Peng Huang

Baomin Li

Zhenyu Tang

Pablo Jose Barvo

Rajeev V Karunakaran

Malik Hussain

Zaiwei Du

Amer Shahnawaz

George Yan

Jin Wang

Anton Amirov

Peiyuan Yan

Alisson A S Sol

Rohan Shetty

Alisson Sol

Jonathan Tang

Randy Dong

Kevin Robert Schmidt

Scott Sebelsky

Peter Bull

Gordon Goetsch

Steven L Hoberecht

Architecture for handling large data selections with small and substantially constant memory footprints. The architecture facilitates the creation of sets of data objects (e.g., rows) of a data source based on selection of the data objects. The set structures can be defined according to a range (span) of data objects selected and a pattern of the objects selected. These set structures are then saved in memory, rather than the data objects, to provide optimized memory usage. In a database implementation, the solution stores the set representation (the structure) in nearly a constant amount of memory, regardless of the number of rows in the grid, and regardless of the number of rows selected. Memory usage can be proportional to the number of discontinuous spans of rows selected by the user. Structures in memory can be consolidated, replaced, or eliminated dynamically as the user changes row selections and pattern criteria.

Scalable selection management

Techniques to implement time intelligence for application program are described. An apparatus may include a calendar application module. The calendar application module may be arranged to define and generate a calendar for an application program, the calendar application module to define time members for a time dimension of a multidimensional data model, assign a monotonically increasing unique identifier to each time member, and generate the calendar with time members from the time dimension using the unique identifiers. Other embodiments are described and claimed.

Time intelligence for application programs

Architecture includes for translating server calculations into client application formulas. The architecture determines dependencies, performs formulae translation, and processes data retrieval queries using the translated formulae. In one implementation, the architecture translates performance management server calculations into spreadsheet application formulas so that the impact of changes can be reflected immediately. Moreover, this technique does not require updating and querying of the performance management server. An algorithm is provided that allows translation of the backend formula (e.g., MDX&#x2014;multidimensional expressions) directly into the spreadsheet application such that the impact on calculated values by an input change can be reflected instantaneously in the sheet.

Spreadsheet formula translation of server calculation rules

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.

Maintaining client data integrity in a distributed environment using asynchronous data submission

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.

Techniques to manage information for dynamic reports using time periods for a business model

Computer-readable storage media, computer-implemented methods, and systems are disclosed for a multi-platform calculation rule language and its environment. A calculation rule, presented in an expression language and specifying one or more functions, is received. The expression language, for a plurality of different platforms, allows each of a plurality of functions to be expressed using a common syntax. A selected platform is identified on which the calculation rule is to be executed. The calculation rule is resolved to the attributes of the data model in the selected platform to apply the calculation rule to the data model. The calculation rule is executed by performing the one or more functions specified in the calculation rule, and the results from executing the calculation rule are reported.

Multi-platform business calculation rule language and execution environment

Architecture for cell-based security on a per-user basis. A security model for this capability includes not only dimension level tables, but is extended to include cell level tables. The security model can include existing dimension tables, plus cell security tables that include a cell permissions table, a cell qualifiers table and a table that includes both the cell permissions table, a cell qualifiers. Metadata associated with the security applied to the cells for a given user can be stored locally in a local metadata store for retrieval and application against a data cube that an authenticated and authorized user is querying. In a specific implementation, the cell level security is employed in a performance management server application, where authentication is performed remotely by an authentication service, but the authorization function is performed local to the performance management server application.

Cell-based security representation for data access

Computer-implemented methods and computer-readable storage media are disclosed to facilitate the application of business rules. A rule is received, the rule defining one or more calculations to be performed on specified data stored in a multidimensional database to yield at least one result. At least one database query is generated seeking the specified data to be retrieved from the multidimensional database. An intermediary table is created to accommodate the specified data retrieved from the multidimensional database. The specified data is stored in the intermediary table and the specified data is manipulated when the data is retrieved or after the specified data is stored in the intermediary table.

Advanced techniques for SQL generation of performancepoint business rules

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.

Rendering database queries with blank space

Growing community of inventors

Sammamish, WA, United States of America

Mark Xiaohong Yang