Microsoft Technology Licensing, LLC

Other

Akshai Mirchandani

Marius Dumitru

Amir Netz

Paul Jonathon Sanders

Cristian Petculescu

Mosha Pasumansky

Alexander Berger

Howard J Dickerman

Yutong (Jeffrey) Wang

Richard R Tkachuk

C James MacLennan

Ioan Bogdan Crivat

Thomas P Conlon

Thulusalamatom Krishnamurthi Anand

Edward Melomed

Irina Gorbach

Raman S Iyer

Adrian Dumitrascu

Rong Jian Guan

Thierry D'Hers

Andriy Garbuzov

Aleksandar Juric

Chu Xu

Valeri Kim

Sergei Gringauze

Methods and systems are disclosed for receiving and processing data analysis expressions. A particular method includes receiving a data analysis expression at a pivot table of a spreadsheet. The data analysis expression is executed for a particular cell of the pivot table by determining a context associated with the particular cell, calculating a value of the data analysis expression based on the context, and outputting the calculated value at the particular cell.

Data analysis expressions

Computer-readable media, systems, and methods for building a multidimensional data cube having one or more high-cardinality attributes are described. In embodiments, data is extracted from one or more databases. It is determined that one or more instances of the data are fact data and one or more instances of the data are dimension data. Each member of the fact data is one instance of a dimension and each instance of the dimension data includes an attribute for grouping the fact data. Moreover, in embodiments it is determined that one or more instances of the dimension data are high-cardinality attributes. The one or more high-cardinality attributes are processed with fact data and stored in fact tables on a computer storage medium.

Multidimensional data cubes with high-cardinality attributes

A system and techniques for executing queries of a sparse multidimensional data space in the presence of expressions. A dimension is associated with a set of data references, which reference stored data items. A query expression has dimension or a data reference as an operand. A result space with one or more result dimensions is defined based on the query. A plan is built and executed for retrieving the stored data items associated with the result dimensions, and forming 'calculated data items' by evaluating the expression. Executing the plan produces a stream of data tuples, each having a set of data components storing the retrieved data items and/or the calculated data items. Data components are either empty or have data values. An iterative algorithm is employed on the stream to locate the data tuples that are empty at the intersection of each result dimension.

Multidimensional data space queries with expression evaluation

Systems and methods that supply extensibility mechanisms for analysis services, via a plug-in component that enables additional functionalities. The plug-in component provide additional custom logic for the analysis services unified dimensional model (UDM). Accordingly, server functionalities can be extended in an agile manner, and without a requirement for a new release, for example.

Extensibility mechanism for analysis services unified dimensional model

The subject invention pertains to systems and methods for interacting with fact dimensions. In particular, systems and methods are disclosed that optimize performance and scalability with respect to processing queries that involve fact dimensions. Furthermore, queries involving fact dimensions can be evaluated in distinct manners. For instance, queries can be processed such that regular dimensions restrict the scope of the data and only fact dimension members that are relevant to that scope are exposed.

Fact dimensions in multidimensional databases

The subject invention relates to systems and methods that extend the network data access capabilities of mark-up language protocols. In one aspect, a network data transfer system is provided. The system includes a protocol component that employs a computerized mark-up language to facilitate data interactions between network components, whereby the data interactions were previously limited or based on a statement command associated with the markup language. An extension component operates with the protocol component to support the data transactions, where the extension component supplies at least one other command from the statement command to facilitate the data interactions.

Systems and methods of utilizing and expanding standard protocol

Custom grouping for dimension members of an On-Line Analytical Processing (OLAP) cube is facilitated by an interface component that receives a grouping from a user. A modification component alters an attribute of a session OLAP data cube or a virtual OLAP multi-dimensional data cube so that the change becomes readily available without the time-consuming delay associated with rebuilding or reprocessing the underlying structure. A data scheme generation component produces a data definition language (DDL) definition of a user defined attribute executed by an execution component to affect the change to a data cube. Custom groupings can provide an intermediate dimension level for drill down and/or drill up or roll-up between a level with few members and a level with numerous members. A separate dimensional attribute or level can be created and a group defined comprising or mapping a set or collection of discrete members.

Custom grouping for dimension members

A calendar customization system comprises an interface component that receives responses to one or more questions relating to a calendar. A execution automatically generates a multi-dimensional structure for the calendar, the structure generated as a function of the responses. For example, the multi-dimensional structure can relate to a Gregorian calendar, a fiscal calendar, a reporting calendar, a manufacturing calendar, and/or an ISO8601 calendar.

System that facilitates maintaining business calendars

Growing community of inventors

Redmond, WA, United States of America

Akshai Mirchandani