| 摘要 |
A system generates linked sets of drill-down-enabled reports of increasing levels of detail from one or more databases. Linking relationships between reports are defined using the query language of the databases. Result sets are obtained that includes (1) the sought-after data, and (2) metadata that identifies drill-down reports to be generated if related report elements are selected. When the query is executed, the system passes the sought-after data to a reporting application programming interface, which generates a report (e.g., a pie chart, 3-D bar chart, cross-tabbed table). If an end-user selects one of the report elements (e.g., a bar on the chart), the system maps the reported event to the associated data of the result set. If the associated data has corresponding meta-data containing a drill-down directive, the system then generates the report identified by the drill-down directive.
|
