Microsoft Technology Licensing, LLC

Robert M Bruckner

Christopher Alan Hays

Fang Wang

Haroon Ahmed

David G Campbell

David Paul Hill

Patrick McKay

Jason David Carlson

John Herschel Vulner

Yoav Yassour

Boaz Chen

Andriy Garbuzov

Yury Berezansky

Victor Arakcheev

Dmitry Datsenko

Nader Nashed

Vit Karas

Various technologies pertaining to modifying visualizations are described herein. A client computing device requests a visualization from a server computing device, and the server computing device constructs the visualization responsive to receipt of the request. The server computing device further identifies anticipated transformations for the visualization, and transmits the visualization and the transformations to the client computing device. The client computing device displays the visualization, and responsive to receipt of a request to modify the visualization, executes a transformation provided by the server computing device to update the visualization.

Pre-fetch cache for visualization modification

A computer-implemented method for generating a report from a report definition specifying a plurality of data scopes for a dataset includes interpreting, with a processor, a report definition for the report, the report definition comprising a calculation expression for populating a unit of the report, the calculation expression comprising a data aggregation operation, the data aggregation operation comprising an originating reference to a further data scope, accessing a memory coupled to the processor to obtain data from the dataset for respective subsets of the dataset corresponding with the further data scope, determining, with the processor, an output value for the calculation expression in accordance with the obtained data and the data aggregation operation, and rendering the report based on the output value.

Data scope origination within aggregation operations

Embodiments render on a second data processing system, a result derived from a set of data by performing data processing across the first data processing system and a second data processing system. The amount of processing performed by the second data processing system can be dynamically adjusted. The first data processing system receives information indicating an amount of interface characteristics of the first data processing system as compared to interface characteristics of the second data processing system to be presented to a user. Data processing is dynamically allocated between the first data processing system and the second data processing system, based on an amount of interface characteristics of the first data processing system as compared to interface characteristics of the second data processing system to be presented to a user.

Dynamically adjusting brand and platform interface elements

A method includes acts for a method of rendering a result derived from a set of data by performing data processing across first and second data processing systems. The amount of processing performed by the second data processing system can be dynamically adjusted depending on business factors. The first data processing system receives information defining how the result will be rendered. The first data processing system receives information indicating at least one business constraints affecting at least one of the first data processing system or the second data processing system. The first data processing system determines data processing needed for providing the result. The first data processing system dynamically allocates the needed data processing between the first data processing system and the second data processing system, based on the business constraints affecting at least one of the first data processing system or the second data processing system.

Division of processing between systems based on business constraints

A method includes acts for rendering, on a data processing system, a result derived from a set of data by performing data processing across a first data processing system and a second data processing system. The amount of processing performed by the second data processing system can be dynamically adjusted depending on factors affecting the second data processing system. The first data processing system receives information defining how the result will be rendered at the second data processing system. The first data processing system receives information indicating factors affecting the second data processing system. The first data processing system dynamically allocates the needed data processing between the first data processing system and the second data processing system, based on factors affecting the second data processing system.

Division of processing between systems based on external factors

A reporting system is described herein that allows a report author to declare data reporting structures that specify to a reporting application how to dynamically categorize data with changing or potentially unknown characteristics. The reporting system may extend RDL and the data grouping provided by Microsoft SQL Server Reporting Services by adding new elements to the XML-based RDL schema. The reporting system allows the report author to specify for the system to fill gaps in the data, so that the report has a similar layout even as data changes from period to period. The reporting system also allows the report author to specify whether data that does not fit any predefined group bucket is displayed in a report. Thus, the reporting system allows unsophisticated database users to define reports that group data consistently regardless of missing values or other changes in the underlying data.

Reporting including filling data gaps and handling uncategorized data

Nested and grouped report data are aligned. A data-bound object such as a data region or an outer group serves as a data container having a domain scope. Instances of an inner group with misaligned data values are identified. The inner group instances are synchronized based on the data container domain scope, in response to a synchronization instruction in a report definition. During synchronization, data values are injected, and a synchronization group may be dynamically created. Aggregate functions are calculated over a synchronized group without regard to injected data values. A report layout is generated with synchronization visually indicated.

Dynamic expansion of data calculation scopes

Architecture which provides that certain data-bound objects in the report can be configured by the report author to use data from a specific query result rather than take data from the containing data bound object. The report author defines a relationship between the data in the contained object and the data in the container, allowing instances of the descendant object to be correlated with instances of the ancestor object. This relationship can be either explicit with join conditions or implicit due to an intrinsic hierarchical relationship between the query results.

Inline data correlation and hierarchical datasets

A rendering system is provided. The rendering system includes a rendering component that receives a request to view a data set and provide output to drive a display application. A processing engine generates output data for the rendering component, where the output data is suitable to satisfy a present demand to render a subset of the data set.

Request-driven on-demand processing

A data access system which includes the capability to categorize subsets of the data in the data store, query result or other source of data as aggregate data or as detail data and also the ability to explicitly re-categorize the aggregate data as detail data, e.g., as part of execution of one or more processes on the data, so that operations that apply to detail data also apply to the re-categorized aggregate data. Additionally, automatic processes are provided for re-categorizing aggregate data as detail data based on data usage context, i.e., based upon how data in the data store is to be manipulated, processed and/or presented according to queries, commands, etc. received by the data store. Calculation of aggregations on top of already pre-aggregated data is enabled, and merging of designated aggregate data with detail data provides increased flexibility in a final dataset.

Re-categorization of aggregate data as detail data and automated re-categorization based on data usage context

An object data manipulation system is provided. The system includes a definition object model that includes a set of dynamic group definitions over a data hierarchy. A cursor component points to a subset of the data hierarchy, where the subset is loaded into memory for further processing.

Growing community of inventors

Redmond, WA, United States of America

Robert M Bruckner