If a dimension name from a depending cube is not found in the other cube, that dimension is simply added to the virtual cube without any merging.
如果一个数据集中的维度不存在另一个数据集中,那么该维度将直接添加到虚拟数据集中,而不进行合并。
A star join query typically involves a fact table and several dimension tables, with join predicates between the fact table and each dimension table.
一个星型连接查询通常包含一个事实表和几个维度表,事实表和每个维度表之间都有连接谓词。
One advantage of the snowflake dimension is the space savings, because you normalize your dimension tables.
雪花式维度的优势之一是,因为规范化了维度表而实现了空间节省。
To set a default member for a dimension, add that dimension to the model, and then set the default member property.
为了设置维度的默认成员,需要将该维度添加到模块,然后设置默认成员的属性。
If the query was written by adding a dimension followed by a fact and then another dimension, then the database optimization would include the materialization as necessary.
如果查询的创建是通过先添加维度再添加事实表然后又添加维度的方式构成,那么数据库优化则必须包含实体化。
If the default member is not explicitly set on the virtual dimension, the default is the dimension from the first cube selected to compose the virtual cube.
如果没有在虚拟维度上显式地设置默认成员,那么默认值就是选择用于构成虚拟数据集的第一个数据集的维度。
You can define the many-to-one relationships among members within a dimension table as a separate dimension table, forming a hierarchy.
您可以将一个维度表中成员之间多对一的关系定义为一个单独的维度表,从而形成层次结构。
The optimizer will recognize this index and use the filters on the dimension tables to generate a list of valid combinations of the dimension tables' keys into a temp table.
该优化器将可以识别出这个索引,在维度表上使用过滤器来在一个临时表中生成一个维度表键的有效组合列表。
Let us now theoretically suppose there are two or more Universes overlapping in a simple way that one spatial dimension coincides with Einstein's time dimension of all others, respectively.
现在我们从理论上假设有两个或更多的宇宙重叠在一起,重叠的方式很简单,一个空间维度恰巧分别碰上所有其它宇宙的爱因斯坦时间维度。
You can define security on the measures dimension in addition to a non-measures dimension.
除了非度量维度之外,您还可以在度量维度上定义安全性。
For each (dimension, hierarchy, level) set in the query, determine the attributes from the dimension to be in the query.
对于查询中的每个(维、层次结构、级)集,判断使用哪些维属性。
Now that you understand the process for both the dimension and fact tables, let's look at a real world example to explore how to identify the dimension and measures from the business requirements.
既然您理解了维度和事实表的处理,就让我们看一看真实世界的例子,以探索如何从业务需求中识别维度和测度。
Another design approach is a snowflake dimension, in which you normalize the dimensions to create dimension tables that link to other dimension tables.
另一个设计方法是雪花式维度,通过规范化维度,来创建关联到其他维度表的维度表。
The following steps will illustrate how to build a simple multi-fact model that incorporates a manually created time dimension based on a time dimension table found in the underlying database.
下面的步骤将介绍如何创建一个简单的多事实模型,其中包括一个基于底层数据库的时间维度表手动创建的时间维度。
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.
对于每个多维数据集维,一个多维数据集只能定义一个多维数据集层次结构;但是在多维数据集模型中,一个维可以有多个层次结构。
In a follow-up article, we will address specifically how to take the next steps in developing the method dimension together with the process dimension — i.e., capability patterns.
在后续文章中,我们将明确的指出在后面的步骤中如何结合开发过程维度和方法维度-例如,能力模式。
Depending on how your dimensions are created, there are many ways to get to this new dimension, e.g. create it in the same TI process as the original dimension.
根据您创建维度的方式,有多种方式可以达到这个新维度,例如,使用与创建原维度所用的同一TI流程创建该维度。
The attributes of a dimension or facts object are columns or column expressions on the set of joined tables that comprise the dimension or facts object.
维对象或事实对象的属性是组成维对象或事实对象的联结表上的列或列表达式。
Although each dimension is composed of several ele-ments, most studies center on one element within each dimension.
尽管每一个维度都由几个因素构成,但是大多数的研究是关注在每一个维度中的某一个因素。
All users who do not belong to a role with explicit authorization on the dimension are members of the default role, and they are able to access the dimension according to the default policy.
只要用户不属于对维度具有显式授权的角色,它就属于默认角色的成员,可以根据默认策略访问该维度。
One of the steps of processing the attributes of each dimension is identifying which attributes from each dimension are to be selected as columns in the SQL statement.
处理每个维的属性的步骤之一是,识别出在sql语句中选择哪些维属性作为列。
In a star join plan, the database server pushes down keys from a dimension table to filter the fact table at the same time as it builds the hash table on the dimension table.
星型连接计划中,数据库服务器在维度表中构建散列表的同时从维度表中下推键来过滤事实表。
For example, in the relationship expression between the time dimension and the fake fact, a filter can be applied to reduce the records from the time dimension to just a few days.
例如,在时间维度和伪事实的关系表达式中,可以使用过滤来将时间维度缩小到几天之内。
Dimension queries are member selections that operate on the members of a single dimension.
维度查询是对单维度成员操作的成员选择。
RMC makes a clear distinction between the method dimension and process dimension.
RMC明确了方法维度与过程维度的区别。
It is made up of a facts object, which represents the fact table, and a set of dimension objects, representing the dimension tables.
它由一个事实对象(代表事实表)和一组维对象(代表维表)组成。
The horizontal dimension of this matrix is men's Professional Sports Organizations; the vertical dimension lists cities in the Northeast region.
水平维度是男子职业体育机构;竖直维度列出东北地区的城市。
Identify the dimension that contains the Boolean logic and de-select that dimension from the data model.
找到包含Boolean逻辑的维度,并在数据模型中取消选择。
Otherwise, you add along the primary dimension, producing an new array of reduced dimension. For example.
不然,您得到的是第一维的和,并生成一个降低了维数的新数组。
Otherwise, you add along the primary dimension, producing an new array of reduced dimension. For example.
不然,您得到的是第一维的和,并生成一个降低了维数的新数组。
应用推荐