The objective is to have some inventories queries. These queries will be used with Qlik.
Describe in a few words the content of application + link with functional or technical specifications (google links) done with during the project or linked with PPMO
Tool Leader + IT leader of the application: Name of project or main leader for the application + reporting coodinator
How many users? Which user category ? Is there critical period ? Which geographical perimeter? Describe in one sentence: around 50 users, worldwide or 200 users / European Site
Provide some history of the application : When was it created ? What was the initial project ? Who was the original requestor ? If possible provide link to the project information
List of application role + menu role and explanation if we have several applications role with specials rules.
| Role Code | Role Description | Explanation |
|---|---|---|
List of autorisation objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
Reporting documentation drive folder:
https://drive.google.com/drive/folders/0B0qn89R0RGdqYkZZOFZyYXlXVkE
Exemple of dataflow overview :
Template Application name DataFlow
Update InfoProvider :
Infocube CRMMIC01 and multiprovider MVMMIC01 : add characteristics C_MOVETY, 0DCINDIC and C_PRODORD and key-fugures K_MOVEQTY and K_MOVEVAL
Infocube CRMMIC01, CRMMIC02 and multiprovider MVMMIC01, MVMMIC02 add navigation attributes
multiprovider MVFIWC01 : any modification
Multiprovider MVSDSO44 : add navigation attributes
Infocube CUB_IC001, CUB_IC002 and CUB_COPC1 and multiprovider MPR_IC001 : add navigation attributes
Infocube : add navigation attributes
Update DSO :
DSO DBMMIC07 : add characteristics C_MOVETY, 0DCINDIC and C_PRODORD and key-fugures K_MOVEQTY and K_MOVEVAL
Detail of main topics with explanations of the rules and only the main + special rules about queries to run and use in the correct way
Dependencies with other application (BW, QV, Externals tools like PVelocity or Dynasis etc...
Detail of process chain, list + link between or special event done for the loading
Detail of frequency : monthly; weekly or else
if possible, give some information on average process chain duration, amount of data loaded and total data volume example: daily process chain loaded in 30 min, weekly chain loaded in 1h15, with around 2k to 10k lines in DELTA mode for a total of 10M lines in cube. The purpose is to give a general overview of the volume of data managed y the application
| Key Figure | Estimation |
|---|---|
| ~ Average Process Chain Runtime | |
| ~ Average nb of rows loaded per load | |
| ~ Total nb of rows loaded (if full) | |
| ~ Average Runtime for 10k lines |
Give details if any historisation is done, example: keep only data greater than beginning of Y-3
Query end user documentation should be created in the public "Customer Support Wiki" space under the corresponding BW application page : BW - Application. Technical query query documentation, if necessary should be added as a sub-page of this documentation using the BW Technical Query Documentation template.
Master Data
QV_C_MATNR2_0001 QV - Material Master Data
A query on material (C_MATNR with LOGSYS) to have the atributes of material (example : C_PROD → Commercial Product / Material Group)
QV_C_MATPNT2_0001 QV - Material Plant Master Data
A query on material (C_MATPNT2 with LOGSYS and PLANT) to have the atributes of material/plant (example : CPFCTR1_2 → BFC Global Business Unit)
QV_C_MATPNT3_0001 QV - Material valuation class
A query on material (C_MATPNT3 with LOGSYS and PLANT) to have the atributes of material/plant (example : C_VALCLAS → Valuation class)
Solvay Data
QVSBS_BW_QRY_MPR_IC001_0003 BW - Stock Movement All Types (Core query) Qlik : a query on material/stock movement
Charactéristics : material informations with batch information
Key figures : Quantity Total Stock (Qty)
QVSBS_BW_QRY_MPR_IC001_0004 BW - Stock Movement All Types (Core query) Qlik
Charactéristics : material informations without batch information
Key figures : Quantity Total Stock (Qty), Good Receipt (Qty), Global Consumption (Qty), Global Sales (Qty), ValStockValue (Eur), Good Receipt (Eur), Global Consumption (Eur), Global Sales (Eur) and Counter
Rhodia data
QVSBS_BW_QRY_MVMMIC01_0001 BW - Inventory Management - Stock Movement (Core Query) : a query on material/stock movement
Charactéristics : material informations with batch information
Key figures : Quantity Total Stock (Qty)
QVSBS_BW_QRY_MVMMIC01_0002 BW - Inventory Management - Stock Movement (Core Query)
Charactéristics : material informations without batch information
Key figures : Quantity Total Stock (Qty), Good Receipt (Qty), Global Consumption (Qty), Global Sales (Qty), ValStockValue (Eur), Good Receipt (Eur), Global Consumption (Eur), Global Sales (Eur) and Counter
Rhodia / Solvay data
QVSBS_BW_QRY_MVSDSO44_0001 QV - Sales follow up -All
Charactéristics : sales informations
Key figures : Billed QTY and Total billing w/o taxes
QVSBS_BW_QRY_MVSDSO42_SD001 QV - Historical data: PO's invoices (core)
Charactéristics : sales informations
Key figures : Billed QTY and Total billing w/o taxes
QVSBS_BW_QRY_MVFIWC01_0001 BW - Working Capital Inventories (Core Query)
Give detail on all complex functionalities: list most important and/or complex KPI, query jump, alerts
Indicate if there are broadcasts and give some details on the broadcast settings.
Give the list and explanation on the known, not-solved, bugs.
List recurring procedures
Detail planned major evolution if already known. Example: complete decommissioning of application is planned in 2017 / Extension to solvay perimeter planned in 2nd semester of 2016