维度层次结构中的分割可以在不同的级别上出现。
Splits in the dimension hierarchies can occur at different levels.
然而,对于维度,这就肯定不正确了,因为维度层次结构的结构可能变得复杂。
For the dimensions, however, this is certainly not true because the structure of dimension hierarchies can potentially get complicated.
维度层次结构的设计不存在捷径;需要与业务用户紧密合作并清楚了解其数据。
There are no magic shortcuts to designing dimension hierarchies; it requires working with your business users and understanding their data.
您所要面对的最重要的设计决策之一,是如何捕获维度表的层次结构信息。
One of the most important design decisions you face is how to capture hierarchy information in a dimension table.
维度的基本结构就是层次结构。
要查看包含所有可用维度、层次结构和成员的虚拟数据集结构的完整视图,您可以使用DesignStudio的维度浏览器。
For a full view of the virtual cube structure that includes all available dimensions, hierarchies, and members, you can use Design Studio's dimension browser.
审批层次结构是 plan_department维度的AllDepartments子集。
The approval hierarchy is the subset All Departments of the dimension plan_department.
克服其他维度限制(例如,顶层元素的索引号、并行层次结构中不同的级别,等等)。
Overcome other dimensional limits (e.g. index number of a top-level element, different number of levels in parallel hierarchies, etc.).
雪花型模型是一个或多个维度的分解结果,它们自己有时具有层次结构。
The snowflake model is the result of decomposing one or more of the dimensions, which sometimes have hierarchies themselves.
一个通常难以做出的重要决策就是一个聚集层是否真正是(结构化)层次结构的一个元素,或它是否仅仅是维度中一项的属性。
An important and often difficult decision to make is whether an aggregation level actually is an element of a (structural) hierarchy, or whether it simply is a property of an item in the dimension.
例如,如果有两种方式实现产品回滚,那么需要在维度表(见表1 )中支持两种层次结构。
For example, if you have two ways of rolling up products, then you need to support both hierarchies in the dimension tables (see Table 1).
维度建模最重要的活动之一就是捕获聚集路径或终端用户执行上卷和下钻所依照的聚集层次结构。
One of the essential activities of dimension modeling is to capture the aggregation paths or aggregation hierarchies along which end users perform roll-up and drill-down.
您可以将一个维度表中成员之间多对一的关系定义为一个单独的维度表,从而形成层次结构。
You can define the many-to-one relationships among members within a dimension table as a separate dimension table, forming a hierarchy.
合并的业务数据可以沿着所有维度中的层次结构预先进行聚合,从而减少构建OLAP报告所需的运行时计算。
The consolidated business data can be pre-aggregated along with the hierarchies in all dimensions to reduce the runtime calculation for building the OLAP reports.
分解的雪花型结构很好地展示了维度的层次结构。
The decomposed snowflake structure visualizes the hierarchical structure of dimensions very well.
当选定来自两个数据集的维度以便合并之后,将在为每个维度定义的默认层次结构合并维度。
Once the dimensions from both cubes are selected for merging, the merging happens on the default hierarchies defined for each dimension.
合并进程根据两个维度遍历层次结构的级别(从0级别开始),并合并包含相同名称的级别。
The merge process iterates through the levels of the hierarchies from both dimensions, beginning at level zero, and merges levels that have identical names.
单击Next,单击Valuestouse旁边的省略号(…),然后选择Years维度下面的Years层次结构。
Click Next, click the ellipsis (...) beside Values to use, and then select the Years hierarchy under the Years dimension.
采用“三层次—三维度”的课程结构;
To adopt the course construction of three levels and three dimensionalities.
第二,从不同维度和层次对税收政策作用于产业结构的机理进行了深入的剖析;
Second, analysing the mechanism of tax policy in the industrial structure from a different dimension and level.
在下一个图中,“雇员”维度具有名为“按组织结构分类的雇员”层次结构。
In the next illustration, the employee dimension has a hierarchy named employees by organization structure.
网络结构从微观层面的节点维度和宏观层面的整体维度两个层次上影响知识流动。
The network structure impacts on knowledge flows from node dimensions in the micro-level and overall dimensions in the macro-level.
网络结构从微观层面的节点维度和宏观层面的整体维度两个层次上影响知识流动。
The network structure impacts on knowledge flows from node dimensions in the micro-level and overall dimensions in the macro-level.
应用推荐