BPC320_EN_Col91_FV_Part_A4 (第6页)

第 351 页 / 共 377 页

BPC320 Lesson: Labs

Figure 465: Example 11

5.Navigating the Insight Dashboard

1.

Fromthetopofyourscreen,clicktheInsight icon.

2. Verifyyourscreenlookssimilartothefollowing:

Figure 466: Example 12

3. FromtheActionPane, selectChangethisview.

4. FromtheActionPane,deselecttheSALESapplication.

5.

FromtheActionPane,clickthegreencheck button.

6. Verifyyourscreenlookssimilartothefollowing:

Figure 467: Example 13

7. Selecttheplussign(+)toexpandtheOperatingIncomeaccount.

8. SelectTotalDepartmentalExpenseandscrolldowntoviewthebarchart.

9. FromtheSelectChartTypedrop-downlistbox,selectLineChart.

10. Verifythatyourdashboardlookssimilartothefollowing:

333

第 352 页 / 共 377 页

Unit6: Labs BPC320

Figure 468: Example 14

11. Fromtheupperrightcornerofthechartarea,selecttheXtoclosethechart.

12. SelecttheTotalRevenuevalueinthe2008AUGACTUALcolumnto

generate the Variance Analysis Window.

13. Verifythatyourdashboardlookssimilartothefollowing:

Figure 469: Example 15

14. Click Store21 in the variance analysis window and note that dimension

references are displayed.

15. Fromtheupperrightcornerofthevarianceanalysiswindow,selecttheX

to close the window.

6.

Building a Report

1. FromtheActionPane, selectBuildreport.

2. Setyourreportfilteroptionsasshownbelow.

334

第 353 页 / 共 377 页

BPC320 Lesson: Labs

Figure 470: Example 16

3. Click the View Report button.

4. Verifyyourscreenlookssimilartothefollowing:

Figure 471: Example 17

5. Fromtheupperleftcornerofyourscreen, whereitreadsDashboard>>

Insight Report, click the Dashboard link.

7.Defining Alerts

1. FromtheActionPane, selectMaintainAlerts.

2. In the Action Pane, ensure the Select an application field is set to

FINANCEandclickthegreencheck button.

3. From the Action Pane, select Add alert.

4. Define an alert as shown below:

335

第 354 页 / 共 377 页

Unit6: Labs BPC320

Figure 472: Example 18

5.

Click the green check button.

6. Fromtheupperleftcornerofyourscreen,whereitDashboard>>Maintain

Alerts–FINANCE,clicktheDashboardlink.

7. Verifythatyourdashboardlookssimilartothefollowing:

Figure 473: Example 19

8.

ClicktheAlertsymbol ontheOperatingIncomerow.

9. FromtheShowAlertdialogbox,clicktheClosebutton.

8.Using the Prediction View

1.

From the Insight Dashboard, click the Predictor symbol next to

Operating Income.

2. Verifyyourscreenlookssimilartothefollowing:

336

第 355 页 / 共 377 页

BPC320 Lesson: Labs

Figure 474: Example 20

3. Fromtherightsideofthepredictorwindow,clickViewGraph.

4. In the Change Scenario Assumptions dialog box, leave the algorithm

selectionasisandclickthegreencheck button.

5. Whenfinishedviewingthegraph,fromtheupperrightcornerofthegraph

window, select the X.

6. Whenfinishedviewingtheprediction,fromtheupperrightcornerofthe

predictor window, select the X.

9.Using the Radar View

1. Fromthe Action Pane, selectView Radar.

2. VerifythatyourRadarlookssimilartothefollowing:

Figure 475: Example 21

3. ClickPlaytoautomaticallyscrollthroughdifferentmonths.

4. Click Stop to stop the scrolling.

5. FromtheActionPane,selectViewDashboardtoreturntothedashboard

view.

6. FromtheFilemenu,selectClosetocloseBPCWeb.

337

第 356 页 / 共 377 页

Unit6: Labs BPC320

Lesson Summary

You should now be able to:

•

338

第 357 页 / 共 377 页

BPC320 Unit Summary

Unit Summary

You should now be able to:

•

339

第 358 页 / 共 377 页

UnitSummary BPC320

340

第 359 页 / 共 377 页

第 360 页 / 共 377 页

第 361 页 / 共 377 页

BPC320 Course Summary

Course Summary

You should now be able to:

• –

341

第 362 页 / 共 377 页

CourseSummary BPC320

342

第 363 页 / 共 377 页

Appendix 1

Insight

Figure 476: Insight Overview

AnyAccountdimensionmemberorparentcanbechosenasa“KPI”–NetIncome

for example.

Figure 477: Insight Administration Overview

343

第 364 页 / 共 377 页

Appendix1: Insight BPC320

Figure 478: Enabling Insight

Figure 479: Manage Insight

344

第 365 页 / 共 377 页

BPC320 Appendix 1: Insight

Figure 480: Configuring Insight

Figure 481: Synchronize

YoushouldsynchronizeeverytimeyouupdateyourActualsfromyourGL,when

youfinalizeabudget. Thosearenothardandfastrules, butthegoalistohave

updated information.

345

第 366 页 / 共 377 页

Appendix1: Insight BPC320

Figure 482: Current Time Period

