63 results about "Pivot table" patented technology

The present invention relates to a new type of structured name within a spreadsheet program that allows users to refer to tables, columns of data within tables, headers of tables, totals from tables, PivotTables®, and portions of PivotTable® data by the data's headers. Embodiments of the present invention comprise a method for referring to a set of data that comprises receiving one or more semantic designations, wherein the one or more semantic designations name a set of context information that describes one or more items of data in a data structure, automatically creating a structural reference, and associating the context information with the structural reference. Other embodiments of the present invention relate to an interaction with a user interface for displaying on a display device a structural reference to data in a spreadsheet that comprises receiving one or more semantic designations from the user that refer to one or more elements of the data structure, creating a structural reference to the elements of the data structure, and displaying the structural reference as a collection of the one or more semantic designations.

A data analysis method is disclosed. The method comprises aggregating related data tables with dissimilar data structures, and combining the tables, and data structures, into a single table that incorporates all the individual data structures. The single table is then analyzed via a pivot table function of a spreadsheet program, such as Microsoft Excel. The method is suited for quickly comparing related but dissimilar sets of data—an important task in virtually every field of human endeavor, from manufacturing to health care to financial services. The present invention provides an improved way to quickly access important strategic information using multiple sources of data.

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.

Tools for configuring an enterprise applications. In one aspect, the tools provide a user interface to allow an implementer describe, based on an interview with executives of the organization, an enterprise structure of an organization, and a data structure generator to configure the enterprise application to reflect this enterprise structure. In one aspect, these tools can allow a general case to guide the default assignment of intersections of legal and managerial reporting structures to a business unit, allowing the minimum number of business units to fulfill both the external and managerial responsibilities. The tools may implement a pivot table approach to provide an interface for the user to provide such input.

System and method of simultaneously creating and managing a plurality of OLAP cubes in real time, each from a different tabular data source, comprising, for each cube, defining the table columns as either dimensions or measures of the cube using at least one of predefined semantics and data formats, generating the cube using said defined dimensions and measures, updating the cube when the respective data source is modified and deleting the cube according to predefined criteria.

The invention provides a method for using page-based object flow verification in a regression test, which comprises the following steps: recording a test automation script operated by a functional flow, and generating an object pivot table from different pages according to the operation sequence of a main functional flow; during the execution of a new round of regression test, generating an object historical table of an operation page of the function value; and contrasting the pivot table with the object historical table to determine whether the pivot table and the object historical table have differences in the same functional page and the sate and sequence of the same object and generating and outputting a test difference report. The invention provides a device for using the page-based object flow verification in the regression test. The invention can greatly reduce time for manual test and increase in the test number due to frequency program correction, ensures program quality and avoids test risks.

A pivot analysis with an XML/XSL mechanism is disclosed. The pivot analysis is utilized to acquire the raw data from a relational database and then the raw data is converted into a XML data by a pivot transformation mechanism. Furthermore, the XSL/XSLT mechanism is configured to modify the XML data and thus the post processing of the pivot tables, for instance, a row calculation and a column calculation can be performed.

The present invention leverages curve fitting data techniques to provide automatic detection of data anomalies in a “data tube” from a data perspective, allowing, for example, detection of data anomalies such as on-screen, drill down, and drill across data anomalies in, for example, pivot tables and/or OLAP cubes. It determines if data substantially deviates from a predicted value established by a curve fitting process such as, for example, a piece-wise linear function applied to the data tube. A threshold value can also be employed by the present invention to facilitate in determining a degree of deviation necessary before a data value is considered anomalous. The threshold value can be supplied dynamically and/or statically by a system and/or a user via a user interface. Additionally, the present invention provides an indication to a user of the type and location of a detected anomaly from a top level data perspective.

Various methods, systems and storage devices are used for creating and utilizing an analysis view for pivot table interfacing. The analysis view can be created with a visualization that reflects data summarized in the pivot table automatically in response to detecting user input directed at a particular data field (i.e., cell) of the pivot table and without requiring any additional user input, such as user input required to navigate a chart wizard or any other graphics interface. The visualization includes at least one selectable and transient object that is configured for being selected and dragged out of the analysis view window and which persists even after the analysis view window is closed, unless it is first dragged outside of the boundaries of the analysis view window and without requiring additional user input for separately closing and/or removing the transient object.

Systems, methods, and software are disclosed herein for enhanced pivot table creation and interaction. In an implementation, a view including a formula bar is rendered in a user interface to a spreadsheet application. In response to receiving a user initialization input, the view is rendered to hide the formula bar and display a configuration bar configured to receive at least one pivot table parameter. A pivot table is generated based on the at least one pivot table parameter. The view is rendered to display the formula bar after generation of the pivot table.

This invention relates to graphical user-interactive analysis of data, including in particular, mass spectrographic data analysis, as well as methods and software for generating and using such. One aspect provides user-customizable reports, including methods and apparatuses for generating customizable pivot tables and graphs specific to mass spectrographic data.

A drill press with pivot table(s) includes a support column and a collar disposed on an outer periphery of the support column. The outer periphery of the support column and the collar delimit a first groove therebetween. A base connects to the support column. The outer periphery of the support column and the base delimit a second groove therebetween. A pivotal device is movable relative to the support column. The pivotal device has various fixed pivoting and sliding positions relative to the support column. A first work platform connects to the pivotal device. The first work platform is movable relative to the pivotal device. A second work platform connects to the pivotal device. The second work platform is movable relative to the pivotal device.

The therapeutic system provides an oscillatory, pivoting table for applying motion-induced therapeutic sensory stimuli to a user. Further, therapeutic audio and visual output may be provided to the user during the application of the therapeutic sensory stimuli. The therapeutic system includes a base having an upper vertex. A tabletop is pivotally mounted to the upper vertex of the base, and the upper surface of the tabletop is adapted for supporting the user. At least one piston is provided, with the lower end thereof being mounted within the base, and the upper end thereof being pivotally mounted to a lower surface of the tabletop in order to pivot the table with respect to the base in a controlled, oscillatory manner. Oscillation of the table at a user-controlled frequency and angle induces the therapeutic sensory stimuli in the user.

Provided is a method for executing a query in a DBMS. The method may include: receiving a query statement for requesting BLOB data serialized to a binary large object (BLOB) type and stored in a pivot table; determining name information for one or more columns generated as a result of a pivot operation included in respective pivot columns of the pivot table by querying a pivot name table for the pivot table; determining internal storage type information of the pivot table by querying a pivot meta table for the pivot table; and generating output information for the BLOB data corresponding to the query statement based on the determined name information and internal storage type information.

The invention provides a multidimensional data presentation device, comprising a data model setting module and a blink line processing module, wherein the data model setting module is used for setting a data model for a table cell in a pivot table and storing the number and content of blank lines which are arranged before and/or behind the cell table in the data model, and the blank line processing module is used for inserting the blank lines according to the number of the blank lines before and behind a data line when the data line selected by a user comprises a specific cell table and filling the blank lines according to the content of the blank lines. The invention also provides a multidimensional data presentation method. By adopting the multidimensional data presentation device and the multidimensional data presentation method which are disclosed by the invention, the pivot table can be presented more flexibly, and the customer requirements can be met better.