The objective of this documentation is not to allow to recreate from scratch the object but to explain everything that is not obvious by looking directly at the query/workbook or emphases on things that are important for the report to work.

Remove the sections that are not relevant.

Description	BW - DP - Budget Review (Core query)
Technical Name	BW_QRY_MVDYN11_0001
Application	DP - Demand Planning
Info-provider	MultiProvider MVDYN11
Usage type	Direct execution via Analysis
Expected users	Ex: GBU zone and WW controllers

Workbook/Query General Description

Enter some description to explain what is the purpose of this query/workbook and who/how it will be used.

General parameters

Global properties

Tab	Screenshot	Comment
Display	$TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2017-12-14 10:31:46.png$
Rows/Columns	$TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2017-12-14 10:31:23.png$
Value Display	$TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2017-12-14 10:30:53.png$
Planning	$TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2017-12-14 10:30:5.png$
Extended	$TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2016-11-4 16:18:11.png$

Variables

Definitions

Same axis than DR/FA queries

Variable Name	Info-object	Selection Type	Required	Description/Explanation

Variable Sequence

$TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2017-12-14 10:29:2.png$

Filters

Object	Filter Value	Explanation
InfoProvider (0INFOPROV)	= DYN Reporting (CRDYN11)
Concerned Period (C_FLGMTH)	= 'M'	Only current values are requiered

Key figures

All keyfigures without decimals as in Dynasys

KeyFigures of the Demand Review + following ones

Exchange rate type = CAR4

Description	type	Source	Calculation rule	Conversion
Sales Team Forecast ETD	Display	DynaSys Table EXP_FORE_DR field STF_ETD	Ratio K_DYN_044	QCT_MATNR5
Sales Team Price	Display		$TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2017-12-14 10:39:10.png$
Nb DC	Hidden		constant = 1 $TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2017-12-14 10:33:50.png$
Nb BU	Hidden		constant = 1 $TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2017-12-14 10:35:37.png$
Nb Period	Hidden		constant = 1 $TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2017-12-14 10:36:14.png$
Nb Material	Hidden		constant = 1 $TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2017-12-14 10:36:50.png$
Nb Ship-to (including Prospects)	Hidden		constant = 1 $TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2017-12-14 10:37:23.png$
Sales Team Price Value	Hidden	DynaSys Table EXP_FORE_DR field ST_PRICE	Ratio K_FFEUR	CTK_CAR4_M
Sales Team Forecast Value ETD	Display	DynaSys Table EXP_FORE_DR field STF_VALUE_ETD	Ratio K_DYN_031	CTK_CAR4_M
Sales Team Contribution Margin ETD	Display	DynaSys Table EXP_FORE_DR field ST_CONTRIBUTION_	Ratio K_DYN_045	CTK_CAR4_M
Sales Team Gross Margin ETD	Display	DynaSys Table EXP_FORE_DR field ST_GROSS_MARGIN_	Ratio K_DYN_033	CTK_CAR4_M
Final Forecast ETD	Display	DynaSys Table EXP_FORE_DR field FF_ETD	Ratio K_DYN_034	QCT_MATNR5
Final Forecast Contribution Margin	Display	DynaSys Table EXP_FORE_DR field FF_CONTRIBUTION_	Ratio K_DYN_046	CTK_CAR4_M
Final Forecast Gross Margin	Display	DynaSys Table EXP_FORE_DR field FF_GROSS_MARGIN	Ratio K_DYN_047	CTK_CAR4_M
Budget Contribution Margin	Display	DynaSys Table EXP_FORE_DR field BUDGET_CONTRIBUT	Ratio K_DYN_048	CTK_ZRHO3M
Budget Gross Margin	Display	DynaSys Table EXP_FORE_DR field BUDGET_GROSS_MAR	Ratio K_DYN_030	CTK_CAR4_M
BFR6 Contribution Margin	Display	DynaSys Table EXP_FORE_DR field BFR6_CONTRIBUTIO	Ratio K_DYN_032	CTK_CAR4_M
BFR6 Gross Margin	Display	DynaSys Table EXP_FORE_DR field BFR6_GROSS_MARGI	Ratio K_DYN_020	CTK_CAR4_M

Characteristics

Same axis than DR/FA queries

Location	Info-object Name	Info-object Text	Explanation (if needed)

Cells

If you have 2 structures and special cells calculations, explain here.

Conditions

If you have conditions, explain here.

Condition Name

Active

By default

Key Figure

(Structure)

Operator

Value

Characteristic Assignement

Ex : Excl if <=10

Yes/No

Sales Value

Greater Than

10

Ex : All Independently

Exceptions

If you have conditions, explain here.

Exception Name

Active

By default

Alert Level

Operator

Value

Other parameters

(if different from default)

Ex : Red if <=10

Yes/No

Bad 3

Lesser Than

10