2013-05-08 - 5579.600 - Rel Notes - EPM Reports - Release 003 #BIReleases2013

Release Notes:

5579.600 - EPM230 Product Mix Scorecard

EPM231 Product Mix Scorecard North America

EPM232 Product Mix Scorecard Emerging Markets

EPM233 Product Mix Scorecard EMEA


Admin Info

Purpose
 Need to Correct Coverage % LY YTD, Coverage % LY Total and LY Variance formulas.
Release No
 003
Submitted
 05-08-2013
Submitted by
 Mallareddy D
Source/Destination Systems
 Remote Machine > Report > Enterprise Performance Mgmt
Remote Machine > Report > Enterprise Performance Mgmt > North America
Remote Machine > Report > Enterprise Performance Mgmt > Emerging Markets
Remote Machine > Report > Enterprise Performance Mgmt > EMEA in BI 4.0 Dev Environment
Release Sent To
 Ashwin Shantikumar Kucheriya
Object(s) Created By
 Mallareddy D
Object(s) Tested By
 Uday Kumar P

Report Name

EPM230 - Product Mix Scorecard
EPM231 - Product Mix Scorecard North America
EPM232 - Product Mix Scorecard Emerging Markets
EPM233 - Product Mix Scorecard EMEA

BEx Query

ZMP_OPASA_Q001

Issue Validation Check

Test Conducted

Group: Region > Product Mix > Sales Org : North America > Headwear > United States Sales
SNo
 Field Name
 Formula
 Calculation
 Report Value
 Pass/Fail
1
 Coverage % for LY YTD
 Actual Revenue Shipped Current YTD/ Actual Revenue Shipped Last Year YTD * 100
 124957455/ 124094951 * 100 = 100.7 %
 100.1 %
 P
2
 Coverage % for LY Total
 Total Revenue Current Year/ Total Revenue Last Year * 100
 241634572/ 405122596 * 100 = 59.6 %
 59.6 % %
 P
3
 LY YTD Variance
 Actual Revenue Shipped Current YTD - Actual Revenue Shipped Last Year YTD
 124957455 - 124094951 = 862504
 862504
 P

Reference Document(Specification)

2013-10-01 - 5579.600 - Break Fix - EPM Reports