USER INTERFACE FOR PIVOT VIEWS

摘要

An aspect of the present disclosure enables a user to specify a first pivot view as a publisher upon change of a criteria for selection of data points, and a second pivot view as a subscriber upon occurrence of the change. When an event representing a change of the criteria in the first view is detected, both the first view and the second view are updated reflecting the change in the selection criteria. According to another aspect of the present invention the formation of elements of a pivot view is based a GROUP BY and a ROLLUP construct. According to yet another aspect, a user can modify the axis for a pivot chart, and an updated chart, corresponding to the modified axis, is displayed.

主权项

1. A method of displaying pivot views from data stored in base tables, the method comprising:
enabling a user to specify a first pivot view as a publisher upon change of a criteria for selection of data points, and a second pivot view as a subscriber upon occurrence of the change; sending for display the first view and the second view; detecting occurrence of an event representing the change of the criteria in the first pivot view; selecting data elements from a base table constrained by the changed criteria; and updating both the first view and the second view based on the selected data elements in response to the detecting.