您要查找的是不是:
- In a snowflake schema, only primary dimension tables are joined to the fact table. 在雪花型架構中,只有主維度表才與事實(shí)數據表聯(lián)接。
- The wizard generates a relationship between the column for each parent attribute and the primary key of the dimension table. 向導將生成每個(gè)父屬性的列與維度表的主鍵之間的關(guān)系。
- In other words, a dimension must be based on a single dimension table directly related to a fact table. 也就是說(shuō),維度必須基于與事實(shí)數據表直接相關(guān)的單個(gè)維度表。
- Between the key attribute and each non-key attribute bound to columns in the main dimension table. 在鍵屬性與綁定到主維度表中各列的每個(gè)非鍵屬性之間定義。
- For example, the following table defines a dimension table for a time dimension. 例如,下表定義了時(shí)間維度的維度表。
- To make a regular hierarchy appear ragged, set a HideMemberIf property of a level to an appropriate value for the underlying dimension table. 若要使規則層次結構變得不規則,請將某個(gè)級別的HideMemberIf屬性設置為相應的基礎維度表值。
- For each dimension, the Schema Generation Wizard generates a dimension table to be included in the subject area database. 對于每個(gè)維度,架構生成向導都會(huì )生成一個(gè)要包含在主題區域數據庫中的維度表。
- The fact table for that measure group contains a foreign key column that references members in the dimension table for the Organization dimension. 該度量值組的事實(shí)數據表包含一個(gè)外鍵列,該列引用了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. 該度量值組的事實(shí)數據表包含一個(gè)外鍵列,該外鍵列引用該維度的維度表中的貨幣標識符。
- 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. 例如,可以創(chuàng )建五個(gè)數據流,每個(gè)數據流都將數據從平面文件復制到數據倉庫星形架構中的不同維度表中。
- The wizard generates one relationship for each regular dimension relationship from the fact table to the dimension table's granularity attribute. 向導會(huì )為每個(gè)從事實(shí)數據表到維度表的粒度屬性的常規維度關(guān)系生成一種關(guān)系。
- In a snowflake schema in a data warehouse, a dimension table that is directly related to and usually joined to the fact table. 在數據倉庫中的雪花架構中,直接與事實(shí)數據表相關(guān)并通常聯(lián)接到事實(shí)數據表的維度表。
- Finally, construct the logical model of data market by using multidimensional techniques, and study the design of fact table and every dimension table. 最后,采用多維技術(shù)建立了數據集市的邏輯模型,并且對事實(shí)表和各個(gè)維表的設計進(jìn)行了研究。
- 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為工具,進(jìn)行椰樹(shù)飲料銷(xiāo)售的E-R模型設計,包括飲料銷(xiāo)售事實(shí)表和飲料銷(xiāo)售維表。
- 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. 中間維度表接著(zhù)同時(shí)聯(lián)接到中間事實(shí)數據表和該關(guān)系指定的度量值組所基于的事實(shí)數據表。
- Fact table has four columns, and has relationships to two dimension tables, as shown in the following table. 事實(shí)數據表有四列,并且與兩個(gè)維度表有關(guān)系,如下表所示。
- On the Identify Fact and Dimension Tables page, select Time in the Time dimension table list, and then click Next. 在“標識事實(shí)數據表和維度表”頁(yè)的“時(shí)間維度表”列表中,選擇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. 維度表包含有關(guān)這些度量值的信息,如售出產(chǎn)品、售出該產(chǎn)品的月份等。
- The disease is still in its primary stage. 這疾病仍然在初發(fā)階段。
- 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. 這些屬性顯示為屬性結構,并且可以組織成用戶(hù)定義層次結構,或者可以基于基礎維度表中的列定義為父子層次結構。