Abstract: 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.

Abstract: Embodiments are directed to determining a data insertion point in a data layout based on relative cardinalities between data objects and to determining a data insertion point in a data layout based on defined hierarchies between data objects. In an embodiment, a computer system receives a user input indicating that an additional portion of information is to be added to an existing data layout which includes multiple different data objects. The computer system accesses the data objects to determine relative cardinalities between the data objects in the data layout. The computer system determines an optimal data insertion point for inserting the additional portion of information based on the determined relative cardinalities between the data objects. The computer system also inserts the additional portion of information in the existing data layout at the determined optimal data insertion point.

Abstract: A computer output display system is provided. The system includes a layout component to determine one or more rendering rules that are applicable to a subset of display output controls. A format component communicates the rendering rules via a generic protocol that is employed by the subset of display output controls to render a display.

Abstract: 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.

Abstract: Resizing and/or repositioning a target object related by containment to one or more related object laid out on a computer user interface. Original sizes and/or positions of the related objects to the target object resized and/or repositioned are stored. During the resize and/or reposition operation of the target object, an impact on a related object is calculated based upon a change from the stored original sizes and/or positions of the related object.

Abstract: Embodiments are directed to determining a data insertion point in a data layout based on relative cardinalities between data objects and to determining a data insertion point in a data layout based on defined hierarchies between data objects. In an embodiment, a computer system receives a user input indicating that an additional portion of information is to be added to an existing data layout which includes multiple different data objects. The computer system accesses the data objects to determine relative cardinalities between the data objects in the data layout. The computer system determines an optimal data insertion point for inserting the additional portion of information based on the determined relative cardinalities between the data objects. The computer system also inserts the additional portion of information in the existing data layout at the determined optimal data insertion point.

Abstract: Embodiments are directed to determining a data insertion point in a data layout based on relative cardinalities between data objects and to determining a data insertion point in a data layout based on defined hierarchies between data objects. In an embodiment, a computer system receives a user input indicating that an additional portion of information is to be added to an existing data layout which includes multiple different data objects. The computer system accesses the data objects to determine relative cardinalities between the data objects in the data layout. The computer system determines an optimal data insertion point for inserting the additional portion of information based on the determined relative cardinalities between the data objects. The computer system also inserts the additional portion of information in the existing data layout at the determined optimal data insertion point.

Abstract: 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.

Abstract: Comparing data items. The method includes accessing a query or command to retrieve data. The query or command includes an identification of a data item, a logical operator and a specialized token. A comparison as defined by the logical operator between the data item and the specialized token is performed. The following illustrates the results of the logical operation on any data item and the specialized token: an equal logical operation results in true, a greater than logical operation results in false; a less than logical operation results in false; a greater than or equal to logical operation results in true; a less than or equal to logical operation results in true; a not equal logical operation results in false; an IN logical operation results in true; and a NOT IN logical operation results in false. As a result of the comparison, the data item may be retrieved.

Abstract: Embodiments are directed to determining a data insertion point in a data layout based on relative cardinalities between data objects and to determining a data insertion point in a data layout based on defined hierarchies between data objects. In an embodiment, a computer system receives a user input indicating that an additional portion of information is to be added to an existing data layout which includes multiple different data objects. The computer system accesses the data objects to determine relative cardinalities between the data objects in the data layout. The computer system determines an optimal data insertion point for inserting the additional portion of information based on the determined relative cardinalities between the data objects. The computer system also inserts the additional portion of information in the existing data layout at the determined optimal data insertion point.

Abstract: Embodiments are directed to implementing hierarchy metadata to improve relational model default path selection heuristics. A computer system receives a database query from a user. The query is configured to return a portion of requested data stored in the database. The database includes multiple different data entities related to each other via different relationship paths. The computer system accesses hierarchy metadata that describes various database hierarchies, each hierarchy including multiple data entities. The computer system determines an optimal path between the related data entities based on the database query and the hierarchy metadata, and accesses the data using the determined optimal data entity relationship path.

Abstract: Various technologies for processing a selection on an item on a report. In one implementation, a request to perform an action on the item may be received. Whether one or more actions corresponding to the item exist based on one or more parameters and one or more values of the parameters associated with the item may be dynamically determined. A list of one or more actions may be displayed if the one or more actions exist.

Abstract: 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.

Abstract: 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.

Abstract: Generating a report involves phases such as (a) database queries or other raw data accesses, (b) calculations such as data grouping, sorting, filtering, aggregation, (c) data presentation layout, (d) data formatting, and (e) rendering. When generating a modified version of a report, reusable interim results for phases (b), (c), and (d) are identified and retrieved from a cache instead of being recalculated. Newly calculated interim results are also cached for possible future use.

Abstract: 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.

Abstract: Various technologies and techniques are disclosed that improve the retrieval or interaction with data in databases. A database has one or more tables with compound keys. An entity key that is a single composite key of each of the compound keys is generated via an invertible composition transformation. The composite entity key is a binary serialization of the respective compound keys. The composite entity key is used by separate applications to interact with the database instead of the respective underlying compound keys. The composite entity key is decomposed into the underlying compound keys when a particular database operation needs to be performed. The results are then returned to the separate application with the composite entity key.

Abstract: 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.

Abstract: 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.