Method and system for guiding drilling in a report generated by a reporting system
First Claim
Patent Images
1. A system for guiding a user'"'"'s drilling into a report, the report formed through combining a template with a filter and including a plurality of dimensions, the system comprising:
- a report server for managing reports;
drill transformation tools accessible to the report server for allowing a user to drill within a first dimension or from the first dimension to a second dimension, the drill transformation tools including means for receiving information including a report instance and a user'"'"'s drilling selection and means for processing the information to produce a transformed drill instance; and
drill map management tools accessible to the report server for managing stored information related to each report, the stored information including drill map associated with a report, the drill map containing a sequence of available drill paths for that report to facilitate drilling, the available drill paths providing actions to generate a new, valid report definition based on data available in the database and one or more criteria that specify under what circumstances that drill path may be applied; and
wherein the report server identifies the drill map for a report instance and checks the criteria for drill paths in the drill map to reject drill paths that do not satisfy those criteria based on properties of a report instance being generated by the report server.
5 Assignments
0 Petitions
Accused Products
Abstract
A method and system for guiding drilling into a report are disclosed. Through the use of the invention, a user can drill within a first report dimension or from the first report dimension into a second report dimension. Additionally, a drill map providing a plurality of drilling paths is associated with each report. The system of the invention includes drill transformation tools and drill map management tools for assisting a user in navigating through report instances.
-
Citations
19 Claims
-
1. A system for guiding a user'"'"'s drilling into a report, the report formed through combining a template with a filter and including a plurality of dimensions, the system comprising:
-
a report server for managing reports;
drill transformation tools accessible to the report server for allowing a user to drill within a first dimension or from the first dimension to a second dimension, the drill transformation tools including means for receiving information including a report instance and a user'"'"'s drilling selection and means for processing the information to produce a transformed drill instance; and
drill map management tools accessible to the report server for managing stored information related to each report, the stored information including drill map associated with a report, the drill map containing a sequence of available drill paths for that report to facilitate drilling, the available drill paths providing actions to generate a new, valid report definition based on data available in the database and one or more criteria that specify under what circumstances that drill path may be applied; and
wherein the report server identifies the drill map for a report instance and checks the criteria for drill paths in the drill map to reject drill paths that do not satisfy those criteria based on properties of a report instance being generated by the report server. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A method for guiding a user'"'"'s drilling into a report, the method comprising the steps of:
-
receiving information including a report instance and a user'"'"'s selection on a report instance;
receiving a user'"'"'s drilling request;
identifying a drill map for the report instance based on the drilling request, the drill map including one or more drill paths and one or more criteria that specify under what circumstances each drill path may be applied; and
checking the criteria for drill paths in the drill map to reject drill paths that do not satisfy those criteria based on properties of a report or drill instance being generated by the report server to thus generate a revised drill map;
offering the user a drilling choice, the drilling choice including a report server selection option in which a report server selects at least one drill path based on the revised drill map for the report, the drilling choice further including a self-selection option in which the user specifies the drilling path;
creating a new report definition based on the received drilling choice; and
executing a new report based on the new report definition. - View Dependent Claims (12, 13, 14, 15)
accessing a drill map for the report instance if the user selects the report server selection option, the drill map including a sequence of drill paths;
providing a user with a selection of drill paths, the selection including at least one possible drill path.
-
-
13. The method of claim 11, further comprising the step of constructing a drill instance to hold a drill transformation result upon receiving a user'"'"'s drilling request.
-
14. The method of claim 13, further comprising the step of populating the drill instance.
-
15. The method of claim 11, further comprising the step of allowing the user to drill both within a first dimension and between the first dimension and a second dimension.
-
16. A method for guiding a user'"'"'s drilling into a report, the method comprising the steps of:
-
receiving information including a report instance and a user'"'"'s selection on a report instance;
receiving a user'"'"'s drilling request;
accessing a drill map associated with the report instance, the drill map including a sequence of drill paths and for at least one of the drill paths, one or more criteria that specify under what circumstances that drill path may be applied;
providing a user with a selection of drill paths, the selection including at least one possible drill path through a process that includes the act of checking for drill paths in the drill map to reject drill paths that do not satisfy those criteria based on properties of a report or drill instance being generated by the report server;
receiving a path selection from the user;
creating a new report definition based on the received user selection; and
executing a new report based on the new report definition. - View Dependent Claims (17, 18)
-
-
19. A method of guiding a user'"'"'s drilling into a report, the method comprising the steps of:
-
receiving information including a report instance and a user'"'"'s selection on a report instance;
receiving a user'"'"'s drilling request;
accessing a drill map, the drill map having been constructed by an expert capable of guiding the user through an investigation, the drill map including a sequence of drill paths and for at least one of the drill paths, one or more criteria that specify under what circumstances that drill path may be applied;
providing the user with a selection including at least one drill path selected from the drill map through a process that includes the act of checking for drill paths in the drill map to reject drill paths that do not satisfy those criteria based on properties of a report or drill instance being generated by the report server; and
creating and executing a new report definition based on the selection.
-
Specification