Microsoft Technology Licensing, LLC

Hai Huang

Peter Eberhardy

Ying Li

Zhaohui Tang

Xiaohong Mark Yang

Zhenyu Tang

Lakshmi Narayanan Thanu

Rong Jian Guan

Sridharan Ramanathan

George Randall Dong

Jeffrey Wang

Patricia O'Connor Sebelsky

The present web service platform includes a set of application program interfaces (APIs) and a framework for adding services that correspond to the APIs. The web service platform may also support a stored procedure (sproc) that allows combining results from two or more services before transmitting results to an application. The services relate to keyword technologies.

Web service platform for keyword technologies

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.

Extended cell information in multidimensional data models

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.

Generating free form reports within a data array

Growing community of inventors

Redmond, WA, United States of America

Hai Huang