Patent ID: 8024650

Claim:
A system for drilling on at least one element in an arbitrary ad-hoc report, comprising: a memory including a first data element residing in a generated first ad-hoc report stored in said memory; and a computer configured to generate a second ad-hoc report containing a second data element as a response to receiving data associated with selection of the first data element, the computer configured to drill from the first data element to the second data element along a drill path upon receipt of the data associated with selection of the first data element, the drill path created dynamically as a response to receiving data associated with selection of the first data element, the drill path created by using an original query associated with the first data element and system-provided suggestions indicating a data element selection to create a drill path that obtains a desired result, a first context of the data element selection, and a granularity of a destination query associated with the second data element, wherein the first ad-hoc report is dynamically generated based on the original query, wherein the instruction associated with the first data element is received via a user interface, and wherein upon receipt of an instruction associated with selection of the first data element, a first filter is applied; and subtracting the first filter upon receiving second data indicating the selection of a return to the first ad-hoc report, a second context thereafter being associated with the first ad-hoc report.