2016-09-16 - 28042 - Rel Notes - sales anlysis query formula field - Release 001 #2016BIReleaseNotes
Release Notes
28042 - sales analysis query formula field
Admin Info
Purpose
|
Need to add new fields gross profit for TY and LY to 'North America Sales Analysis' explorer
|
Release No
|
001
|
Submitted
|
09/23/2016
|
Submitted by
|
Venkateswara Reddy D
|
Source/Destination Systems
|
IT->BMS->Development folder in BI production Server
|
Release Sent To
|
Saravanan Lakshmanan
|
Object(s) Created By
|
Venkateswara Reddy D
|
Object(s) Tested By
|
Uday Kumar
|
Report Name
North America Sales Analysis Explorer.
Name of the BEx Query
ZBPC_MP_Q020
Summary Level Check
Test Conducted
SNo
|
Test Case
|
Value in Explorer
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Gross Profit TY(Quarter1)
|
63,752,836.25
|
63,752,836.25
|
Pass
|
2
|
Gross Profit LY(Quarter1)
|
49,873,496.24
|
49,873,496.24
|
Pass
|
3
|
Gross Profit TY(Period 1)
|
17,938,310.08
|
17,938,310.08
|
Pass
|
4
|
Gross Profit LY(Period 1)
|
10,285,364.71
|
10,285,364.71
|
Pass
|
Reference Document(BreakFix)
2016-09-16 - 28042 - Break Fix - Sales Analysis query formula field