这可以使用查询钻取特性来完成。
按OK保存穿透钻取定义。
从该结果矩阵可以钻取行列细节。
From the result matrix you can drill down into row or column details.
这种“定向钻取”的优势如下
添加一个新的钻取定义。
参数的使用使穿透钻取成为真正强大工具。
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.
了解如何定义一个从报告1到报告2 的穿透钻取定义。
See how to define a drill-through definition from report one to report two.
它有很多预定义的代理,还有一个控制台,允许钻取不同的问题。
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.
在本示例中,有一个针对每个产品的收入列表,借助它就能够穿透钻取特定产品的关联规则。
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.
应用推荐