You are here: Foswiki>Sandbox Web>WikiUsers>TestTest123>TestTest123Sandbox (05 Jul 2012, HorstMueller)
Die Felder Kürzel, Kurztitel, Version, Status und Thema aus der Kopfzeile sind im Eigenschaften-Dialog einzugeben: Menü „Datei“ -> „Eigenschaften“ -> Register „Anpassen“, in der „Eigenschaften“ Listbox auf den Namen des zu ändernden Feldes klicken und den neuen Wert im Feld „Wert“ eintragen. Die Felder werden beim Drucken und neu Laden aktualisiert. Von Hand geht dies mit Ctrl+A -> F9.
*Business Intelligence
*
Application Guide DWH/DWH
Application- and Reference Part of Topic
PLATO-MIT Backend
Release: 10.2
_ _ Numbering the versions: _
_The version numbers of the documents should contain the release and a current number within the release. Example: For documents created for Release 6.2, correct version numbers are 6.2.1 through to 6.2.n.
Possible values for „Status“:
_ * initial (i)_
_ * in progress (ip)_
_ * ready for review (rfr)_
_ * ready for acceptance (rfa)_
_ * approved (app.)_
The abbreviation of the current status should also be set as the document-property „Status“, so that the correct status is displayed in the page header.
_ _ Use of the template for the application description of a BI/DWH system _
_Any remarks regarding the use of the template are embedded in green and Italics in the following sections. The remarks are only descriptive, as is this section, and must be removed upon completion of the template. Sections that have no descriptive text added to them should be self-explanatory. _
_In addition to the embedded usage remarks, binding documentation notes are provided in the "Guide to BI/DWH documentation" for the following documents:
_ * Detailed System Specification for BI_
_ * Report Specification_
_ * Interface Specification_
_ * Detailed System Design for BI_
_ * Application Guide for Bl_
_ * Installation Guide for BI_
_ Note : The Application Guide can be subdivided into two documents for larger applications (for example for the business hub). The division should be made before the Job Reference section with a view to how the individual sections are used. _
* TABLE OF CONTENTS*
Process descriptions of DWH Release 9.1
Overview of new topics, changes, additions - Start of February 2009
General: PLATO-MIT supports the process of “month-end closing”.
The process of “month-end closing” should be supported by the new PLATO-MIT application. It contains 2 Parts which are responsible for different steps in the process of information providing to the end users (F44): data preparation and data presentation. This document explains only specific issues for the backend part, which serves as a central data source for the presentation area (Frontend).
* Import data delivered by business department F44 into several lookup tables.
* Import data into a fact table for the HSL cube. The origin of this data is SAP, but its delivered by business department F44 as csv file.
* Enrichment and grouping of “gross addition” data (Bruttozugang), “customer loyality“ data (Kundenbindung) and „commission” data (Provisionen) and storing them in the PLATO-MIT data mart. This data mart serves as source for the SAC / SRC cube.
* Several validation processes to check the completeness of lookup tables.
n/a
Export files for cube generation
Cube generation
The processes deal with the following tables and files:
Description: * Import data into the lookup table DWH$TA_L_MAP_PLATO_MIT_TAR and check imported data against DWH$VI_L_MAP_TARIF
*Jobplan PLATO_MIT_IMPORT_TARIF_MAPPING_TAEGLICH_JP
Sequential ON
IPPL_PLATO_MIT_TAR
PFIS_PLATO_MIT_TARIF ignore in case of failure
Sequential OFF
Jobplan
Start: * from run event DWH_RUN_PLATO_MIT_IMPORT_TARIF_MAPPING_TAEGLICH_JP_EVT
Condition: the file ~isdwhis/daten/dwh/plato/work/PLATO_MIT_TAR.csv must exist
Description: Import data into the lookup table DWH$TA_L_MAP_PLATO_SCS_PART and check imported data against DWH$VI_L_SCS_PROVISIONSART
Jobplan PLATO_MIT_IMPORT_PROV_ART_MAPPING_TAEGLICH_JP
Sequential ON
IPPL_PLATO_SCS_PART
PFIS_PLATO_MIT_PART ignore in case of failure
Sequential OFF
Jobplan
Start: * from run event DWH_RUN_PLATO_MIT_IMPORT_PROV_ART_MAPPING_TAEGLICH_JP_EVT
Condition: the file ~isdwhis/daten/dwh/plato/work/MIT_PLATO_SCS_PART.csv must exist
Description: * Import data into the lookup table DWH$TA_L_MAP_PLATO_MIT_HSL and check imported data against DWH$TA_F_PLATO_MIT_HSL_SAP
*Jobplan PLATO_MIT_IMPORT_HSL_MAPPING_TAEGLICH_JP
Sequential ON
IPPL_PLATO_MIT_HSL
PFIS_PLATO_MIT_HSL ignore in case of failure
PFIS_PLATO_MIT_HSL_2 ignore in case of failure
Sequential OFF
Jobplan
*Start: * from run event DWH_RUN_PLATO_MIT_IMPORT_HSL_MAPPING_TAEGLICH_JP_EVT
Condition: the file ~isdwhis/daten/dwh/plato/work/PLATO_MIT_HSL_????????.csv must exist
Description: * Import data into the table DWH$TA_F_PLATO_MIT_HSL_SAP and check imported data against DWH$TA_L_MAP_PLATO_MIT_HSL
*Jobplan PLATO_MIT_IMPORT_HSL_SAP_TAEGLICH_JP
Sequential ON
IPPL_PLATO_HSL_SAP
PFIS_PLATO_MIT_HSL ignore in case of failure
Sequential OFF
Jobplan
Start: * from run event DWH_RUN_PLATO_MIT_IMPORT_HSL_SAP_TAEGLICH_JP_EVT
Condition: the file ~isdwhis/daten/dwh/plato/work/PLATO_MIT_HSL_SAP.csv must exist
Description: Processing of gross addition data (Bruttozugang) and store them in DWH$TA_E_PLATO_MIT and start a Plato job afterwards to import the data to Hyperion.
Jobplan PLATO_MIT_AUFBEREITUNG_BRUTTOZUGANG_TAEGLICH_JP
Sequential ON
ABPL_PLATO_MIT_BZ
Parallel ON
START_DW_PLATO_MIT_AUFBEREITUNG_BRUTTOZUGANG_TAEGLICH_IE_JP
PLATO-jobplan
ABPL_PLATO_MIT_BZ_ST
Parallel OFF
Sequential OFF
Jobplan
*Start: * Once a day at 02:15
Description: Processing of gross addition data (Bruttozugang) and store them in DWH$TA_E_PLATO_MIT and start a Plato job afterwards to import the data to Hyperion.
Unlike PLATO_MIT_AUFBEREITUNG_BRUTTOZUGANG_TAEGLICH_JP the jobplan works on fact data of the previous month.
Jobplan PLATO_MIT_AUFBEREITUNG_BRUTTOZUGANG_MONATLICH_JP
Sequential ON
ABPL_PLATO_MIT_BZ_M
Parallel ON
START_DW_PLATO_MIT_AUFBEREITUNG_BRUTTOZUGANG_MONATLICH_IE_JP
PLATO-jobplan
ABPL_PLATO_MIT_BZMST
Parallel OFF
Sequential OFF
Jobplan
*Start: * Only on the first day of a month at 03:00 out of the scheduler
Description: * Processing of gross addition data (Bruttozugang) and store them in DWH$TA_E_PLATO_MIT and start a Plato job afterwards to import the data to Hyperion.
*Jobplan PLATO_MIT_AUFBEREITUNG_BRUTTOZUGANG_MANUELL_JP
Sequential ON
PLATO_RENAME_TRIGGER_FILE_MIT_AUFBEREITUNG_BRUTTOZUGANG
ABPL_PLATO_MIT_BZ
Parallel ON
START_DW_PLATO_MIT_AUFBEREITUNG_BRUTTOZUGANG_TAEGLICH_IE_JP
PLATO-jobplan
ABPL_PLATO_MIT_BZ_ST
Parallel OFF
PLATO_MOVE_TO_STORE_TRIGGER_FILE_MIT_AUFBEREITUNG_BRUTTOZUGANG
Sequential OFF
Jobplan
Start: * from run event DWH_RUN_PLATO_MIT_AUFBEREITUNG_BRUTTOZUGANG_MANUELL_JP_EVT
Condition: the file ~isdwhis/daten/dwh/plato/jobsteuerung/work/START_AUFBEREITUNG_BRUTTOZUGANG_.txt must exist
Description: * Processing of customer loyality data (Kundenbindung) and store them in DWH$TA_E_PLATO_MIT and start a Plato job afterwards to import the data to Hyperion.
*Jobplan PLATO_MIT_AUFBEREITUNG_KUBI_TAEGLICH_JP
Sequential ON
ABPL_PLATO_MIT_KB
Parallel ON
START_DW_PLATO_MIT_AUFBEREITUNG_KUNDENBINDUNG_TAEGLICH_IE_JP
PLATO-jobplan
ABPL_PLATO_MIT_KB_ST
Parallel OFF
Sequential OFF
Jobplan
*Start: * Once a day at 07:15
Description: * Processing of customer loyality data (Kundenbindung) and store them in DWH$TA_E_PLATO_MIT and start a Plato job afterwards to import the data to Hyperion.
Unlike PLATO_MIT_AUFBEREITUNG_KUBI_TAEGLICH_JP the jobplan works on fact data of the previous month.
*Jobplan PLATO_MIT_AUFBEREITUNG_KUBI_MONATLICH_JP
Sequential ON
ABPL_PLATO_MIT_KB_M
Parallel ON
START_DW_PLATO_MIT_AUFBEREITUNG_KUNDENBINDUNG_MONATLICH_IE_JP
PLATO-jobplan
ABPL_PLATO_MIT_KBMST
Parallel OFF
Sequential OFF
Jobplan
See for more details the latest PDF version of Application manual - Reference part!
Directory: O:\dw_doc\isdwh\betrieb\AHB_dwh; Documentation for example: ahb_dwh_84_ref_man_v01_en.pdf
Overview of chapters
3 Job and activity overview
4 Job execution scripts
5 Reference Part - Job description 1
6 Reference Part - Job description 2
7 Process history
8 FAQs
9 Troubleshooting
10 Annex
11 Supplementary documents
1. Jobs of < Topic name >
Every job has a special job ID that should be identical to its name under UC4.
The following lists every DWH job with its job ID and a description. The general naming convention for this ID is:
<Function><Area>_<System or assignment topic>_<…>_<Key figure or assignment>
Complete the following table if necessary: (underline changes with colour)
Fill out the Excel Sheet: ahb_dwh_<rel_nr>_<topic>.xls
and copy from the installation manual the job description!
| References | |
|---|---|
| Art | Listing |
| Standards to consider: | Navigator Handbook Version 3.1 Leitfaden zur BI/DWH Dokumentation Version 1.0 |
| References: | [1] O:\dw_doc\isplato\fachkonzept\DSS_BI_PLATO_MIT.doc [2] O:\dw_doc\isdwh\dv_konzept\dvk_rel_102\ TechnicalSystemDesign_PLATO_MIT.doc [3] O:\dw_doc\isdwh\betrieb\install_10.2\install_nach_102_plato_mit.doc |
| Template: | tbd\ApplicationGuide-BI.dot Bitte wieder mit dieser Vorlage verbinden, falls die Verbindung gekappt wurde: Extras->Vorlagen und Add-Ins |
| file & path: | O:\dw_doc\isdwh\betrieb\AHB_Teilbeitraege\ahb_dwh_102_plato_mit.doc |
| Document History: | |||||
|---|---|---|---|---|---|
| Ver. | Date | Status | ClearCase Ver. | Comments | Editor |
| 10.02.2000 | 01.04.2010 | i | \main\001 | Initial version | Dorothea Horst |
| 10.02.2001 | 14.07.2010 | i | \main\18 | Modified joplans and jobs and new jobs with FIX20100714 | Dorothea Horst |
| 10.02.2002 | 28.07.2010 | I | \main\20 | New jobplans and Jobs with FIX20100728 | Dorothea Horst |
_ _ Numbering the versions: _
_The version numbers of the documents should contain the release and a current number within the release. Example: For documents created for Release 6.2, correct version numbers are 6.2.1 through to 6.2.n.
Possible values for „Status“:
_ * initial (i)_
_ * in progress (ip)_
_ * ready for review (rfr)_
_ * ready for acceptance (rfa)_
_ * approved (app.)_
The abbreviation of the current status should also be set as the document-property „Status“, so that the correct status is displayed in the page header.
_ _ Use of the template for the application description of a BI/DWH system _
_Any remarks regarding the use of the template are embedded in green and Italics in the following sections. The remarks are only descriptive, as is this section, and must be removed upon completion of the template. Sections that have no descriptive text added to them should be self-explanatory. _
_In addition to the embedded usage remarks, binding documentation notes are provided in the "Guide to BI/DWH documentation" for the following documents:
_ * Detailed System Specification for BI_
_ * Report Specification_
_ * Interface Specification_
_ * Detailed System Design for BI_
_ * Application Guide for Bl_
_ * Installation Guide for BI_
_ Note : The Application Guide can be subdivided into two documents for larger applications (for example for the business hub). The division should be made before the Job Reference section with a view to how the individual sections are used. _
* TABLE OF CONTENTS*
Application Processes - Application Part
Process descriptions of DWH Release 9.1
Overview of new topics, changes, additions - Start of February 2009
| No. | DWH topic | Description | Content / scope |
|---|---|---|---|
| PLATO-MIT | Plato- M arkt i nves t | Several new processes to import, enrich and validate data |
Nach_102_plato_mit
General: PLATO-MIT supports the process of “month-end closing”.
Release history
| Release | Release history |
|---|---|
| … | |
| Rel. 8.4 | |
| Rel. 10.2 | Nach_102_plato_mit |
Purpose
The process of “month-end closing” should be supported by the new PLATO-MIT application. It contains 2 Parts which are responsible for different steps in the process of information providing to the end users (F44): data preparation and data presentation. This document explains only specific issues for the backend part, which serves as a central data source for the presentation area (Frontend).
Process steps
* Import data delivered by business department F44 into several lookup tables.
* Import data into a fact table for the HSL cube. The origin of this data is SAP, but its delivered by business department F44 as csv file.
* Enrichment and grouping of “gross addition” data (Bruttozugang), “customer loyality“ data (Kundenbindung) and „commission” data (Provisionen) and storing them in the PLATO-MIT data mart. This data mart serves as source for the SAC / SRC cube.
* Several validation processes to check the completeness of lookup tables.
Special features
n/a
Programs / job IDs
| Program | Parameters | AI | Job ID | Description |
|---|---|---|---|---|
| $HOME/aktuell/import/is/bin/r_ipis_exttab | -k $HOME/aktuell/import/pl/cfg/h_ippl_ext_plato_scs_part.var | IPPL_PLATO_SCS_PART | Import data into the lookup table DWH$TA_L_MAP_PLATO_SCS_PART | |
| $HOME/aktuell/import/is/bin/r_ipis_exttab | -k $HOME/aktuell/import/pl/cfg/h_ippl_ext_plato_mit_tar.var | IPPL_PLATO_MIT_TAR | Import data into the lookup table DWH$TA_L_MAP_PLATO_MIT_TAR | |
| $HOME/aktuell/import/is/bin/r_ipis_exttab | -k $HOME/aktuell/import/pl/cfg/h_ippl_ext_plato_mit_hsl.var | IPPL_PLATO_MIT_HSL | Import data into the lookup table DWH$TA_L_MAP_PLATO_MIT_HSL | |
| $HOME/aktuell/import/is/bin/r_ipis_exttab | -k $HOME/aktuell/import/pl/cfg/h_ippl_ext_plato_mit_hsl_sap.var | IPPL_PLATO_HSL_SAP | Import data into the fact table DWH$TA_F_PLATO_MIT_HSL_SAP | |
| $HOME/aktuell/allgemein/is/util/bin/r_sqlscript | -f $HOME/aktuell/aufbereitung/pl/sql/d_abpl_plato_mit_bz.sql j ABPL_PLATO_MIT_BZ -i MONAT whereas the argument MONAT is obtained from the UC4 variable AKTUELLER_MONAT_YYYYMM of the UC4 container VARIABLEN in date format YYYYMM |
ABPL_PLATO_MIT_BZ | Enrichment and grouping of “gross addition” data (Bruttozugang) and storing them in the PLATO-MIT data mart. | |
| $HOME/aktuell/allgemein/is/util/bin/r_sqlscript | -f $HOME/aktuell/aufbereitung/pl/sql/d_abpl_plato_mit_kb.sql -j ABPL_PLATO_MIT_KB -i MONAT whereas the argument MONAT is obtained from the UC4 variable AKTUELLER_MONAT_YYYYMM of the UC4 container VARIABLEN in date format YYYYMM |
ABPL_PLATO_MIT_KB | Enrichment and grouping of “customer loyality“ data (Kundenbindung) and storing them in the PLATO-MIT data mart. | |
| $HOME/aktuell/allgemein/is/util/bin/r_sqlscript | -f $HOME/aktuell/aufbereitung/pl/sql/d_abpl_plato_mit_pv.sql -j ABPL_PLATO_MIT_pv -i MONAT whereas the argument MONAT is obtained from the UC4 variable LASTMONTH_YYYYMM |
ABPL_PLATO_MIT_PV | Enrichment and grouping of „commission” data (Provisionen) for the previous month and storing them in the PLATO-MIT data mart. | |
| $HOME/aktuell/allgemein/is/util/bin/r_sqlscript | -f $HOME/aktuell/aufbereitung/pl/sql/d_abpl_plato_mit_pv.sql -j ABPL_PLATO_MIT_pv -i 0 |
ABPL_PLATO_MIT_PV_P | Enrichment and grouping of „commission” data (Provisionen) for the given month and storing them in the PLATO-MIT data mart. Month is defined by parameter |
|
| $HOME/aktuell/import/pl/bin/r_pfsd_plato | -t 59 -e 'Mapping_Pruefung_Plato_MIT_Tarif' -j 'PFIS_PLATO_MIT_TARIF' -v $DW_DIR_ROOT/exporter/verteiler/h_pfsd_plato_mit_admin_verteiler |
PFIS_PLATO_MIT_TARIF | Validation job: Check PLATO-MIT-Tarif-mapping against DWH$VI_L_MAP_TARIF and creation of dummy entries for missing mapping information in DWH$TA_L_MAP_PLATO_MIT_TAR |
|
| $HOME/aktuell/import/pl/bin/r_pfsd_plato | -t 60 -e 'Mapping_Pruefung_Plato_MIT_Provisionsart' -j 'PFIS_PLATO_MIT_PART' |
PFIS_PLATO_MIT_PART | Validation job: Check PLATO-MIT-mapping for commission types (Provisionsart) |
|
| $HOME/aktuell/import/pl/bin/r_pfsd_plato | -t 61 -e 'Mapping_Pruefung_Plato_MIT_HSL' -j 'PFIS_PLATO_MIT_HSL' |
PFIS_PLATO_MIT_HSL | Validation job: Check PLATO-MIT-mapping for SAP-account numbers (SAP-Kontonummern) |
|
| $HOME/aktuell/import/pl/bin/r_pfsd_plato | -t 62 -e 'Fakten_Pruefung_Plato_MIT_PV' -j 'PFIS_PLATO_MIT_PV' -m MONAT whereas the argument MONAT is obtained from the UC4 variable LASTMONTH_YYYYMM |
PFIS_PLATO_MIT_PV | Validation job: Check SCS_PROVISIONSART und SCS_VKOSTEN_KAT in table DWH$TA_F_SCS_PROV_BEW for the previous month against the table DWH$TA_L_MAP_PLATO_SCS_PART |
|
| $HOME/aktuell/import/pl/bin/r_pfsd_plato | -t 62 -e 'Fakten_Pruefung_Plato_MIT_PV' -j 'PFIS_PLATO_MIT_PV_P' -m 0 |
PFIS_PLATO_MIT_PV_P | Validation job: Check SCS_PROVISIONSART und SCS_VKOSTEN_KAT in table DWH$TA_F_SCS_PROV_BEW against the table DWH$TA_L_MAP_PLATO_SCS_PART, month defined by parameter |
|
| $HOME/aktuell/import/pl/bin/r_pfsd_plato | -t 63 -e 'Mapping_Pruefung_Plato_MIT_HSL_2' -j 'PFIS_PLATO_MIT_HSL_2' | PFIS_PLATO_MIT_HSL_2 | Validation job: Check DWH$TA_L_MAP_PLATO_MIT_HSL for uniqueness of SAP_KONTO_HAL_RELEVANZ within a SAP_KONTO_UNTERGRUPPE |
|
| UC4 script | PLATO_RENAME_TRIGGER_FILE_MIT_AUFBEREITUNG_BRUTTOZUGANG | Renames the file START_AUFBEREITUNG_BRUTTOZUGANG_*.txt to START_AUFBEREITUNG_BRUTTOZUGANG_*.lck The directory ~isdwhis/daten/dwh/plato/jobsteuerung/work contains the file. |
||
| UC4 script | PLATO_RENAME_TRIGGER_FILE_MIT_AUFBEREITUNG_KUBI | Renames the file START_AUFBEREITUNG_KUBI_*.txt to START_AUFBEREITUNG_KUBI_*.lck The directory ~isdwhis/daten/dwh/plato/jobsteuerung/work contains the file. |
||
| UC4 script | PLATO_RENAME_TRIGGER_FILE_MIT_AUFBEREITUNG_PROV | Renames the file START_AUFBEREITUNG_PROVISIONEN_????????.txt to START_AUFBEREITUNG_PROVISIONEN_????????.lck The directory ~isdwhis/daten/dwh/plato/jobsteuerung/work contains the file. |
||
| UC4 script | PLATO_RENAME_TRIGGER_FILE_MIT_AUFBEREITUNG_PROV_P | Renames the file START_AUFBEREITUNG_PROVISIONEN_PARAM_*.txt to START_AUFBEREITUNG_PROVISIONEN_PARAM_*.lck The directory ~isdwhis/daten/dwh/plato/jobsteuerung/work contains the file./jobsteuerung/store |
||
| UC4 script | PLATO_MOVE_TO_STORE_TRIGGER_FILE_MIT_AUFBEREITUNG_BRUTTOZUGANG | Moves the file START_AUFBEREITUNG_BRUTTOZUGANG_*.lck from the work folder ~isdwhis/daten/dwh/plato/jobsteuerung/work to the store folder ~isdwhis/daten/dwh/plato/jobsteuerung/store and renames it to START_AUFBEREITUNG_BRUTTOZUGANG_*.txt | ||
| UC4 script | PLATO_MOVE_TO_STORE_TRIGGER_FILE_MIT_AUFBEREITUNG_KUBI | Moves the file START_AUFBEREITUNG_KUBI_*.lck from the work folder ~isdwhis/daten/dwh/plato/jobsteuerung/work to the store folder ~isdwhis/daten/dwh/plato/jobsteuerung/store and renames it to START_AUFBEREITUNG_KUBI_*.txt | ||
| UC4 script | PLATO_MOVE_TO_STORE_TRIGGER_FILE_MIT_AUFBEREITUNG_PROV | Moves the file START_AUFBEREITUNG_PROVISIONEN_????????.lck from the work folder ~isdwhis/daten/dwh/plato/jobsteuerung/work to the store folder ~isdwhis/daten/dwh/plato/jobsteuerung/store and renames it to START_AUFBEREITUNG_PROVISIONEN_????????.txt | ||
| UC4 script | PLATO_MOVE_TO_STORE_TRIGGER_FILE_MIT_AUFBEREITUNG_PROV_P | Moves the file START_AUFBEREITUNG_PROVISIONEN_PARAM_*.lck from the work folder ~isdwhis/daten/dwh/plato/jobsteuerung/work to the store folder ~isdwhis/daten/dwh/plato/jobsteuerung/store and renames it to START_AUFBEREITUNG_PROVISIONEN_PARAM_*.txt | ||
| $HOME/aktuell/import/tn/bin/r_iptn_part | -t <yyyymm> -p 1 -s DWH_DAT_SAUTO -i DWH_IND_SAUTO -m plato_mit |
IPTN_PART_PLATO_MIT | Monthly creation of a new partition with subpartitions for Plato MIT |
Export files for cube generation
| Program | Parameters | Job ID | Description | |
|---|---|---|---|---|
Cube generation
| Program | Parameters | Job ID | Description | |
|---|---|---|---|---|
Interfaces
PLATO-MIT Interfaces
| Information about the interface designation: | Application DWH; Interface: several PLATO-MIT Interfaces |
|---|---|
| Supplier of data (name, company, city, Dept.) | T-Mobile |
| Contacts supplier (with phone) | F44 |
| Contacts specialist T-Mobile (with phone) | Sven Strehlau (31273) |
| Delivery Method (DM) Active : even fetch or pull Passive : files are delivered or pushed |
passive |
| DM active: remote DB name | n.a. |
| DM active: user account on remote system | n.a. |
| DM active: directory name | n.a. |
| Volume per day or month (MB / KB) | < 1 KB |
| File mask | ~isdwhis/daten/dwh/plato/work/MIT_PLATO_SCS_PART_YYYYMMDD.csv ~isdwhis/daten/dwh/plato/work/PLATO_MIT_TAR_YYYYMMDD.csv ~isdwhis/daten/dwh/plato/work/PLATO_MIT_HSL_YYYYMMDD.csv ~isdwhis/daten/dwh/plato/work/PLATO_MIT_HSL_SAP_YYYYMMDD.csv |
| DNS server name of the supplier system | n.a. |
| IP address of the supplier server | n.a. |
| NAT address of the supplier server | n.a. |
| Firewall unlock | n.a. |
| Name of the affected UC4 jobs | IPPL_PLATO_SCS_PART IPPL_PLATO_MIT_TAR IPPL_PLATO_MIT_HSL IPPL_PLATO_HSL_SAP |
| Miscellaneous | n.a. |
Start frequency
| Jobplan name | Job ID | Frequency |
|---|---|---|
| PLATO_MIT_IMPORT_TARIF_MAPPING_TAEGLICH_JP | started from run event DWH_RUN_PLATO_MIT_IMPORT_TARIF_MAPPING_TAEGLICH_JP_EVT Condition: the file ~isdwhis/daten/dwh/plato/work/PLATO_MIT_TAR*.csv must exist |
|
| PLATO_MIT_IMPORT_PROV_ART_MAPPING_TAEGLICH_JP | started from run event DWH_RUN_PLATO_MIT_IMPORT_PROV_ART_MAPPING_TAEGLICH_JP_EVT Condition: the file ~isdwhis/daten/dwh/plato/work/MIT_PLATO_SCS_PART*.csv must exist |
|
| PLATO_MIT_IMPORT_HSL_MAPPING_TAEGLICH_JP | started from run event DWH_RUN_PLATO_MIT_IMPORT_HSL_MAPPING_TAEGLICH_JP_EVT Condition: the file ~isdwhis/daten/dwh/plato/work/PLATO_MIT_HSL_????????.csv must exist |
|
| PLATO_MIT_IMPORT_HSL_SAP_TAEGLICH_JP | started from run event DWH_RUN_PLATO_MIT_IMPORT_HSL_SAP_TAEGLICH_JP_EVT Condition: the file ~isdwhis/daten/dwh/plato/work/PLATO_MIT_HSL_SAP*.csv must exist |
|
| PLATO_MIT_AUFBEREITUNG_BRUTTOZUGANG_TAEGLICH_JP | Once a day at 02:15 | |
| PLATO_MIT_AUFBEREITUNG_BRUTTOZUGANG_MONATLICH_JP | Only on the first day of a month at 03:00 out of the scheduler | |
| PLATO_MIT_AUFBEREITUNG_BRUTTOZUGANG_MANUELL_JP | started from run event DWH_RUN_PLATO_MIT_AUFBEREITUNG_BRUTTOZUGANG_MANUELL_JP_EVT Condition: the file ~isdwhis/daten/dwh/plato/jobsteuerung/work/START_AUFBEREITUNG_BRUTTOZUGANG_*.txt must exist |
|
| PLATO_MIT_AUFBEREITUNG_KUBI_TAEGLICH_JP | Once a day at 07:15 | |
| PLATO_MIT_AUFBEREITUNG_KUBI_MONATLICH_JP | Only on the first day of a month at 03:00 out of the scheduler | |
| PLATO_MIT_AUFBEREITUNG_KUBI_MANUELL_JP | started from run event DWH_RUN_PLATO_MIT_AUFBEREITUNG_KUBI_MANUELL_JP_EVT Condition: the file ~isdwhis/daten/dwh/plato/jobsteuerung/work/START_AUFBEREITUNG_KUBI_*.txt must exist |
|
| PLATO_MIT_AUFBEREITUNG_PROVISIONEN_MANUELL_JP | started from run event DWH_RUN_PLATO_MIT_AUFBEREITUNG_PROVISIONEN_MANUELL_JP_EVT Condition: the file ~isdwhis/daten/dwh/plato/jobsteuerung/work/START_AUFBEREITUNG_PROVISIONEN_????????.txt must exist |
|
| PLATO_MIT_AUFBEREITUNG_PROVISIONEN_PARAM_MANUELL_JP | started from run event DWH_RUN_PLATO_MIT_AUFBEREITUNG_PROVISIONEN_PARAM_MANUELL_JP_EVT Condition: the file ~isdwhis/daten/dwh/plato/jobsteuerung/work/START_AUFBEREITUNG_PROVISIONEN_PARAM_*.txt must exist |
|
| PARTITIONEN_MONATLICH_<…>JP | Once a month |
Directory structure
| Directory | File mask | Description |
|---|---|---|
| ~isdwhis/daten/dwh/plato/work/ | MIT_PLATO_SCS_PART_YYYYMMDD.csv | data for the lookup table DWH$TA_L_MAP_PLATO_SCS_PART |
| ~isdwhis/daten/dwh/plato/work/ | PLATO_MIT_TAR_YYYYMMDD.csv | Data for the lookup table DWH$TA_L_MAP_PLATO_MIT_TAR |
| ~isdwhis/daten/dwh/plato/work/ | PLATO_MIT_HSL_YYYYMMDD.csv | data for the lookup table DWH$TA_L_MAP_PLATO_MIT_HSL |
| ~isdwhis/daten/dwh/plato/work/ | PLATO_MIT_HSL_SAP_YYYYMMDD.csv | data for the fact table DWH$TA_F_PLATO_MIT_HSL_SAP |
Affected tables
The processes deal with the following tables and files:
| Input | Output | Process step | Job ID |
|---|---|---|---|
| ~isdwhis/daten/dwh/plato/work/MIT_PLATO_SCS_PART*.csv | DWH$TA_L_MAP_PLATO_SCS_PART | Import | IPPL_PLATO_SCS_PART |
| ~isdwhis/daten/dwh/plato/work/PLATO_MIT_TAR*.csv | DWH$TA_L_MAP_PLATO_MIT_TAR | Import | IPPL_PLATO_MIT_TAR |
| ~isdwhis/daten/dwh/plato/work/PLATO_MIT_HSL_????????.csv | DWH$TA_L_MAP_PLATO_MIT_HSL | Import | IPPL_PLATO_MIT_HSL |
| ~isdwhis/daten/dwh/plato/work/PLATO_MIT_HSL_SAP*.csv DWH$TA_T_PLATO_THEMEN_SEQ |
DWH$TA_F_PLATO_MIT_HSL_SAP DWH$TA_T_PLATO_THEMEN_SEQ |
Import | IPPL_PLATO_HSL_SAP |
| DWH$TA_F_D1_BZUG_KOND DWH$MV_L_MAP_TARIF DWH$VX_S_VO_STRUKTUR |
DWH$TA_E_PLATO_MIT DWH$TA_K_PLATO_BZ_ANALYSE |
Transfer data | ABPL_PLATO_MIT_BZ |
| DWH$TA_F_D1_TWVV_TN DWH$MV_L_MAP_TARIF DWH$VX_S_VO_STRUKTUR |
DWH$TA_E_PLATO_MIT DWH$TA_K_PLATO_KUBI_ANALYSE |
Transfer data | ABPL_PLATO_MIT_KB |
| DWH$TA_F_SCS_PROV_BEW DWH$MV_L_MAP_TARIF DWH$TA_L_SCS_PRODUKT DWH$TAL_MAP_PLATO_SCS_PART DWH$VX_S_VO_STRUKTUR DWH$TA_L_MAP_PLATO_PARAM |
DWH$TA_E_PLATO_MIT DWH$TA_K_PLATO_SCS_ANALYSE |
Transfer data | ABPL_PLATO_MIT_PV |
| DWH$TA_F_SCS_PROV_BEW DWH$MV_L_MAP_TARIF DWH$TA_L_SCS_PRODUKT DWH$TAL_MAP_PLATO_SCS_PART DWH$VX_S_VO_STRUKTUR DWH$TA_L_MAP_PLATO_PARAM |
DWH$TA_E_PLATO_MIT DWH$TA_K_PLATO_SCS_ANALYSE |
Transfer data | ABPL_PLATO_MIT_PV_P |
| DWH$VI_L_MAP_TARIF DWH$TA_L_MAP_PLATO_MIT_TAR |
DWH$TA_L_MAP_PLATO_MIT_TAR | Data validation | PFIS_PLATO_MIT_TARIF |
| DWH$VI_L_SCS_PROVISIONSART DWH$TA_L_MAP_PLATO_SCS_PART |
Data validation | PFIS_PLATO_MIT_PART | |
| DWH$TA_F_PLATO_MIT_HSL_SAP DWH$TA_L_MAP_PLATO_MIT_HSL |
Data validation | PFIS_PLATO_MIT_HSL | |
| DWH$TA_L_MAP_PLATO_MIT_HSL | Data validation | PFIS_PLATO_MIT_HSL_2 | |
| DWH$TA_F_SCS_PROV_BEW DWH$TA_L_MAP_PLATO_SCS_PART |
Data validation | PFIS_PLATO_MIT_PV | |
| DWH$TA_F_SCS_PROV_BEW DWH$TA_L_MAP_PLATO_SCS_PART |
Data validation | PFIS_PLATO_MIT_PV_P | |
| ~isdwhis/daten/dwh/plato/jobsteuerung/work/START_AUFBEREITUNG_BRUTTOZUGANG_*.txt | ~isdwhis/daten/dwh/plato/jobsteuerung/work/START_AUFBEREITUNG_BRUTTOZUGANG_*.lck | Renames the trigger file | PLATO_RENAME_TRIGGER_FILE_MIT_AUFBEREITUNG_BRUTTOZUGANG |
| ~isdwhis/daten/dwh/plato/jobsteuerung/work/START_AUFBEREITUNG_KUBI_*.txt | ~isdwhis/daten/dwh/plato/jobsteuerung/work/START_AUFBEREITUNG_KUBI_*.lck | Renames the trigger file | PLATO_RENAME_TRIGGER_FILE_MIT_AUFBEREITUNG_KUBI |
| ~isdwhis/daten/dwh/plato/jobsteuerung/work/START_AUFBEREITUNG_PROVISIONEN_????????.txt | ~isdwhis/daten/dwh/plato/jobsteuerung/work/START_AUFBEREITUNG_PROVISIONEN_????????.lck | Renames the trigger file | PLATO_RENAME_TRIGGER_FILE_MIT_AUFBEREITUNG_PROV |
| ~isdwhis/daten/dwh/plato/jobsteuerung/work/START_AUFBEREITUNG_PROVISIONEN_PARAM_*.txt | ~isdwhis/daten/dwh/plato/jobsteuerung/work/START_AUFBEREITUNG_PROVISIONEN_PARAM_*.lck | Renames the trigger file | PLATO_RENAME_TRIGGER_FILE_MIT_AUFBEREITUNG_PROV_P |
| ~isdwhis/daten/dwh/plato/jobsteuerung/work/START_AUFBEREITUNG_BRUTTOZUGANG_*.lck | ~isdwhis/daten/dwh/plato/jobsteuerung/store/START_AUFBEREITUNG_BRUTTOZUGANG_*.txt | Move and rename trigger file from work to store | PLATO_MOVE_TO_STORE_TRIGGER_FILE_MIT_AUFBEREITUNG_BRUTTOZUGANG |
| ~isdwhis/daten/dwh/plato/jobsteuerung/work/START_AUFBEREITUNG_KUBI_*.lck | ~isdwhis/daten/dwh/plato/jobsteuerung/store/START_AUFBEREITUNG_KUBI_*.txt | Move and rename trigger file from work to store | PLATO_MOVE_TO_STORE_TRIGGER_FILE_MIT_AUFBEREITUNG_KUBI |
| ~isdwhis/daten/dwh/plato/jobsteuerung/work/START_AUFBEREITUNG_PROVISIONEN_????????.lck | ~isdwhis/daten/dwh/plato/jobsteuerung/store/START_AUFBEREITUNG_PROVISIONEN_????????.txt | Move and rename trigger file from work to store | PLATO_MOVE_TO_STORE_TRIGGER_FILE_MIT_AUFBEREITUNG_PROV |
| ~isdwhis/daten/dwh/plato/jobsteuerung/work/START_AUFBEREITUNG_PROVISIONEN_PARAM_*.lck | ~isdwhis/daten/dwh/plato/jobsteuerung/store/START_AUFBEREITUNG_PROVISIONEN_PARAM_*.txt | Move and renametrigger file from work to store | PLATO_MOVE_TO_STORE_TRIGGER_FILE_MIT_AUFBEREITUNG_PROV_P |
Dependencies
| Jobplan | Dependencies to other systems or other jobs / jobplans |
| PLATO_MIT_IMPORT_TARIF_MAPPING_TAEGLICH_JP | n.a. |
| PLATO_MIT_IMPORT_PROV_ART_MAPPING_TAEGLICH_JP | ABPL_PLATO_MIT_PV must not run in parallel |
| PLATO_MIT_IMPORT_HSL_MAPPING_TAEGLICH_JP | PLATO_MIT_IMPORT_HSL_SAP_TAEGLICH_JP must not run in parallel |
| PLATO_MIT_IMPORT_HSL_SAP_TAEGLICH_JP | PLATO_MIT_IMPORT_HSL_MAPPING_TAEGLICH_JP must not run in parallel |
| PLATO_MIT_AUFBEREITUNG_BRUTTOZUGANG_TAEGLICH_JP | VDTN_KOND_BZUG must not run in parallel |
| PLATO_MIT_AUFBEREITUNG_BRUTTOZUGANG_MONATLICH_JP | VDTN_KOND_BZUG must not run in parallel |
| PLATO_MIT_AUFBEREITUNG_BRUTTOZUGANG_MANUELL_JP | VDTN_KOND_BZUG must not run in parallel |
| PLATO_MIT_AUFBEREITUNG_KUBI_TAEGLICH_JP | ABTN_TWVV_TN must not run in parallel. |
| PLATO_MIT_AUFBEREITUNG_KUBI_MONATLICH_JP | ABTN_TWVV_TN must not run in parallel. |
| PLATO_MIT_AUFBEREITUNG_KUBI_MANUELL_JP | ABTN_TWVV_TN must not run in parallel. |
| PLATO_MIT_AUFBEREITUNG_PROVISIONEN_MANUELL_JP | IPTN_F_SCS_BPROV_VS, ABTN_SCS_PROV_BEW and ABSD_SCS_AGREEGOODW must not run in parallel |
| PLATO_MIT_AUFBEREITUNG_PROVISIONEN_PARAM_MANUELL_JP | IPTN_F_SCS_BPROV_VS, ABTN_SCS_PROV_BEW and ABSD_SCS_AGREEGOODW must not run in parallel |
| PARTITIONEN_MONATLICH_<…>_JP | PLATO_MIT_AUFBEREITUNG_BRUTTOZUGANG_TAEGLICH_JP, PLATO_MIT_AUFBEREITUNG_BRUTTOZUGANG_MONATLICH_JP, PLATO_MIT_AUFBEREITUNG_BRUTTOZUGANG_MANUELL_JP, PLATO_MIT_AUFBEREITUNG_KUBI_TAEGLICH_JP, PLATO_MIT_AUFBEREITUNG_KUBI_MONATLICH_JP, PLATO_MIT_AUFBEREITUNG_KUBI_MANUELL_JP, PLATO_MIT_AUFBEREITUNG_PROVISIONEN_PARAM_MANUELL_JP must not run in parallel |
Jobplan
PLATO_MIT_IMPORT_TARIF_MAPPING_TAEGLICH_JP
Description: * Import data into the lookup table DWH$TA_L_MAP_PLATO_MIT_TAR and check imported data against DWH$VI_L_MAP_TARIF
*Jobplan PLATO_MIT_IMPORT_TARIF_MAPPING_TAEGLICH_JP
Sequential ON
IPPL_PLATO_MIT_TAR
PFIS_PLATO_MIT_TARIF ignore in case of failure
Sequential OFF
Jobplan
Start: * from run event DWH_RUN_PLATO_MIT_IMPORT_TARIF_MAPPING_TAEGLICH_JP_EVT
Condition: the file ~isdwhis/daten/dwh/plato/work/PLATO_MIT_TAR.csv must exist
PLATO_MIT_IMPORT_PROV_ART_MAPPING_TAEGLICH_JP
Description: Import data into the lookup table DWH$TA_L_MAP_PLATO_SCS_PART and check imported data against DWH$VI_L_SCS_PROVISIONSART
Jobplan PLATO_MIT_IMPORT_PROV_ART_MAPPING_TAEGLICH_JP
Sequential ON
IPPL_PLATO_SCS_PART
PFIS_PLATO_MIT_PART ignore in case of failure
Sequential OFF
Jobplan
Start: * from run event DWH_RUN_PLATO_MIT_IMPORT_PROV_ART_MAPPING_TAEGLICH_JP_EVT
Condition: the file ~isdwhis/daten/dwh/plato/work/MIT_PLATO_SCS_PART.csv must exist
PLATO_MIT_IMPORT_HSL_MAPPING_TAEGLICH_JP
Description: * Import data into the lookup table DWH$TA_L_MAP_PLATO_MIT_HSL and check imported data against DWH$TA_F_PLATO_MIT_HSL_SAP
*Jobplan PLATO_MIT_IMPORT_HSL_MAPPING_TAEGLICH_JP
Sequential ON
IPPL_PLATO_MIT_HSL
PFIS_PLATO_MIT_HSL ignore in case of failure
PFIS_PLATO_MIT_HSL_2 ignore in case of failure
Sequential OFF
Jobplan
*Start: * from run event DWH_RUN_PLATO_MIT_IMPORT_HSL_MAPPING_TAEGLICH_JP_EVT
Condition: the file ~isdwhis/daten/dwh/plato/work/PLATO_MIT_HSL_????????.csv must exist
PLATO_MIT_IMPORT_HSL_SAP_TAEGLICH_JP
Description: * Import data into the table DWH$TA_F_PLATO_MIT_HSL_SAP and check imported data against DWH$TA_L_MAP_PLATO_MIT_HSL
*Jobplan PLATO_MIT_IMPORT_HSL_SAP_TAEGLICH_JP
Sequential ON
IPPL_PLATO_HSL_SAP
PFIS_PLATO_MIT_HSL ignore in case of failure
Sequential OFF
Jobplan
Start: * from run event DWH_RUN_PLATO_MIT_IMPORT_HSL_SAP_TAEGLICH_JP_EVT
Condition: the file ~isdwhis/daten/dwh/plato/work/PLATO_MIT_HSL_SAP.csv must exist
PLATO_MIT_AUFBEREITUNG_BRUTTOZUGANG_TAEGLICH_JP
Description: Processing of gross addition data (Bruttozugang) and store them in DWH$TA_E_PLATO_MIT and start a Plato job afterwards to import the data to Hyperion.
Jobplan PLATO_MIT_AUFBEREITUNG_BRUTTOZUGANG_TAEGLICH_JP
Sequential ON
ABPL_PLATO_MIT_BZ
Parallel ON
START_DW_PLATO_MIT_AUFBEREITUNG_BRUTTOZUGANG_TAEGLICH_IE_JP
PLATO-jobplan
ABPL_PLATO_MIT_BZ_ST
Parallel OFF
Sequential OFF
Jobplan
*Start: * Once a day at 02:15
PLATO_MIT_AUFBEREITUNG_BRUTTOZUGANG_MONATLICH_JP
Description: Processing of gross addition data (Bruttozugang) and store them in DWH$TA_E_PLATO_MIT and start a Plato job afterwards to import the data to Hyperion.
Unlike PLATO_MIT_AUFBEREITUNG_BRUTTOZUGANG_TAEGLICH_JP the jobplan works on fact data of the previous month.
Jobplan PLATO_MIT_AUFBEREITUNG_BRUTTOZUGANG_MONATLICH_JP
Sequential ON
ABPL_PLATO_MIT_BZ_M
Parallel ON
START_DW_PLATO_MIT_AUFBEREITUNG_BRUTTOZUGANG_MONATLICH_IE_JP
PLATO-jobplan
ABPL_PLATO_MIT_BZMST
Parallel OFF
Sequential OFF
Jobplan
*Start: * Only on the first day of a month at 03:00 out of the scheduler
PLATO_MIT_AUFBEREITUNG_BRUTTOZUGANG_MANUELL_JP
Description: * Processing of gross addition data (Bruttozugang) and store them in DWH$TA_E_PLATO_MIT and start a Plato job afterwards to import the data to Hyperion.
*Jobplan PLATO_MIT_AUFBEREITUNG_BRUTTOZUGANG_MANUELL_JP
Sequential ON
PLATO_RENAME_TRIGGER_FILE_MIT_AUFBEREITUNG_BRUTTOZUGANG
ABPL_PLATO_MIT_BZ
Parallel ON
START_DW_PLATO_MIT_AUFBEREITUNG_BRUTTOZUGANG_TAEGLICH_IE_JP
PLATO-jobplan
ABPL_PLATO_MIT_BZ_ST
Parallel OFF
PLATO_MOVE_TO_STORE_TRIGGER_FILE_MIT_AUFBEREITUNG_BRUTTOZUGANG
Sequential OFF
Jobplan
Start: * from run event DWH_RUN_PLATO_MIT_AUFBEREITUNG_BRUTTOZUGANG_MANUELL_JP_EVT
Condition: the file ~isdwhis/daten/dwh/plato/jobsteuerung/work/START_AUFBEREITUNG_BRUTTOZUGANG_.txt must exist
PLATO_MIT_AUFBEREITUNG_KUBI_TAEGLICH_JP
Description: * Processing of customer loyality data (Kundenbindung) and store them in DWH$TA_E_PLATO_MIT and start a Plato job afterwards to import the data to Hyperion.
*Jobplan PLATO_MIT_AUFBEREITUNG_KUBI_TAEGLICH_JP
Sequential ON
ABPL_PLATO_MIT_KB
Parallel ON
START_DW_PLATO_MIT_AUFBEREITUNG_KUNDENBINDUNG_TAEGLICH_IE_JP
PLATO-jobplan
ABPL_PLATO_MIT_KB_ST
Parallel OFF
Sequential OFF
Jobplan
*Start: * Once a day at 07:15
PLATO_MIT_AUFBEREITUNG_KUBI_MONATLICH_JP
Description: * Processing of customer loyality data (Kundenbindung) and store them in DWH$TA_E_PLATO_MIT and start a Plato job afterwards to import the data to Hyperion.
Unlike PLATO_MIT_AUFBEREITUNG_KUBI_TAEGLICH_JP the jobplan works on fact data of the previous month.
*Jobplan PLATO_MIT_AUFBEREITUNG_KUBI_MONATLICH_JP
Sequential ON
ABPL_PLATO_MIT_KB_M
Parallel ON
START_DW_PLATO_MIT_AUFBEREITUNG_KUNDENBINDUNG_MONATLICH_IE_JP
PLATO-jobplan
ABPL_PLATO_MIT_KBMST
Parallel OFF
Sequential OFF
Jobplan
Application Processes - Reference Part
See for more details the latest PDF version of Application manual - Reference part!
Directory: O:\dw_doc\isdwh\betrieb\AHB_dwh; Documentation for example: ahb_dwh_84_ref_man_v01_en.pdf
Overview of chapters
3 Job and activity overview
4 Job execution scripts
5 Reference Part - Job description 1
6 Reference Part - Job description 2
7 Process history
8 FAQs
9 Troubleshooting
10 Annex
11 Supplementary documents
1. Jobs of < Topic name >
Job Semantics
Every job has a special job ID that should be identical to its name under UC4.
The following lists every DWH job with its job ID and a description. The general naming convention for this ID is:
<Function><Area>_<System or assignment topic>_<…>_<Key figure or assignment>
Complete the following table if necessary: (underline changes with colour)
| Designation | Values | Meaning |
|---|---|---|
| Function (usually 2 signs) |
||
| AB | Processing | |
| AL | General | |
| BL | Business Layer | |
| DIS | Dispatcher | |
| EX | Export, export plus transfer | |
| FT | File Transfer | |
| HM | Harmonization | |
| IP | Import | |
| KORR | Correction | |
| MIG, MI, MG | Migration | |
| MT | Metadata | |
| MV | Move | |
| NV | Postprocessing | |
| OA | Cube creation, Cube exports | |
| PF, PR | Verification | |
| RP | Reportnet | |
| VD | Aggregation | |
| VV | Preprocessing | |
| ZL | Delivery | |
| Area - Main department (usually 2 signs) |
||
| CM | Cube metadata | |
| DM | Database marketing | |
| EX | Export | |
| GD | Call data | |
| HD | HappyDigits | |
| HU | Metadata DWH-HUB | |
| IA | International accounts | |
| IK | IKDB - database on interested parties | |
| IS | General | |
| KW | Customer Value | |
| MG | Migration | |
| MT | Metadata | |
| NW | Network Hub | |
| PL | Plato | |
| PZ | Business process (Customer Contact Management KKM) |
|
| RE | Resource Management | |
| SD | Master Data | |
| SP | Service Provider Reporting | |
| TN | Subscriber (statistics) | |
| US | Sales | |
| VG | Process Statistics | |
| System, topic, assignment |
||
| ABG | Terminations (subscriber etc.) | |
| ADT | Information for the “sales field service” | |
| AES | Information request system | |
| AKTIV | Activity | |
| AKZ | Promotion indicator | |
| BAPSI | Billing system including Transfer Account Procedure System and Interconnection | |
| BIC | Best in Class | |
| BM | Billing monitoring | |
| BPI | Basic product instances | |
| BST | Inventory | |
| CAP | Customer Advantage Program GmbH | |
| CARMEN | Delivery system for standard+prepaid | |
| CBS | Carmen Billing System | |
| CDV | Call Data Verification | |
| CP | Copy | |
| CPDW | European Data Warehouse | |
| CRNP | Churn reporting/never-payers | |
| CSLA | Networkhub: Customer SLA | |
| CUBE | Cube | |
| CWB | Common Wholesale Billing | |
| D1 | D1 | |
| DQ | Data Quality (DWH) | |
| DWH | Data Warehouse | |
| EBK | Availability cache | |
| FKV | Flexible classification of contracts | |
| FMIC | Members' data verification process | |
| GPOS | Credit items / positions | |
| HD | HappyDigits Customer Value Program | |
| INDIV | Indirect Sales | |
| INES | System which deals with information about lending devices with regard to exchange. | |
| INIT | Initialization | |
| KKDS | Customer Contact Data Server (pCACM) | |
| KKM | Customer Contact Management | |
| KOND | Condensation | |
| KPR | Channel profitability calculation (KPR) | |
| KSD | Customer master data (KSD) | |
| KUBI | Customer loyalty monitoring (KUBI) | |
| KWS | Customer Value System | |
| MET | Networkhub: Metrica Server | |
| MK | MaKe, Cube Creation | |
| MNP | Mobile Number Portability | |
| MORPU | Monthly Revenue Per User | |
| NGFPR | Fax Packeting New Business | |
| NTA | Networkhub: National Traffic Analysis | |
| PACE | Project Assignment, Charging & Effort Recording | |
| PART | Partition | |
| PDB | Potential database | |
| PLATO | Planning system | |
| PR | Product reporting Prologue | |
| RAVAS | Outline Agreement Billing System | |
| RBUDG | Invoice allowances | |
| RMG | Regarding project REMA | |
| RPOS | Invoice items / positions | |
| RQT | Return Quota | |
| RRABATT | Rebates by rebate reason | |
| SAP | SAP Delivery System | |
| SEND | To send | |
| SCS | Sales Partner Clearing System T-Mobile Germany Premium Settlement with SAP R/3 FS-CS | |
| SIA | System for International Accounts | |
| SIGMA | Sigma (delivery system for call data) | |
| SP | Service Provider Reporting | |
| SPAS | Service Provider Billing System | |
| SW | Cube generation via cube server farm | |
| TC | Tibco adapter | |
| TRF | Rate | |
| TWVV | Combined rate change/binding contract events | |
| UMTS | Universal Mobile Telecommunication System | |
| VR | Sales reporting | |
| WARENK | Shopping cart | |
| WKZ | advertising allowances | |
| WLT | Process for maintaining lookup tables | |
| XTRA | Xtra | |
| ZUG | Additions (subscriber, | |
Job and activity overview
| Job ID | Area | Delivery system | KPI |
|---|---|---|---|
| IPPL_PLATO_SCS_PART | PLATO-MIT | manual data delivery | Import data into the lookup table DWH$TA_L_MAP_PLATO_SCS_PART |
| IPPL_PLATO_MIT_TAR | PLATO-MIT | manual data delivery | Import data into the lookup table DWH$TA_L_MAP_PLATO_MIT_TAR |
| IPPL_PLATO_MIT_HSL | PLATO-MIT | manual data delivery | Import data into the lookup table DWH$TA_L_MAP_PLATO_MIT_HSL |
| IPPL_PLATO_HSL_SAP | PLATO-MIT | manual data delivery (extracted from SAP) | Import data into the fact table DWH$TA_F_PLATO_MIT_HSL_SAP |
| ABPL_PLATO_MIT_BZ | PLATO-MIT | IVR | Enrichment and grouping of “gross addition” data (Bruttozugang) and storing them in the PLATO-MIT data mart. |
| ABPL_PLATO_MIT_KB | PLATO-MIT | IVR | Enrichment and grouping of “customer loyality“ data (Kundenbindung) and storing them in the PLATO-MIT data mart. |
| ABPL_PLATO_MIT_PV | PLATO-MIT | IVR | Enrichment and grouping of „commission” data (Provisionen) for the previous month and storing them in the PLATO-MIT data mart. |
| ABPL_PLATO_MIT_PV_P | PLATO-MIT | IVR | Enrichment and grouping of „commission” data (Provisionen) for the previous month and storing them in the PLATO-MIT data mart. |
| PFIS_PLATO_MIT_TARIF | PLATO-MIT | n.a. | Validation job: Check PLATO-MIT-Tarif-mapping against DWH$VI_L_MAP_TARIF and creation of dummy entries for missing mapping information in DWH$TA_L_MAP_PLATO_MIT_TAR |
| PFIS_PLATO_MIT_PART | PLATO-MIT | n.a. | Validation job: Check PLATO-MIT-mapping for commission types (Provisionsart) |
| PFIS_PLATO_MIT_HSL | PLATO-MIT | n.a. | Validation job: Check PLATO-MIT-mapping for SAP-account numbers (SAP-Kontonummern) |
| PFIS_PLATO_MIT_HSL_2 | PLATO-MIT | n.a. | Validation job: Check DWH$TA_L_MAP_PLATO_MIT_HSL for uniqueness of SAP_KONTO_HAL_RELEVANZ within a SAP_KONTO_UNTERGRUPPE |
| PFIS_PLATO_MIT_PV | PLATO-MIT | n.a. | Validation job: Check SCS_PROVISIONSART und SCS_VKOSTEN_KAT in table DWH$TA_F_SCS_PROV_BEW for the previous month against the table DWH$TA_L_MAP_PLATO_SCS_PART |
| PFIS_PLATO_MIT_PV_P | PLATO-MIT | n.a. | Validation job: Check SCS_PROVISIONSART und SCS_VKOSTEN_KAT in table DWH$TA_F_SCS_PROV_BEW against the table DWH$TA_L_MAP_PLATO_SCS_PART, month defined by parameter |
| PLATO_RENAME_TRIGGER_FILE_MIT_AUFBEREITUNG_BRUTTOZUGANG | PLATO-MIT | n.a. | Renames the file START_AUFBEREITUNG_BRUTTOZUGANG_*.txt to START_AUFBEREITUNG_BRUTTOZUGANG_*.lck The directory ~isdwhis/daten/dwh/plato/jobsteuerung/work contains the file. |
| PLATO_RENAME_TRIGGER_FILE_MIT_AUFBEREITUNG_KUBI | PLATO-MIT | n.a. | Renames the file START_AUFBEREITUNG_KUBI_*.txt to START_AUFBEREITUNG_KUBI_*.lck The directory ~isdwhis/daten/dwh/plato/jobsteuerung/work contains the file. |
| PLATO_RENAMEMOVE_TO_STORE_TRIGGER_FILE_MIT_AUFBEREITUNG_PROV | PLATO-MIT | n.a. | Renames the file START_AUFBEREITUNG_PROVISIONEN_????????.txt to START_AUFBEREITUNG_PROVISIONEN_????????.lck The directory ~isdwhis/daten/dwh/plato/jobsteuerung/work contains the file. |
| PLATO_RENAME_TRIGGER_FILE_MIT_AUFBEREITUNG_PROV_P | PLATO-MIT | n.a. | Renames the file START_AUFBEREITUNG_PROVISIONEN_PARAM_*.txt to START_AUFBEREITUNG_PROVISIONEN_PARAM_*.lck The directory ~isdwhis/daten/dwh/plato/jobsteuerung/work contains the file. |
| PLATO_MOVE_TO_STORE_TRIGGER_FILE_MIT_AUFBEREITUNG_BRUTTOZUGANG | PLATO-MIT | n.a. | Moves the file START_AUFBEREITUNG_BRUTTOZUGANG_*.lck from the work folder ~isdwhis/daten/dwh/plato/jobsteuerung/work in the store folder ~isdwhis/daten/dwh/plato/jobsteuerung/store and renames it to START_AUFBEREITUNG_BRUTTOZUGANG_*.txt |
| PLATO_MOVE_TO_STORE_TRIGGER_FILE_MIT_AUFBEREITUNG_KUBI | PLATO-MIT | n.a. | Moves the file START_AUFBEREITUNG_KUBI_*.lck from the work folder ~isdwhis/daten/dwh/plato/jobsteuerung/work to the store folder ~isdwhis/daten/dwh/plato/jobsteuerung/store and renames it to START_AUFBEREITUNG_KUBI_*.txt |
| PLATO_MOVE_TO_STORE_TRIGGER_FILE_MIT_AUFBEREITUNG_PROV | PLATO-MIT | n.a. | Moves the file START_AUFBEREITUNG_PROVISIONEN_????????.lck from the work folder ~isdwhis/daten/dwh/plato/jobsteuerung/work to the store folder ~isdwhis/daten/dwh/plato/jobsteuerung/store and renames it to START_AUFBEREITUNG_PROVISIONEN_????????.txt |
| PLATO_MOVE_TO_STORE_TRIGGER_FILE_MIT_AUFBEREITUNG_PROV_P | PLATO-MIT | n.a. | Moves the file START_AUFBEREITUNG_PROVISIONEN_PARAM_*.lck from the work folder ~isdwhis/daten/dwh/plato/jobsteuerung/work to the store folder ~isdwhis/daten/dwh/plato/jobsteuerung/store and renames it to START_AUFBEREITUNG_PROVISIONEN_PARAM_*.txt |
| IPTN_PART_PLATO_MIT | PLATO-MIT | n.a. | Monthly creation of a new partition with subpartitions for Plato MIT |
Job execution scripts (no longer necessary to fill)
| Script | Parameters | Stored in directory | ||
|---|---|---|---|---|
| Flag | Value | Description | ||
New Jobs for chapter 5 and 6
Fill out the Excel Sheet: ahb_dwh_<rel_nr>_<topic>.xls
and copy from the installation manual the job description!
<Jobname 1 = Job ID1>
IPPL_PLATO_SCS_PART
| Job ID UC4 (log file relevant) | IPPL_PLATO_SCS_PART | |
|---|---|---|
| Job ID (dwh$ta_k_meldungen) | IPPL_PLATO_SCS_PART | |
| Titel UC4 | Import data into the lookup table DWH$TA_L_MAP_PLATO_SCS_PART | |
| Description | Import data into the lookup table DWH$TA_L_MAP_PLATO_SCS_PART | |
| forerunner job | first job in jobplan | |
| Precondition | n.a. | |
| Dataflow | Source | ~isdwhis/daten/dwh/plato/work/MIT_PLATO_SCS_PART*.csv |
| Destination | DWH$TA_L_MAP_PLATO_SCS_PART | |
| Cube names in ppes | n.a. | |
| Cube target directory | n.a. | |
| In case of abort | Analyze the problem and restart | |
| In case of failure | Analyze the problem and restart | |
| Schedule / jobplan name | PLATO_MIT_IMPORT_PROV_ART_MAPPING_TAEGLICH_JP | |
| Estimated Runtime | < 5 minutes | |
| Script Parameter | -h shows the help page -k name of the configuration file (including pathname) [-m] File mask (optional), overwrites the value given in the configuration file [-p] optional parameters for the “data moving” script [-j] job ID (optional), overwrites the value given in the configuration file -v verbose (in case of an error the log file is displayed) |
|
| UC4 Call (Unix syntax) | $HOME/aktuell/import/is/bin/r_ipis_exttab -k $HOME/aktuell/import/pl/cfg/h_ippl_ext_plato_scs_part.var | |
| Corresponding Jobs / Jobplan(s) | n.a. | |
| Person in charge | Thomas Kernchen / Dorothea Horst | |
| Creation Date | Date of installation | |
| Date of Changes | n.a. |
IPPL_PLATO_MIT_TAR
| Job ID UC4 (log file relevant) | IPPL_PLATO_MIT_TAR | |
|---|---|---|
| Job ID (dwh$ta_k_meldungen) | IPPL_PLATO_MIT_TAR | |
| Titel UC4 | Import data into the lookup table DWH$TA_L_MAP_PLATO_MIT_TAR | |
| Description | Import data into the lookup table DWH$TA_L_MAP_PLATO_MIT_TAR | |
| forerunner job | first job in jobplan | |
| Precondition | n.a. | |
| Dataflow | Source | ~isdwhis/daten/dwh/plato/work/PLATO_MIT_TAR*.csv |
| Destination | DWH$TA_L_MAP_PLATO_MIT_TAR | |
| Cube names in ppes | n.a. | |
| Cube target directory | n.a. | |
| In case of abort | Analyze the problem and restart | |
| In case of failure | Analyze the problem and restart | |
| Schedule / jobplan name | PLATO_MIT_IMPORT_TARIF_MAPPING_TAEGLICH_JP | |
| Estimated Runtime | < 5 minutes | |
| Script Parameter | -h shows the help page -k name of the configuration file (including pathname) [-m] File mask (optional), overwrites the value given in the configuration file [-p] optional parameters for the “data moving” script [-j] job ID (optional), overwrites the value given in the configuration file -v verbose (in case of an error the log file is displayed) |
|
| UC4 Call (Unix syntax) | $HOME/aktuell/import/is/bin/r_ipis_exttab -k $HOME/aktuell/import/pl/cfg/h_ippl_ext_plato_mit_tar.var | |
| Corresponding Jobs / Jobplan(s) | n.a. | |
| Person in charge | Thomas Kernchen / Dorothea Horst | |
| Creation Date | Date of installation | |
| Date of Changes | n.a. |
IPPL_PLATO_MIT_HSL
| Job ID UC4 (log file relevant) | IPPL_PLATO_MIT_HSL | |
|---|---|---|
| Job ID (dwh$ta_k_meldungen) | IPPL_PLATO_MIT_HSL | |
| Titel UC4 | Import data into the lookup table DWH$TA_L_MAP_PLATO_MIT_HSL | |
| Description | Import data into the lookup table DWH$TA_L_MAP_PLATO_MIT_HSL | |
| forerunner job | first job in jobplan | |
| Precondition | n.a. | |
| Dataflow | Source | ~isdwhis/daten/dwh/plato/work/PLATO_MIT_HSL_????????.csv |
| Destination | DWH$TA_L_MAP_PLATO_MIT_HSL | |
| Cube names in ppes | n.a. | |
| Cube target directory | n.a. | |
| In case of abort | Analyze the problem and restart | |
| In case of failure | Analyze the problem and restart | |
| Schedule / jobplan name | See PLATO_MIT_IMPORT_HSL_MAPPING_TAEGLICH_JP | |
| Estimated Runtime | < 5 minutes | |
| Script Parameter | -h shows the help page -k name of the configuration file (including pathname) [-m] File mask (optional), overwrites the value given in the configuration file [-p] optional parameters for the “data moving” script [-j] job ID (optional), overwrites the value given in the configuration file -v verbose (in case of an error the log file is displayed) |
|
| UC4 Call (Unix syntax) | $HOME/aktuell/import/is/bin/r_ipis_exttab -k $HOME/aktuell/import/pl/cfg/h_ippl_ext_plato_mit_hsl.var | |
| Corresponding Jobs / Jobplan(s) | n.a. | |
| Person in charge | Thomas Kernchen / Dorothea Horst | |
| Creation Date | Date of installation | |
| Date of Changes | n.a. |
Edit | Attach | Print version | History: r1 | Backlinks | View wiki text | Edit wiki text | More topic actions
Topic revision: r1 - 05 Jul 2012, HorstMueller
 |
|
The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. see CopyrightStatement. 
