Put together the SQL statement for the cube model query.
将多维数据集模型查询的sql语句组合起来。
Select the cube model on the Manage cube Models page.
在ManageCube Models页面上选择多维数据集模型。
Attributes from the slice of the cube model accessed by the query.
来自查询访问的多维数据集模型切片的属性。
The cube model contains a set of (dimension, join) references.
多维数据集模型包含一组(dimension,join)引用。
The following steps create a description of the cube model query.
以下步骤创建多维数据集模型查询的描述。
The query returns data aggregated at a single slice of the cube model.
查询返回的数据聚合在多维数据集模型的一个切片上。
A slice includes a level from a hierarchy of each dimension of the cube model.
一个切片包含来自多维数据集模型的每个维的层次结构的一个级。
The cube model can be seen as an abstraction of a star-join or snowflake-join schema.
多维数据集模型可以看作星形联结或雪花形联结模式的抽象。
You don't need to update the cube model since the model file has been configured correctly.
由于模型文件已经进行正确的配置，您就不必再更新多维数据集模型了。
But you should understand how to configure the cube model to support the globalization feature.
但是，您应该掌握如何配置多维数据集模型使之支持全球化特性。
The security model does not contain the actual definition of these OLAP objects—the cube model does.
安全模型并不包含这些OLAP对象的实际定义 —那是多维数据集模型的工作。
The amount of summarization is determined by the slice of the cube model that the query accesses.
汇总的数量取决于查询访问的多维数据集模型切片。
SQL queries can be constructed to retrieve OLAP data based on either the cube model or cube objects.
可以根据多维数据集模型或多维数据集对象构造SQL查询来获得OLAP数据。
Joins referenced by the cube model object, which join the dimensions in the query to the facts object.
将查询中的维联结到事实对象的多维数据集模型对象引用的联结。
This paper assumes the dimensions of the cube model have hierarchies of balanced type and standard deployment.
本文假设多维数据集模型的维具有平衡的层次结构和标准部署。
Convert the attributes and measures into SQL expressions, which are used to construct the SQL statement to query the cube model.
将属性和度量转换为SQL表达式，这些表达式用来构造对多维数据集模型进行查询的sql语句。
Most of the information required to generate queries against the data warehouse tables is stored in the cube model-related objects.
生成针对数据仓库表的查询所需的大多数信息存储在多维数据集模型相关对象中。
Review the detailed Information of the cube model and cubes imported after OLAP objects are successfully imported, as shown in Figure 11.
成功导入OLAP对象之后，检查导入的Cube模型和多维数据集的详细信息。
Cubes can be used when optimizing a cube model to specify the regions of the cube model that are the most active and the most important.
可以使用多维数据集对多维数据集模型进行优化，使它更适应最活跃、最重要的多维数据集模型区域。
The join objects in the cube model object are then used to join the tables of the facts with the tables of each of the dimension objects.
然后使用多维数据集模型对象中的联结对象将事实表与每个维对象的表联结起来。
Listing 1 gives an example of a SQL query based on a cube model and shows how the parts of the SQL statement map to the elements of the cube model.
清单1给出了一个基于多维数据集模型的SQL查询示例，并展示了sql语句的各个部分如何映射到多维数据集模型中的元素？
Because the security model depends on the cube model, you should design and deploy the cube model before designing and deploying the security model.
由于安全模型依赖于多维数据集模型，应该首先设计和部署多维数据集模型。
The cube models being queried should be valid according to the base rules and cube model completeness rules defined for the DB2 cube Views metadata.
按照基本规则和DB 2CubeViews元数据定义的多维数据集模型完整性规则，查询的多维数据集模型应该是有效的。
A cube can have only one cube hierarchy defined for each cube dimension, but a dimension can have many hierarchies that are defined for the cube model.
对于每个多维数据集维，一个多维数据集只能定义一个多维数据集层次结构；但是在多维数据集模型中，一个维可以有多个层次结构。
The aggregation for an empty list of dimensions is applied to all dimensions in the cube model that are not specifically being used by another aggregation.
维列表为空的聚合应用于多维数据集模型中没有被其他聚合使用的所有维。
These objects reference the facts, dimension, hierarchy, and level objects that are used in the cube model, and they are similar to these objects in the cube model.
这些对象引用多维数据集模型中使用的事实、维、层次结构和级对象，它们与多维数据集模型中的这些对象是相似的。
To create a grouping set at another slice of the cube model, create a new grouping set that includes, at a minimum, the level key attributes of each level in the new slice.
要在多维数据集模型的另一个切片上创建分组集，应该创建一个新的分组集，其中至少要包含新切片中每一级的级键属性。
The query model defines the concepts of dimension selections, edges, cube views, and the aggregations and manipulations of dimensional data.
查询模型定义维度选择、边界、立方体视图以及维度数据的聚合与操纵等概念。
The PY? format should only be used if model load time forms a significant part of the cube build times.
PY格式应该只有在模型加载时间占用了大部分分析构建时间的时候才使用。
The security metadata associated with the cube and dimension in the existing security model are kept in the resulting security model.
与现有安全模型中的多维数据集和维度关联的安全元数据保留在生成的安全模型中。
应用推荐