Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
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
maxLevel3

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


Loading Script

ObjectFilter ValueExplanation

It is loaded by following Dataiku script

View file
namebw_orders_query (dataiku script).txt
height250