石化bw項目數(shù)據(jù)模型設(shè)計功能說明書-固定資產(chǎn)主題zficaa

1、項目: 中國BW 項目數(shù)據(jù)模型設(shè)計功能書固定資產(chǎn)ZFICAA01修改客戶確認(rèn)：目錄1.需求描述4版本日期作者狀態(tài)審核1.02005-9-3寫設(shè)計文檔2.數(shù)據(jù)模型星型結(jié)構(gòu)53.數(shù)據(jù)模型特性 (CH)..時間特性6關(guān)鍵指標(biāo)(KF)7ODS 對象7信息立方體83.4.1.Basiccube9MultiCube10RemoteCube..AGGREGATE104.數(shù)據(jù)源系統(tǒng)分析115.BW-DATA FLOW115.1.DATA FLOW11INFOCUBE: 投資訂單：ZFICAA01..DATA SOUR

2、CE13TRANSFER RULE13UPDATE RULE13ENHANCEMENT156.QUERY167.AUTHORIZATION161. 需求描述附件下列文件詳細描述了本文檔所涉及的各個部門業(yè)務(wù)分析需求:文件名稱狀態(tài)2. 數(shù)據(jù)模型星型結(jié)構(gòu)InfoCube: 投資訂單：ZFICAA01Fact Table訂單關(guān)鍵數(shù)據(jù)定單貨幣類型 關(guān)鍵值類型版本明細的數(shù)值類型Dimen金額固定金額可變金額數(shù)量固定數(shù)量可變數(shù)量ID成本控制范圍的值類型項目系統(tǒng)對象的全球唯一標(biāo)識3. 數(shù)據(jù)模型特性 (CH)InfoCube: 投資訂單：ZFICAA01TextHierarchyGeneralBexMaster

3、 DataInfo-Object (CH)Techn. NameData Type)Daten- length )Display- Attribut?Convert. RoutinText in Spalt headerAuth. Relev.Master Data?Time Dependent?定單0COORDERCHAR12成本控制范圍0CO_AREACHAR4貨幣類型0CURTYPECHAR2關(guān)鍵值類型0METYPENUMC6版本0VERCHAR3明細的數(shù)值類型0VTDETAILNUMC2的值類型0VTYPENUMC3項目系統(tǒng)對象的全球唯一標(biāo)識0PSGUIDCHAR32公司代碼0COMP

4、_CODECHAR43.1. 時間特性InfoCube: 投資訂單：ZFICAA01GerneralBexInfo-Object (CH)Techn. NameData- typeData- lengthDisplayAttribut?Convert. RoutinText inSpalt HeaderAuth. Relev.Others會計年度變式0FISCVARNTCHAR2AttribompoundingOthersInfo-Object (CH)Attrib ut nameDis Navigat.Time Dependent?Compounding with other Info-ob

5、jects?Note定單成本控制范圍貨幣類型關(guān)鍵值類型版本明細的數(shù)值類型的值類型項目系統(tǒng)對象的全球唯一標(biāo)識公司代碼Info-Object (CH)Text- SourceTime Dependent?Hierarchy?Time Dependent?Is there different Hierarchy-Ver?定單成本控制范圍貨幣類型關(guān)鍵值類型版本明細的數(shù)值類型的值類型項目系統(tǒng)對象的全球唯一標(biāo)識公司代碼3.2. 關(guān)鍵指標(biāo) (KF)InfoCube: 投資訂單：ZFICAA013.3. ODS 對象3.4. 信息立方體No.InfoCubeTechn. NameInfoAreaBasis-

6、CubeMulti- CubeRemote- Cube1期間值 (增量)0FIAA_C13ZHQFI_AAX2投資訂單：0FICAA01ZHQFI_AAX3固定資產(chǎn)期間值和事務(wù)ZFIMAA01ZHQFI_AAXODS ObjectTechn. NameKey-fieldsData- fieldsPSA-ODSUpdateODS-Cube AggregationRemark固定資產(chǎn)業(yè)務(wù)數(shù)據(jù)ZFIOAA01固定資產(chǎn)期間值ZFIOAA02事務(wù)(增量)0FIA_DS11期間值(增量)0FIA_DS13Additional PropertiesInfo-Object (KF)Decimal- PlaDi

