設定檔案分隔符號

定義負載規則時的第一個工作之一是確保分隔符號設定適當。檔案分隔符號是用來分隔資料來源中欄位的字元。當您在規則編輯器中建立預覽時， Essbase 會嘗試偵測分隔符號。

附註：

您不需要設定 SQL 資料的檔案分隔符號。

以下為以逗號分隔之來源的範例：

","Year","X","","年","年","Год","Jahr"
"Year","Qtr1","X","Quarter1","第一季","第一四半期","Квартал 1","1. Quartal"
"Qtr1","Jan","","January","一月","１月","Январь","Januar"
"Qtr1","Feb","","February","二月","２月","Февраль","Februar"
"Qtr1","Mar","","March","三月","３月","Март","März"
"Year","Qtr2","X","Quarter2","第二季","第二四半期","Квартал 2","2. Quartal"
"Qtr2","Apr","","April","四月","４月","Апрель","April"
"Qtr2","May","","May","五月","５月","Май","Mai"
"Qtr2","Jun","","Jun","六月","６月","Июнь","Juni"
"Year","Qtr3","X","Quarter3","第三季","第三四半期","Квартал 3","3. Quartal"
"Qtr3","Jul","","July","七月","７月","Июль","Juli"
"Qtr3","Aug","","August","八月","８月","Август","August"
"Qtr3","Sep","","September","九月","９月","Сентябрь","September"
"Year","Qtr4","X","Quarter4","第四季","第四四半期","Квартал 4","4. Quartal"
"Qtr4","Oct","","October","十月","１０月","Октябрь","Oktober"
"Qtr4","Nov","","November","十一月","１１月","Ноябрь","November"
"Qtr4","Dec","","December","十二月","１２月","Декабрь","Dezember"

以下為以 Tab 字元分隔之來源的範例：

ProductSKU	California	Oregon	Washington	Utah	Nevada
100-20	-1587	338	231	398	86
200-20	2685	1086	579	496	167
300-30	1328	288	1217	413	362

若要在設計或編輯 Essbase Web 介面中的載入規則時設定來源檔案分隔符號，

  1. 導覽至來源特性，然後選取檔案特性頁籤。

  2. 將檔案分界字元設為逗號、Tab、空格或自訂值。有效的自訂值是標準 ASCII 字元集中的任何字元，編號從 0 到 127。


    來源為檔案時的規則檔來源特性對話方塊。選取的檔案類型為「分隔」，分隔符號選項為 Tab。其他選項包括逗號、空格及自訂。

若要在立方體部署之前在應用程式工作簿中設定分隔符號，您可以接受或變更任何維度工作表定義中的預設值。


具有定義的年度維度工作表。分隔符號為逗號。