这可以使用查询钻取特性来完成。
按OK保存穿透钻取定义。
从该结果矩阵可以钻取行列细节。
From the result matrix you can drill down into row or column details.
这种“定向钻取”的优势如下
添加一个新的钻取定义。
下面的步骤说明如何使用查询钻取特性。
The steps below illustrate how to work with the Query Drill-Down feature.
从油砂中提炼石油比传统的钻取产生更多的碳排放。
Extracting oil from tar sands causes more carbon emissions than traditional drilling.
因此，穿透钻取的定义类似于HTML中的超级链接。
Thus drill-through definitions serve a similar aim as hyper links in HTML.
然后，可以钻取关于各个SELECT查询的详细信息。
“穿透钻取”的原始概念是指从聚合值导航到单独的记录。
The original concept of "drill-through" refers to the task of navigating from aggregate values to individual records.
要在收入报告中创建一个穿透钻取定义，还需执行下面的步骤
You have to perform the following steps to create a drill-through definition in the revenue report
如果还使用变量或参数，可以向报告添加一个强大的钻取功能。
If you also use variables or parameters, you can add a powerful drill-through functionality to the report.
一个钻取机通常有数十米长而且只能获取一个与之等长的冰芯。
A drill assembly is typically a few tens of metres long and can only hold a core of ice of the same length.
了解如何定义一个从报告1到报告2 的穿透钻取定义。
See how to define a drill-through definition from report one to report two.
要向skill列添加钻取定义，对skill列重复以上步骤。
To add a drill-through definition to the SKILL column, repeat the above steps for the SKILL column.
您可以在一个查询中钻取多层，以指定嵌套的谓词、子句和表达式。
You can drill down multiple levels in a query to specify nested predicates, clauses, and expressions.
现在，需要通过一个穿透钻取定义扩展第一个报告以便调用第二个报告。
Now, you have to extend the first report to invoke the second one through a drill-through definition.
这里的答案是对您感兴趣的数据类别使用钻取(drilldown)资源。
The answer here is to use the drilldown resource for the data category you are interested in.
如果要分析的实例数据量较小，您的向上钻取和向下钻取请求的响应性会很好。
With a small amount of instance data to analyze, your drill-up and drill-down requests will be very responsive.
数据用户主要查看汇总数据还是需要一种交互式体验（向下和向上钻取数据）？
Will users of the data mainly look at summarized data or require an interactive experience (drill up and down through the data)?
用户可以在执行报告时手动选择这些参数，或者另一个报告可以通过钻取定义添加它们。
Either the user can select them manually on report execution or another report can add them through drill-through definitions.
可以通过查询钻取特性收集关于系统上执行的每个sql语句的统计信息并分析语句历史。
Query drill down allows you to gather statistical information about each SQL statement executed on the system and analyze statement history.
利用报告中的超链接，可以钻取每条语句的细节，包括每条执行语句的语句文本和操作信息。
Using the hyperlinks in the report, you can drill down to the details of each statement, including the statement text and operation information for each execution statement.
现在，系统提示您只需提供两个参数，这是因为穿透钻取定义传递了第三个参数——该产品。
Now, you will be prompted for just two parameters because the third one - the product - is passed by the drill-through definition.
在图44所示的StatementType选项卡上，可以按照语句类型执行查询钻取。
The statement type TAB in Figure 44 allows you to perform the query drill down by statement type.
本系列的后续文章将展示如何使用穿透钻取定义完成一些更复杂事情，比如动态调用数据挖掘。
The upcoming articles of this series show how to do more powerful things with drill-through definitions, such as invoking data mining dynamically.
要使用户能够单击其中一个工作描述字段并查看完整的描述，完成以下步骤向列表添加一个钻取定义。
To enable the user to click on one of the job description fields and see the whole description, add a drill-through definition to the list by completing the following steps.
在穿透钻取定义中，这些参数可被定义为超级链接的一部分(就像在HTTPGET请求中一样)。
In a drill-through definition, these parameters can be defined as part of the hyperlink (just as in HTTP GET requests).
当一个节点在返回网格中被列出来时，就可以钻取(drilldown)到查询中，添加谓词和排序方式。
After a node is listed on the return grid, you can drill down into the query to add predicates and sorting preferences.
通过使用“穿透钻取”定义(其中包含一个由链接的上下文定义的参数)避免需要为每种职业单独定义一个链接。
By using a "drill-through" definition that contains a parameter defined by the context of the link, you do not need to create a link for each profession individually.
应用推荐