7、splayBex Description金額Type / UnitAggregationInfo-Object (KF)Techn. NameKF-TypeUnitAggregation Min, Max, SumException- aggregationAgg. Reference characteristicOthers金額0AMOUNT金額會計年度0FISCYEARNUMC44在建工程概算和業(yè)務(wù)數(shù)據(jù)ZFIMAA02ZHQFI_AAX3.4.1. Basiccube特性Basiccube: 投資訂單：ZFICAA01時間特性InfoCube: 投資訂單：ZFICAA01關(guān)鍵指標(biāo)InfoC

8、ube: 投資訂單：ZFICAA01序號關(guān)鍵指標(biāo)技術(shù)名稱1金額0AMOUNTCharacteristicsTechn. NameRemark會計年度變式0FISCVARNT會計年度0FISCYEAR維度特性導(dǎo)航屬性備注訂單定單成本控制范圍關(guān)鍵數(shù)據(jù)貨幣類型關(guān)鍵值類型版本明細的數(shù)值類型的值類型項目系統(tǒng)對象的全球唯一標(biāo)識3.4.2. MultiCube3.4.3. RemoteCube3.5. AggregateAggregatTechn. NameCubeCharacteristics/ AttributAggregation LevelRemarkRemoteCubeTechn. NameCha

9、racteristicsKey FigureRelated SourystemRemarkMultiCubeTechn. NameCharacteristicsKey FigureRelated Basis-CubeRemark固定資產(chǎn)期間值和事務(wù)ZFIMAA01在建工程概算和業(yè)務(wù)數(shù)據(jù)ZFIMAA024. 數(shù)據(jù)源系統(tǒng)分析DataSource:BW-Data FlowData FlowInfoCube: 投資訂單：ZFICAA01Key Figure/ CharacteristicsTechn. NameSourc- systemTabelField Name數(shù)據(jù)源中的字段描述Related T

10、ext tabelCompounding withOthers會計年度變式0FISCVARNTFISCVAR會計年度變式會計年度0FISCYEARFISCYEAR會計年度成本控制范圍0CO_AREAKOKRS控制范圍訂單0COORDERAUFNR訂單號值類型0VTYPEVTYPE報表的數(shù)值類型明細的數(shù)值類型0VTDETAILVTDETAIL明細的數(shù)值類型版本0VERVERSN版本關(guān)鍵值類型0METYPEMEASTYPE關(guān)鍵數(shù)字類型金額0AMOUNTSWLGES貨幣0CURRENCYWAERS貨幣名稱代碼貨幣類型0CURTYPECURTYPE貨幣類型Data SourceTransfer Rul

11、eUpdate RuleKey FigureCube/ODSUpdate RuleKey FigureMethodC = Constante M = Master AttributeR = RoutineI = Initial ValueField Name/ ConstantRoutin DescriptionInfoSourceInfoObjectTech. NameMethodF= Trans.-Field C= Constante R = RoutineField Name/ ConstantRoutin Description0CO_OM_OPA_2會計年度變式0FISCVARNTF

12、ISCVAR會計年度0FISCYEARFISCYEAR成本控制范圍0CO AREAKOKRS訂單0COORDERAUFNR值類型0VTYPEVTYPE明細的數(shù)值類型0VTDETAILVTDETAIL版本0VERVERSN關(guān)鍵值類型0METYPEMEASTYPE金額0AMOUNTSWLGES貨幣0CURRENCYWAERS貨幣類型0CURTYPECURTYPEData SourceTypeB = BCTS = inforsite V = viewF = function modulInforsite/Vie w/Function modul nameField NameDescriptionAttribute S = select H = hide D = delta0CO_OM_OPA_2BCube/ODSUpdate RuleKey FigureMethodC = Constante M = Master AttributeR = RoutineI = Initial ValueField Name/ ConstantRoutin DescriptionZFICAA010CO_OM_OPA_20AMOUNT 金額0AMOUNT 金額Characteristics and Time CharacteristicsInfoCube:ZFICAA01Upda