Currenttimeperiodbecomesthedefaulttimeperiodforthedashboard,butusers

can override this.

Figure 483: Variance Category

346

第 367 页 / 共 377 页

BPC320 Appendix 1: Insight

Figure 484: Measures Type

Figure 485: Predictor Algorithm

Predictive Analysis: This is the hardest one to convey. PA might better be

understood by saying what it does not do. Its not creating a forecast. Its not

looking at your trend in A/R and predicting an A/R value for next month and

addingupthosevaluestotellyouwhatavaluewillbenextmonth. Instead,its

lookingforrelationshipsbetweenyourKPIsandeverythingelseinthecube,over

time. So lets say your KPI is customer satisfaction, the software might notice

theresacorrelationwithonemonthlagbetweenajumpinA/Randadeclinein

customer satisfaction. Happy customers pay their bills in a traditional setting,

customersatisfactionisnotaparentofA/R,sothatwouldnevershouldup,but

347

第 368 页 / 共 377 页

Appendix1: Insight BPC320

Insightisnotlookingforthatkindofrelationship. Itslookingforanyrelationship

it can find. And it makes a prediction based on that. Its only going to try and

correlatethethingsyouvedesignatedasKPIs. Itsnotexact.

Figure 486: Predictor Algorithm (continued)

Linear Regression

Linearregressionattemptstomodeltherelationshipbetweentwovariablesby

fitting a linear equation to observed data. One variable is considered to be an

explanatory variable, and the other is considered to be a dependent variable.

Forexample,amodelermightwanttorelatetheweightsofindividualstotheir

heightsusingalinearregressionmodel. Beforeattemptingtofitalinearmodel

to observed data, a modeler should first determine whether or not there is a

relationshipbetweenthevariablesofinterest. Thisdoesnotnecessarilyimplythat

onevariablecausestheother(forexample,higherSATscoresdonotcausehigher

college grades), but that there is some significant association between the two

variables. Ascatterplotcanbeahelpfultoolindeterminingthestrengthofthe

relationshipbetweentwovariables. Ifthereappearstobenoassociationbetween

theproposedexplanatoryanddependentvariables(i.e.,thescatterplotdoesnot

indicate any increasing or decreasing trends), then fitting a linear regression

modeltothedataprobablywillnotprovideausefulmodel. Avaluablenumerical

measure of association between two variables is the correlation coefficient,

whichisavaluebetween-1and1indicatingthestrengthoftheassociationof

the observed data for the two variables.

AlinearregressionlinehasanequationoftheformY=a+bX,whereXisthe

explanatoryvariableandYisthedependentvariable. Theslopeofthelineisb,

andaistheintercept(thevalueofywhenx=0).

348

第 369 页 / 共 377 页

BPC320 Appendix 1: Insight

Figure487: AdvancedParameterConfigurations

Figure 488: Manage Users

349

第 370 页 / 共 377 页

Appendix1: Insight BPC320

Figure 489: Key Performance Indicator (KPI)

Figure 490: Creating a KPI: Step 1

350

第 371 页 / 共 377 页

BPC320 Appendix 1: Insight

Figure 491: Creating a KPI: Step 2

Figure 492: Creating a KPI: Step 3

351

第 372 页 / 共 377 页

Appendix1: Insight BPC320

Figure 493: The Dashboard

Figure 494: The Variance Analysis Window

352

第 373 页 / 共 377 页

BPC320 Appendix 1: Insight

Figure 495: Reasons

Reasons: uptotop3. Softwareisdoingwhatyouwoulddoifyouhadthetime,

going through webexcel, and following every branch of the tree from top to

bottomtofindthevarianceslowestdowninthecubetodeterminewhatscausing

thevariancehighup, everypossiblecombination, muchlesstimethanittakes

you to do it.

Figure 496: Root Causes

353

第 374 页 / 共 377 页

Appendix1: Insight BPC320

RootCauses: LooksforpatternsintheRCEtablebydoingacorrelationanalysis

that matches the patterns in your reasons, variables that correspond to your

reasons. It will mine the transactional and operational data stored in the RCE

table for the root causes of your variances. Transactional data = invoice data.

Operationaldata=temperatures,powerplantdowntime,non-financialdata. For

example, for an energy company, when its cold, you earn a lot of revenue. So

whatyouputintheRCEtabledetermineswhatitsgoingtolookfor,typicallyyour

transactionleveldetail,whichtransactionsreallykilled.

Figure 497: Contexts & Actions

Variance Context: Google-like search of files posted to the Supporting

DocumentsBoardandtheBulletinBoard. Useswordfrequency,ignoresthe/of,

looksforhowclosethewordsaretoeachotherinthedocument.

Figure 498: Charting

354

第 375 页 / 共 377 页

BPC320 Appendix 1: Insight

Figure 499: Alerts

Figure 500: KPI at Risk

355

第 376 页 / 共 377 页

Appendix1: Insight BPC320

Figure 501: The Predictor View

Figure 502: The Radar

Lab 43 – Insight

(part of the lab unit)

356

第 377 页 / 共 377 页

Feedback

SAP AG has made every effort in the preparation of this course to ensure the

accuracy and completeness of the materials. If you have any corrections or

suggestionsforimprovement,pleaserecordthemintheappropriateplaceinthe

course evaluation.

357