这可以使用查询钻取特性来完成。
这种“定向钻取”的优势如下
参数的使用使穿透钻取成为真正强大工具。
What makes drill-through definitions a powerful tool is the use of parameters.
下面的步骤说明如何使用查询钻取特性。
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.
这些细菌是从格陵兰冰川冰中钻取的矿样中提取的。
The bugs were extracted from a core sample drilled from glacier ice in Greenland.
因此，穿透钻取的定义类似于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.
它有很多预定义的代理，还有一个控制台，允许钻取不同的问题。
It has many predefined agents, and a console that allows drill-down on individual issues.
要向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.
更长的冰芯将被切割成数段，同时钻取机带上各段返回地面。
Longer cores have to be drilled piece by piece, with the drill returning to the surface with each one.
这里的答案是对您感兴趣的数据类别使用钻取(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.
在本示例中，有一个针对每个产品的收入列表，借助它就能够穿透钻取特定产品的关联规则。
Within the report, you can enter parameters to change the mining parameters. In this example, a revenue-per-product list allows you to drill-through to association rules for the specific products.
在图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.
在示例中，您将显示一个包含钻取定义的职位招聘列表，以查看所选择的职位招聘的职位描述。
In the example, you will learn to display a list of job offerings with a drill-through definition to see the job description for the job offering that was selected.
曼迪·乔伊：泄露的还有丙烷和丁烷等气体，这些气体是在石油钻取过程中产生的。
Mandy Joye: and there's also propane and butane, and gases that derive from the same processes that make the oil.
曼迪·乔伊：泄露的还有丙烷和丁烷等气体，这些气体是在石油钻取过程中产生的。
Mandy Joye: and there's also propane and butane, and gases that derive from the same processes that make the oil.
应用推荐