| Info |
|---|
This query is created for project SPPsalesForecast which requested by Carolina Camacho serrano to extract data to Dataiku. The developer who create script (Python) is Adrien Ruel |
Description | BW Sales - OTIF - (Dataiku Forecast) |
|---|---|
| Technical Name | DI_BW_QRY_MVSDSO50_9001 DI_BW_QRY_MVSDSO44_SD0003 |
Application | SD - Sales and Distribution |
Info-provider | MVSDSO50 and MVSDSO44 |
Usage type | Dataiku extraction |
Expected users |
| Table of Contents | ||
|---|---|---|
|
Workbook/Query General Description
DI_BW_QRY_MVSDSO50_9001 is copied again from the core query BW_QRY_MVSDSO50_0001. Some how query DI_BW_QRY_MVSDSO50_0001, which created by CGI does not work.
DI_BW_QRY_MVSDSO50_0001 should be deleted
General parameters
Global properties
Same as cored query just adding OLE DB for OLAP flag and add Product Line (C_MATNR2__0CRM_PROD) and the Ship-To Country (C_SHIPTID__0COUNTRY)
Variables
Definitions
Variable Name
Selection Type
Required
Description/Explanation
Variable Sequence
Loading Script
Filters| Object | Filter Value | Explanation |
|---|
Key figures
Key Figure 1
Description
Calculation rule detail
Text Replacement Variable
Currency Conversion
Exchange Rate Type :
Currency :
Time Reference :
Unit Conversion
Unit :
Characteristics
Cells
Conditions
Active
By default
Key Figure
(Structure)
It is loaded by following Dataiku script
| View file | ||||
|---|---|---|---|---|
|
Exceptions
Active
By default
Alert Level
Other parameters
(if different from default)