This is a filter applied against a Query Subject.
这个过滤器适用于查询主题。
The query subject wizard only works for standard SQL.
查询主题向导只适用于标准 SQL。
This will be the query subject you will use in the report.
这将是您将在报告中使用的查询主题。
To create the outlier table query subject used by the report.
为了创建报告使用的离群值表查询主题。
Your query subject definition should look similar to Figure 6.
查询主题定义看上去应该如图6所示。
To create the SKILL_OVERVIEW query subject, complete the following steps.
要创建SKILL_OVERVIEW查询主题,完成以下操作。
You can define a query subject on the left side and one on the right side.
可以在左侧和右侧各定义一个查询主题。
To create the cluster description query subject from the DB2 table function.
为了从db2表函数创建集群描述查询主题,您需要。
Next, create joins from the fake fact query subject to the required dimensions.
下一步,创建伪事实查询主题与所需维度的连接。
We can use Query Subject filters to restrict user access to the data source.
可以使用Query Subject过滤器限制对数据源的用户访问。
Either they are not included in the model query subject, or they are hidden from the user.
它们或者不出现在模型查询主题中,或者是对用户隐藏的。
Select your data source and un-check Run database query subject wizard, and click finish.
选择数据源,取消Rundatabasequery subjectwizard,单击Finish。
For example, only Transformer modelers would see the following in the Sales fact query subject.
例如,只有Transformer建模师将会在Sales事实查询主题中看到下面的结果。
For the left query subject, select the cluster id of the OutlierTable and set the cardinality to 1..
对于左边的查询主题,选择OutlierTable的集群id,并将基数设为1 . .。
A simple query subject that accesses the outlier table BANK.CUSTOMER_OL created in the first section.
一个简单的访问第一节中创建的离群值表BANK . CUSTOMER_OL的查询主题。
Add all query items from the CUSTOMER_OL query subject and change the names to more descriptive labels.
添加CUSTOMER_OL查询主题中的所有查询项,并将它们的名称改成更具描述性的名称。
This query subject contains the customer records together with the deviation degree and the cluster id.
这个查询主题包含客户记录和偏差度以及集群id。
For the left query subject, select the ID column of the SKILL_REPORT subject, and set the cardinality to 1..
对于左侧的查询主题,选择skill_report主题的id列,然后将基数设置为1 . .。
For the right query subject, add the JOBS query subject, select the ID column, and set the cardinality to 1..
对合适的查询主题添加jobs查询主题,选择id列,并将基数设置为1 . .。
On the "Select a data source" page, select DWESAMP and clear the Run database query subject wizard check box.
在 “Selectadatasource”页面上,选择DWESAMP,并取消对选择Rundatabasequery subjectwizard复选框。
For the right query subject, add the OutlierClusters query subject, select the ID column, and set the cardinality to 1..
对于右边的查询主题,添加OutlierClusters查询主题,选择id列,并将基数设为1 . .。
As shown in Figure 15 and Figure 16 the results for this Query Subject differs depending on the logged in user account.
登录的用户帐户不同,这个Query Subject的结果也不同,如图15和图16所示。
Using a stored procedure as query subject input has the advantage that no unnecessary tables or views are created in the database.
使用存储过程作为查询主题输入有一个好处,那就是不需要在数据库中创建不必要的表或视图。
Create a new query subject "OutlierClusters" in the PresentationView namespace and choose to model the query subject from a data source.
在PresentationView名称空间中创建一个新的查询主题“OutlierClusters”,并选择从一个数据源对该查询主题建模。
A query subject that USES a stored procedure to access the cluster information of the clustering model created by the mining algorithm.
查询主题使用存储过程访问由挖掘算法创建的集群模型的集群信息。
SKILL_OVERVIEW: The query subject containing all information from the SKILL_REPORT table joined with the job descriptions of the JOBS table.
SKILL_OVERVIEW:该查询主题包含 SKILL_REPORT表中所有与JOBS 表的职位描述相连接的信息。
Illustration 13 shows an external file linked to a query item in the Retailers query subject of an existing package called GO Sales (query).
图13显示链接到一个名为GOSales (query)的现有表的Retailers查询主题中的一个查询项的外部文件。
One example of implementing a prompt in a model is shown below in which the time dimension query subject has a filter added with prompt syntax.
以下就是在模型中实现提示的例子,其中时间维度查询主题通过提示语法添加了一个过滤。
The net result of the fake fact query subject will be to create a Cartesian Product for the dimensions, which returns in a shorter period of time.
伪事实查询主题的第二个作用是创建维度的笛卡尔积,它能缩短时间。
To allow a user to retrieve only specific data based on their logon information, we can use the following expression in the Query Subject filter.
要基于用户登录信息限制用户只能检索特定数据,可以在Query Subject过滤器中使用以下表达式。
应用推荐