The query subject wizard only works for standard SQL.
查询主题向导只适用于标准 SQL。
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.
可以在左侧和右侧各定义一个查询主题。
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.
它们或者不出现在模型查询主题中，或者是对用户隐藏的。
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过滤器中使用以下表达式。
For example, if a Query Subject is giving errors, the SQL Statement can be copied and pasted in one of these tools to validate the SQL Statement.
例如，如果Query Subject出现错误，那么可在这些工具中对sql语句进行复制与粘贴，来验证sql语句。
To implement a fake fact query subject, either create a one row table in the database or use a virtual table such as SYSDUMMY1 for DB2 or Dual for Oracle.
要实现伪事实查询主题，就要在数据库中创建一个一行的表格，或者使用虚拟表，例如SYSDUMMY1在DB 2中使用SYSDUMMY1，或者在Oracle中使用Dual。
Joining the keys will never be true in this case, but is required since IBM Cognos BI requires at least one item per query subject to create a valid join.
本例中连接键不会为true，但却是必需的，因为IBMCognosBI要求每个查询主题至少要有一项，以创建有效连接。
From the Framework Manager's main page, you are able to create a query subject to define the contents of your report. To do so, perform the following steps.
在FrameworkManager的主页上，可以创建一个查询主题以定义报告的内容。
The link line is no longer there between the keys since the relationship is now a complex expression that goes beyond linking items from one query subject to another.
键之间的连接行已经没有了，因为现在关系已经是一个复杂的表达式，而不是在查询主题之间连接项目那么简单。
For example, Figure 10 shows the query result of "Employee by position-department" by using the "Test Sample" button when no filter was set for this query Subject.
例如，图10显示没有对这个Query Subject设置过滤器时，使用“TestSample”按钮进行的“Employee byposition - department”查询的结果。
应用推荐