Automatic Scoping of Data Entities
First Claim
1. A system for creating a report in a spreadsheet, the system comprising:
- a central processing unit; and
a memory encoding instructions that, when executed by the central processing unit, cause the central processing unit to create;
a data source module programmed to identify sources of data items associated with the spreadsheet;
an active module programmed to identify which of the data items are associated with the report that is generated in the spreadsheet; and
a display module programmed to display on a field pane with an active tab and an all tab, the active tab displaying those data items that are determined to be associated with the report that is being generated in the spreadsheet, and the all tab displaying all of the data items associated with the spreadsheet.
2 Assignments
0 Petitions
Accused Products
Abstract
A system for creating a report in a spreadsheet includes a data source module programmed to identify sources of data items associated with the spreadsheet, an active module programmed to identify which of the data items are associated with the report that is generated in the spreadsheet, and a display module programmed to display on a field pane with an active tab and an all tab, the active tab displaying those data items that are determined to be associated with the report that is being generated in the spreadsheet, and the all tab displaying all of the data items associated with the spreadsheet.
38 Citations
20 Claims
-
1. A system for creating a report in a spreadsheet, the system comprising:
-
a central processing unit; and a memory encoding instructions that, when executed by the central processing unit, cause the central processing unit to create; a data source module programmed to identify sources of data items associated with the spreadsheet; an active module programmed to identify which of the data items are associated with the report that is generated in the spreadsheet; and a display module programmed to display on a field pane with an active tab and an all tab, the active tab displaying those data items that are determined to be associated with the report that is being generated in the spreadsheet, and the all tab displaying all of the data items associated with the spreadsheet. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 11)
-
-
10. A method for generating a user interface for a spreadsheet, the method comprising:
-
identifying, by a computing device, a source for all data items associated with the spreadsheet; identifying which of the data items are associated with the report that is generated in the spreadsheet; and displaying an active tab and an all tab on a field pane, the active tab listing those data items that are determined to be associated with the report that is being generated in the spreadsheet, and the all tab listing all of the data items associated with the spreadsheet. - View Dependent Claims (12, 13, 14, 15, 16, 17, 18)
-
-
19. A method for generating a field pane for use in creating a data summary table in a spreadsheet, the method comprising:
-
identifying, by a computing device, a table and associated dimensions for each of the data items associated with the spreadsheet, the data items including data regions on the spreadsheet and data from external data stores; identifying which of the dimensions are incorporated into the data summary table in the spreadsheet; displaying an active tab listing all of the tables and associated dimensions for those dimensions that are included in the data summary table, the tables being displayed in an expanded format to show at least a portion of the dimensions associated with each table; allowing a user to select an all tab; and upon selection, displaying the all tab listing all of the tables and associated dimensions in the spreadsheet, the tables being displayed in a collapsed format so that the dimensions are hidden. - View Dependent Claims (20)
-
Specification