15.24 Close reports Close both reports without saving Reports close without error. changes → → 15.25 Use Trend report to Choose EPM Open Open Server 10 TREND.XLTX Report opens without error. → → validate Net Income Report Folder Company folder - USD WEBEXCEL\REPORTLIBRARY\10 TREND.XLTX 15.26 Set Context and Set the Context and Refresh report P_ACCOUNT = Selections are applied and the report is check results refreshed. Leave the report open Company Code = Report should show YTD value for Net Currency = USD Income for each month Version = Time = Measures = YTD All other dimensions = ALL → → 15.27 Use Trend report to Choose EPM Open Open Server 10 TREND.XLTX Report opens without error. → → validate Net Income Report Folder Company folder – EUR on the BS WEBEXCEL\REPORTLIBRARY\10 TREND.XLTX 15.28 Set the Context and Refresh report P_ACCOUNT: Report refreshes without error A_RE_YTDNetIncome - Net Income in the BS 15.29 Verify results using a Trend Report Result should be equal to (LC Value * EUR AVG Rate) Leave the report open → → 15.30 Use Trend report to Choose EPM Open Open Server 10 TREND.XLTX Report opens without error. → → check CTA on Net Report Folder Company folder Income value WEBEXCEL\REPORTLIBRARY\10 TREND.XLTX 15.31 Change the Context selection for P_ACCOUNT = Report refreshes without error Account and select Refresh A_CTAdj - CTA on Net Income 15.32 Verify the results using a Trend report Result should be equal to [(LC Value * GBP END Rate) - (LC Value * GBP AVG Rate)]
15.24 Close reports Close both reports without saving changes Reports close without error. 15.25 Use Trend report to validate Net Income - USD Choose EPM → Open → Open Server Report Folder → Company folder → WEBEXCEL\REPORTLIBRARY\10 TREND.XLTX 10 TREND.XLTX Report opens without error. 15.26 Set Context and check results Set the Context and Refresh report Leave the report open P_ACCOUNT = Company Code = Currency = USD Version = Time = Measures = YTD All other dimensions = ALL Selections are applied and the report is refreshed. Report should show YTD value for Net Income for each month 15.27 Use Trend report to validate Net Income – EUR on the BS Choose EPM → Open → Open Server Report Folder → Company folder → WEBEXCEL\REPORTLIBRARY\10 TREND.XLTX 10 TREND.XLTX Report opens without error. 15.28 Set the Context and Refresh report P_ACCOUNT: A_RE_YTDNetIncome - Net Income in the BS Report refreshes without error 15.29 Verify results using a Trend Report Leave the report open Result should be equal to (LC Value * EUR AVG Rate) 15.30 Use Trend report to check CTA on Net Income value Choose EPM → Open → Open Server Report Folder → Company folder → WEBEXCEL\REPORTLIBRARY\10 TREND.XLTX 10 TREND.XLTX Report opens without error. 15.31 Change the Context selection for Account and select Refresh P_ACCOUNT = A_CTAdj - CTA on Net Income Report refreshes without error 15.32 Verify the results using a Trend report Result should be equal to [(LC Value * GBP END Rate) - (LC Value * GBP AVG Rate)]
A93_BPC101_BPD_EN_XX.docx