Название пакета: DWH_OLAP_CSL_Dimensions¶
Описание¶
Обработка измерений и кубов OLAP (Analysis Services) для базы данных OLAP_CSL.
Схема¶
Список шагов¶
1. Dimensions Process¶
- Тип: Analysis Services Processing Task
- Описание: Обработка измерений OLAP куба
- Тип обработки: ProcessUpdate
- Параллельная обработка: Да
Обрабатываемые измерения:
| Dimension ID |
|---|
| Forecast IMS |
| Forecast IMS Mode |
| SA Exclusion |
| Plant |
| Date Week |
| Price Condition |
| Is Yellow Field |
| Forecast Shipment |
| Stock Type |
| Shipment Cost Type |
| Distribution Channels |
| AC Scenario |
| D Claim |
| Transport Type |
| FCU Reason |
| Sales Order Reason |
| Sales Order Type |
| PartYearMonth |
| CustomerIn BillTo Chipita |
| Outlook IMS Report Mode |
| SFA Sell In |
| Shipment Type |
| CustomerIn |
| Inventory Countries |
| Product SA KPI |
| SFA IMS |
| Outlook SI Report Mode |
| Sell In Exclude Report |
| Line Number Order |
| Date ISO |
| Currencies |
| Shipment Flow Type |
| UOM Inventory |
| Product Project |
| Order Release |
| D Shipment Contract Terms |
| Standard Assortment |
| Customer In Plant Type |
| Is Sell In Quota |
| Invoice Type |
| D Claim Deviation |
| Product CustomerIn |
| Date KF |
| Product GTD |
| Must Be Product |
| D Data Sources SFA |
| Order Status |
| Rejection Reason |
| CS Revision Comment |
| Flag |
| D Claim Denial Reason |
| Product Availability Check |
| UOM |
| Inventory Date Index Part |
| Customer Material No |
| Shipment Flow |
| Vendor |
| Criticality filter |
| Data Sources |
| Orders |
| Employee Creator |
| Invoices |
| Sell In Without Discount |
| SFA Shipment |
| Inventory ST Mode |
| Product Lot |
| CustomerIn System |
| Delivery Type |
| D Claim Status |
| Plant Location |
| D Claim Note |
| Location ShipTo |
| D Employee Sell In Hierarchy |
| Sales Order Reason Original |
| D Percent |
| Plant-specific status |
| Product SFA |
| Deliveries |
| Orders All |
| Order Item Category |
| Warehouse Status |
| Warehouse Operation |
| SFA Outlook IMS |
| D Shipment Location |
| Shipment Primary |
| Shipment Payment |
| Inventory Index Date |
| CFR Impact Mode |
| Product Season |
| Calendar |
| D Warehouse Contract Terms |
| Must Stock List |
| Lic Type |
| D Shipment Transport Mode |
| Shipment |
| Inventory Version |
| Date |
| Product Type |
| FCU Reason Impact |
| Transport Temp Mode |
| Service Provider |
| Product |
| Sales Organizations |
| PO STO |
2. Cubes Process¶
- Тип: Analysis Services Processing Task
- Описание: Полная обработка OLAP кубов
- Тип обработки: ProcessFull
- Параллельная обработка: Да (MaxParallel=16)
Список задействованных объектов¶
1. OLAP база данных¶
- Database: OLAP_CSL
- Server: arrrumosapp17
- Provider: MSOLAP.8
2. Внешние параметры, конфигурация¶
Config File: CFG_OLAP_Connection.dtsConfig
- OLAP_DB_Name = OLAP_CSL_SellOut_DEV
- OLAP_LINK_Name = OLAP_CSL_SellOut_DEV_LINK