Describing a query on a cube model.
描述多维数据集模型上的查询。
Select the cube model on the Manage cube Models page.
在ManageCube Models页面上选择多维数据集模型。
Put together the SQL statement for the cube model query.
将多维数据集模型查询的sql语句组合起来。
The cube model contains a set of (dimension, join) references.
多维数据集模型包含一组(dimension,join)引用。
The following steps create a description of the cube model query.
以下步骤创建多维数据集模型查询的描述。
Attributes from the slice of the cube model accessed by the query.
来自查询访问的多维数据集模型切片的属性。
This paper illustrates how to configure the multilingual cube model.
本文描述了如何配置多语言多维数据集模型。
The query returns data aggregated at a single slice of the cube model.
查询返回的数据聚合在多维数据集模型的一个切片上。
Predicates can be applied to any attribute of a dimension in a 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.
由于模型文件已经进行正确的配置,您就不必再更新多维数据集模型了。
You are prompted to select a database when you import the file containing your cube model.
当您导入包含多维数据集模型的文件时,系统将提示您选择一个数据库。
A cube model is built to represent a data structure and relationship in an OLAP data mart.
多维数据集模型代表OLAP数据市场中的数据结构和关系。
But you should understand how to configure the cube model to support the globalization feature.
但是,您应该掌握如何配置多维数据集模型使之支持全球化特性。
The amount of summarization is determined by the slice of the cube model that the query accesses.
汇总的数量取决于查询访问的多维数据集模型切片。
The security model does not contain the actual definition of these OLAP objects—the cube model does.
安全模型并不包含这些OLAP对象的实际定义 —那是多维数据集模型的工作。
SQL queries can be constructed to retrieve OLAP data based on either the cube model or cube objects.
可以根据多维数据集模型或多维数据集对象构造SQL查询来获得OLAP数据。
This file is separate and different from the file that is created when you export your cube model.
该文件与导出多维数据集模型时创建的文件不同且单独存在。
Once the optimization (such as MQTs) is created for a cube model, all the cubes derived from it benefit.
在为多维数据集模型创建了优化(比如MQT)之后,从这个模型派生的所有多维数据集都会因此受益。
A cube model provides a new perspective for the information consumers from which to understand their data.
多维数据集模型让信息消费者能够从一个新的视角理解数据。
This paper assumes the dimensions of the cube model have hierarchies of balanced type and standard deployment.
本文假设多维数据集模型的维具有平衡的层次结构和标准部署。
The join objects from the dimensions, facts, and cube model are used to form the join predicates of the WHERE clause.
来自维、事实和多维数据集模型的联结对象用来形成where子句的联结谓词。
To remove the security metadata associated with a cube in your cube model, use the Administration Console to do the following.
要删除多维数据集模型中与一个多维数据集关联的安全元数据,使用AdministrationConsole执行以下操作。
Convert the attributes and measures into SQL expressions, which are used to construct the SQL statement to query the cube model.
将属性和度量转换为SQL表达式,这些表达式用来构造对多维数据集模型进行查询的sql语句。
As in previous releases of Cubing Services, this database is used to authenticate users when they query the cubes in your cube model.
和上一版Cubing Services一样,这个数据库用于在用户查询多维数据集模型中的多维数据集时验证用户。
Most of the information required to generate queries against the data warehouse tables is stored in the cube model-related objects.
生成针对数据仓库表的查询所需的大多数信息存储在多维数据集模型相关对象中。
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.
然后使用多维数据集模型对象中的联结对象将事实表与每个维对象的表联结起来。
Review the detailed Information of the cube model and cubes imported after OLAP objects are successfully imported, as shown in Figure 11.
成功导入OLAP对象之后,检查导入的Cube模型和多维数据集的详细信息。
You might need to modify or re-export the security model if you modify your cube model by, for example, deleting or renaming dimensions.
如果您修改了多维数据集模型(比如删除或重命名维度),您可能需要修改或重新导出安全模型。
应用推荐