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	Ex: GBU zone and WW controllers

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

TECHNO - BI TEAM > Dataiku - SPP Sales Forecast > image2022-7-18_12-26-55.png

Loading Script

Object	Filter Value	Explanation
Ex : Status of the trading partner	Ex : <> 1	Ex : Exclude intercompanies

It is loaded by following Dataiku script