Subject | English | Chinese Taiwan |
comp., MS | changing dimension | 變更維度 (A dimension that has a flexible member structure, and is designed to support frequent changes to structure and data) |
comp., MS | data dimension | 資料維度 (A specific node created in the hierarchical view of the Tracking Profile Editor as an immediate child of the specific tracking profile in order to describe a logical grouping or dimension of data. Each data dimension is uniquely named and is made up of one or many data fields) |
comp., MS | dimension granularity | 維度資料粒度 (" The lowest level available to a particular dimension in relation to a particular measure group. The "natural" or physical grain is always that of the key that joins the main dimension table to the primary fact table.") |
comp., MS | dimension hierarchy | 維度階層 (A logical tree structure that organizes the members of a dimension such that each member has one parent member and zero or more child members) |
comp., MS | dimension level | 維度層級 (The name of a set of members in a dimension hierarchy such that all members of the set are at the same distance from the root of the hierarchy. For example, a time hierarchy may contain the levels Year, Month, and Day) |
comp., MS | dimension table | 維度資料表 (A table in a data warehouse whose entries describe data in a fact table) |
comp., MS | fact dimension | 事實維度 (A relationship between a dimension and a measure group in which the dimension main table is the same as the measure group table) |
comp., MS | formatting dimension | 格式化維度 (The dimension that numeric formatting is applied to) |
comp., MS | linked dimension | 連結維度 (A reference in a cube to a dimension in a different cube (that is, a cube with a different data source view that exists in the same or a different Analysis Services database). A linked dimension can only be related to measure groups in the source cube, and can only be edited in the source database) |
comp., MS | many-to-many dimension | 多對多維度 (A relationship between a dimension and a measure group in which a single fact may be associated with many dimension members and a single dimension member may be associated with a many facts. To define this relationship between the dimension and the fact table, the dimension is joined to an intermediate fact table and the intermediate fact table is joined, in turn, to an intermediate dimension table that is joined to the fact table) |
comp., MS | primary dimension table | 主要維度資料表 (In a snowflake schema in a data warehouse, a dimension table that is directly related to, and usually joined to, the fact table) |
comp., MS | reference dimension | 參考維度 (A relationship between a dimension and a measure group in which the dimension is coupled to the measure group through another dimension) |
comp., MS | role-playing dimension | 角色扮演維度 (A single database dimension joined to the fact table on a different foreign keys to produce multiple cube dimensions) |
comp., MS | shared dimension | 共用維度 (A dimension created within a database that can be used by any cube in the database) |
comp., MS | time dimension | 時間維度 (A dimension that breaks time down into levels such as Year, Quarter, Month, and Day) |