您要查找的是不是:
- In a snowflake schema, only primary dimension tables are joined to the fact table. 在雪花型架構中,只有主維度表才與事實數據表聯接。
- The wizard generates a relationship between the column for each parent attribute and the primary key of the dimension table. 嚮導將生成每個父屬性的列與維度表的主鍵之間的關係。
- In other words, a dimension must be based on a single dimension table directly related to a fact table. 也就是說,維度必須基於與事實數據表直接相關的單個維度表。
- Between the key attribute and each non-key attribute bound to columns in the main dimension table. 在鍵屬性與綁定到主維度表中各列的每個非鍵屬性之間定義。
- For example, the following table defines a dimension table for a time dimension. 例如,下表定義了時間維度的維度表。
- To make a regular hierarchy appear ragged, set a HideMemberIf property of a level to an appropriate value for the underlying dimension table. 若要使規則層次結構變得不規則,請將某個級別的HideMemberIf屬性設置為相應的基礎維度表值。
- For each dimension, the Schema Generation Wizard generates a dimension table to be included in the subject area database. 對於每個維度,架構生成嚮導都會生成一個要包含在主題區域資料庫中的維度表。
- The fact table for that measure group contains a foreign key column that references members in the dimension table for the Organization dimension. 該度量值組的事實數據表包含一個外鍵列,該列引用了Organization維度的維度表中的成員。
- The fact table for that measure group contains a foreign key column that references the currency identifiers in the dimension table for that dimension. 該度量值組的事實數據表包含一個外鍵列,該外鍵列引用該維度的維度表中的貨幣標識符。
- For example, you might create five data flows, each copying data from a flat file into a different dimension table in a data warehouse star schema. 例如,可以創建五個數據流,每個數據流都將數據從平面文件複製到數據倉庫星形架構中的不同維度表中。
- The wizard generates one relationship for each regular dimension relationship from the fact table to the dimension table's granularity attribute. 嚮導會為每個從事實數據表到維度表的粒度屬性的常規維度關係生成一種關係。
- In a snowflake schema in a data warehouse, a dimension table that is directly related to and usually joined to the fact table. 在數據倉庫中的雪花架構中,直接與事實數據表相關並通常聯接到事實數據表的維度表。
- Finally, construct the logical model of data market by using multidimensional techniques, and study the design of fact table and every dimension table. 最後,採用多維技術建立了數據集市的邏輯模型,並且對事實表和各個維表的設計進行了研究。
- With SQL Server, this paper designs E-R model for Yeshu palm drinking sale including fact table for drink sale and dimension table for drink sale. 本文以SQL Server為工具,進行椰樹飲料銷售的E-R模型設計,包括飲料銷售事實表和飲料銷售維表。
- An intermediate dimension table is in turn joined to both the intermediate fact table and to the fact table on which the measure group specified by the relationship is based. 中間維度表接著同時聯接到中間事實數據表和該關係指定的度量值組所基於的事實數據表。
- Fact table has four columns, and has relationships to two dimension tables, as shown in the following table. 事實數據表有四列,並且與兩個維度表有關係,如下表所示。
- On the Identify Fact and Dimension Tables page, select Time in the Time dimension table list, and then click Next. 在「標識事實數據表和維度表」頁的「時間維度表」列表中,選擇Time,然後單擊「下一步」。
- Dimension tables contain information about those measures, such as the product that was sold, the month in which it was sold, and so on. 維度表包含有關這些度量值的信息,如售出產品、售出該產品的月份等。
- The disease is still in its primary stage. 這疾病仍然在初發階段。
- These attributes appear as attribute hierarchies and can be organized into user-defined hierarchies, or can be defined as parent-child hierarchies based on columns in the underlying dimension table. 這些屬性顯示為屬性結構,並且可以組織成用戶定義層次結構,或者可以基於基礎維度表中的列定義為父子層次結構。