BPC320_EN_Col91_FV_Part_A4 (第5页)

第 308 页 / 共 377 页

Unit6: Labs BPC320

4 Seeding the Budget

1. Select eData → Run package.

2. SelecttheImportpackageandthenclicktheRunbutton.

3.

IntheImportfilefield,clicktheSelect button.

4. SelecttheFinanceActual2008.txtandthenclicktheOpenbutton.

5.

IntheTransformationfilefield,clicktheSelect button.

6. SelecttheActtoBudwithIncreasefileandthenclicktheOpenbutton.

7. LeavetheremainingfieldsasisandclicktheNextbutton.

8. SelecttheNo,donotcheckworkstatussettingsradiobuttonandclick

the Finish button.

9. Whenprompted,“Therequesttorunthepackage…”clickOK.

10. FromtheDataManagerdialogbox,clicktheViewstatusbutton.

11. SelecttheRefreshStatuseverycheckbox. Thiswillrefreshthedisplay

every 5 seconds, by default.

12. After a few moments, verify that your Package Status window looks

similar to the following:

Figure 406: Package Status 2

13. ClicktheClosebuttontoclosethePackageStatusdialogbox.

14. SelecttheImportpackageandthenclicktheRunbutton.

15.

IntheImportfilefield,clicktheSelect button.

16. SelecttheFinanceBudget2008.txtandthenclicktheOpenbutton.

17.

IntheTransformationfilefield,clicktheSelect button.

18. SelecttheBudtoBudwithIncreasefileandthenclicktheOpenbutton.

19. LeavetheremainingfieldsasisandclicktheNextbutton.

20. SelecttheNo,donotcheckworkstatussettingsradiobuttonandclick

the Finish button.

21 Whenprompted,“Therequesttorunthepackage…”clickOK.

290

第 309 页 / 共 377 页

BPC320 Lesson: Labs

22 FromtheDataManagerdialogbox,clicktheViewstatusbutton.

23 SelecttheRefreshStatuseverycheckbox. Thiswillrefreshthedisplay

every 5 seconds, by default.

24 After a few moments, verify that your Package Status window looks

similar to the following:

Figure 407: Package Status 3

25. ClicktheClosebuttontoclosethePackageStatusdialogbox.

26. ClicktheCancelbuttontoclosetheDataManagerdialogbox.

5. Creating a Verification Report

1. Usingthereportingskillsyougainedinpreviouslabs,andthehintsbelow,

create the following EVDRE report.

291

第 310 页 / 共 377 页

Unit6: Labs BPC320

Figure 408: Example

Note: Your values may vary.

Hint:

• IntheEVDREBuilder,choosetheTimeandCategorydimensions

for the columns.

• EnsureyourPageKeyselectionsmatchthescreenshotabove.

• Intherows,showbaselevelmembers,andthenExpand.

• IncellA1,deletetheExpandRangefromtheEVDREformula.

• TypetheappropriatememberIDsintheColKeyRangeandRefresh

your report to update the data.

• Insertcolumnsandaddformulasforvariancecalculationsasneeded.

• Manuallyformatyourreportasshowninthescreenshotabove.

2. SavethereportasLab33–SeedingtheBudgetintheeExcel→Reports

→ \Manager folder on the server.

3. ClosethereportandselectFile→ExittocloseBPCforExcel.

Lab 34 – Creating the External Sales Calculation

Objective: ExternalSaleswillbeacalculatedAccount(ExternalSales=Sales

Units * Sales Price). Create the necessary account and logic calculation for

ExtSales.

Description: SalesUnitsandSalesPricewillvarybystore. StoreMangerswill

be responsible for inputting Sales Units.

ThislabisperformedusingyourassignedPETDEPOT_##applicationset.

System Data

System: CITRIXCommonTrainingenvironment

Client: Start/Programs/Accessories/RemoteDesktopConnection

User ID: CPM-##(with##=monitornumber)

Password: training

292

第 311 页 / 共 377 页

BPC320 Lesson: Labs

1. Adding the Sales Price Account

1. Launch BPC Administration.

2. FromtheActionPane,selectManageDimensions.

3. WhentheBPClogonscreenisdisplayed,selectOKtoaccesstheAdmin

Console.

Note: MakesuretologontoyourPETDEPOTapplicationset.

4. FromtheleftsideoftheAdminconsole,selectAccount.

5. FromtheActionPane,selectMaintaindimensionmembers.

6. In the Stats accounts section, insert a new row below the SalesUnits

account.

7. CopytheSalesUnitsaccounttothenewlycreatedrowandchangetheID

and EVDESCRIPTION to the following:

ID: SalesPrice

EVDESCRIPTION: SalesPrice

8. Leavetheremainingpropertieswiththedefaults.

9. ProcesstheAccountdimension.OK→OK

2. Creating the Calculation

1. FromtheleftsideoftheAdminConsole,expandApplications.

2. FromtheleftsideoftheAdminConsole,expandtheFinancefolder.

3. FromtheleftsideoftheAdminConsole,expandtheScriptLogicfolder.

4. FromtheleftsideoftheAdminConsole,selectDefault.LGF.

5. EdittheDefault.LGFlogicasshownbelow:

Figure 409: Default.LGF logic

293

第 312 页 / 共 377 页

Unit6: Labs BPC320

6. FromtheActionPane,selectValidateandsave.

7. Whenprompted,“App: Finance. Thelogicpassedthevalidationtest…”

click OK.

8. Exit the Admin Console and make the application set available, when

prompted.

Lab 35 – Verifying the External Sales Calculation

Objective: Create the necessary schedules to input sales units and sales price

budgetdata, andverifytheexternalsalescalculation.

Description: SalesUnitsandSalesPricewillvarybystore. StoreMangerswill

beresponsibleforinputtingSalesUnitsandSalesPrice.

ThislabisperformedusingyourassignedPETDEPOT_##applicationset.

System Data

System: CITRIXCommonTrainingenvironment

Client: Start/Programs/Accessories/RemoteDesktopConnection

User ID: CPM-##(with##=monitornumber)

Password: training

1. Creating the Sales Units Input Schedule

1. LaunchBPCforExcelandlogontoyourPETDEPOTapplicationsetfor

the FINANCE application.

Note: Thesystemwillperformarefreshsinceanewaccountwasadded

in the previous lab.

2. Usingthereportingskillsyougainedinpreviouslabs,andthehintsbelow,

createthefollowingEVDREinputschedule.

294

第 313 页 / 共 377 页

BPC320 Lesson: Labs

Figure 410: Schedule 1

Hint:

• EnsureyourPageKeyselectionsmatchthescreenshot.

• In the columns, show base level members from January through

December 2009, as well as 2009.Total.

• Intherows,showbaselevelmembersbelowCONREGION.

• In Workbook Options, set the Type to Input Schedule with the

Refreshaftersendoptionselected,andthenExpand.

• Formatyourinputscheduleasshowninthescreenshot.

3. SavetheinputscheduleasLab35–SalesUnitsInputScheduleinthe

eExcel→InputSchedules→Managerfolderontheserver.

2. Inputting and Sending Sales Units Data

1. Enter100fortheStore1SalesUnitsforallthe2009months.

2. Enter120fortheStore2SalesUnitsforallthe2009months.

3. Sendthedataandverifythatyourschedulelookssimilartothefollowing:

295

第 314 页 / 共 377 页

Unit6: Labs BPC320

Figure 411: Schedule 2

4. Closetheworkbook. Donotsaveadditionalchanges.

3. Creating the Sales Price Input Schedule

1. Usingthereportingskillsyougainedinpreviouslabs,andthehintsbelow,

createthefollowingEVDREinputschedule.

Figure 412: Schedule 3

Hint:

• EnsureyourPageKeyselectionsmatchthescreenshot.

• In the columns, show base level members from January through

December 2009, as well as 2009.Total.

• Intherows,showtheSalesUnitsandSalesPriceAccounts.

• In Workbook Options, set the Type to Input Schedule with the

Refreshaftersendoptionselected,andthenExpand.

• Formatyourinputscheduleasshowninthescreenshot.

296

第 315 页 / 共 377 页

BPC320 Lesson: Labs

2. SavetheinputscheduleasLab35–SalesPriceInputScheduleinthe

eExcel→InputSchedules→Managerfolderontheserver.

4. Inputting and Sending Sales Price Data

1. Enter49.95intoSalesPricefor2009.JANthrough2009.JUN.

2. Enter59.95intoSalesPricefor2009.JULthrough2009.DEC.

3. Sendthedataandverifythatyourschedulelookssimilartothefollowing:

Figure 413: Schedule 4

5. Verifying the Calculation

1. Intherowsofyourinputschedule,addtheExtSalesAccount,andverify

thatyourschedulelookssimilartothefollowing:

Figure 414: Schedule 5

2. SavetheinputscheduleasLab35–ExtSalesVerificationintheeExcel

→IInputSchedules→Managerfolderontheserver.

3. Close the input schedule.

297

第 316 页 / 共 377 页

Unit6: Labs BPC320

Lab 36 – Creating Additional Budgeting Input

Schedules

Objective: CreateinputschedulesforCostofGoodsSold,OperatingExpenses,

and Departmental Expenses.

Description: ThePetDepotAccountingDepartmentisresponsibleforbudgeting

all COGS accounts for all stores. They will do this after the Sales Units and

ExternalSalesamountshavebeenbudgetedforbystore. Itisveryimportantthat

theAccountingDepartmentbeabletoseeSalesUnitsandExternalSalesinorder

tocalculatetheCOGSaccounts. Theyprefertodothisbudgetingonastoreby

storebasis. TheOperatingExpensesinputschedulewillbeusedbythePetDepot

Finance Department. The Departmental Expenses input schedule will be used

by the Pet Depot Finance Department.

ThislabisperformedusingyourassignedPETDEPOT_##applicationset.

System Data

System: CITRIXCommonTrainingenvironment

Client: Start/Programs/Accessories/RemoteDesktopConnection

User ID: CPM-##(with##=monitornumber)

Password: training

1. CreatingtheCostofGoodsSoldInputSchedule

1. Usingthereportingskillsyougainedinpreviouslabs,andthehintsbelow,

createthefollowingEVDREinputschedule.

Figure 415: Schedule 1

Hint:

• EnsureyourPageKeyselectionsmatchthescreenshot.

298

第 317 页 / 共 377 页

BPC320 Lesson: Labs

• In the columns, show base level members from January through

December 2009, as well as 2009.Total.

• In the rows, show the SalesUnits and ExtSales, as well as the

dependants of CostOfGoods and CostOfGoods, spaced as shown

in the screen shot above.

• In Workbook Options, set the Type to Input Schedule with the

Refreshaftersendoptionselected,andthenExpand.

• Manuallyformatyourinputscheduleasshowninthescreenshot.

2. SavetheinputscheduleasLab36–COGSInputScheduleintheeExcel

→InputSchedules→Managerfolderontheserver.

3. Close the input schedule.

2. CreatingtheOperatingExpensesInputSchedule

1. Usingthereportingskillsyougainedinpreviouslabs,andthehintsbelow,

createthefollowingEVDREinputschedule.

Figure 416: Schedule 2

Hint:

• EnsureyourPageKeyselectionsmatchthescreenshot.

• In the columns, show base level members from January through

December 2009, as well as 2009.Total.

• In the rows, show all members below TotOpExp, as well as

TotOpExp.

299

第 318 页 / 共 377 页

Unit6: Labs BPC320

• In Workbook Options, set the Type to Input Schedule with the

Refreshaftersendoptionselected,andthenExpand.

• UseaFormattingtabletoformatyourinputscheduleasshownin

the screen shot.

2. SavetheinputscheduleasLab36–OperatingExpensesInputSchedule

intheeExcel→InputSchedules→Managerfolderontheserver.

3. Close the input schedule.

3. CreatingtheDepartmentalExpensesInputSchedule

1. Usingthereportingskillsyougainedinpreviouslabs,andthehintsbelow,

createthefollowingEVDREinputschedule.

Figure 417: Schedule 3

Hint:

• EnsureyourPageKeyselectionsmatchthescreenshot.

• In the columns, show base level members from January through

December 2009, as well as 2009.Total.

• In the rows, show all members below TotalDeptExp, as well as

TotalDeptExp.

• In Workbook Options, set the Type to Input Schedule with the

Refreshaftersendoptionselected,andthenExpand.

• UseaFormattingtabletoformatyourinputscheduleasshownin

the screen shot.

300

第 319 页 / 共 377 页

BPC320 Lesson: Labs

2. Save the input schedule as Lab 36 – Departmental Expenses Input

Schedule in the eExcel → Input Schedules → Manager folder on the

server.

3. Close the input schedule.

Lab 37 – Creating a Budget Template with Viewable

Areas

Objective: Createaninputschedulewithviewableareas.

Description: CreateabudgetinputtemplatethatdisplaysactualdataforQ12008

forviewingreferencewhenbudgetingforQ12009.

ThislabisperformedusingyourassignedPETDEPOT_##applicationset.

System Data

System: CITRIXCommonTrainingenvironment

Client: Start/Programs/Accessories/RemoteDesktopConnection

User ID: CPM-##(with##=monitornumber)

Password: training

1. CreatingtheBudgetwithActualsInputSchedule

1. Usingthereportingskillsyougainedinpreviouslabs,andthehintsbelow,

createthefollowingEVDREinputschedule.

301

第 320 页 / 共 377 页

Unit6: Labs BPC320

Figure 418: Schedule

Hint:

• IntheEVDREBuilder,choosetheTimeandCategorydimensions

for the columns.

• EnsureyourPageKeyselectionsmatchthescreenshot.

• Intherows,showbaselevelmembersbelowTotalDeptExp,aswell

as TotalDeptExp.

IncellA1,deletetheExpandRangefromtheEVDREformula.

• TypetheappropriatememberIDsintheColKeyRangeandRefresh

your report to update the data.

• Manuallyformatyourreportasshowninthescreenshot.

2. SavetheinputscheduleasLab37–BudgetwithActualsInputSchedule

intheeExcel→InputSchedules→Managerfolderontheserver.

3. Close the input schedule.

4. Exit BPC for Excel.

Lab 38 – Creating a Budgeting Business Process Flow

Objective: CreateabudgetingbusinessprocessflowinBPCAdministrationand

test the BPF in BPC for Excel.

Description: The budgeting business process flow that will be used to access

the previously created input schedules.

ThislabisperformedusingyourassignedPETDEPOT_##applicationset.

System Data

System: CITRIXCommonTrainingenvironment

Client: Start/Programs/Accessories/RemoteDesktopConnection

User ID: CPM-##(with##=monitornumber)

Password: training

1. Creating the BPF

1. Launch BPC Administration.

2. FromtheActionPane,selectManageBusinessProcessFlows.

302

第 321 页 / 共 377 页

BPC320 Lesson: Labs

3. LogontoyourPETDEPOTapplicationset.

4. CreateanewbusinessprocessflownamedPetDepotBudgeting.

5. Define Step A as shown below:

Figure 419: Setup BPF 1

6. Define Step B as shown below:

Figure 420: Setup BPF 2

7. InStepCleaveallparameterssettothedefaultandclickContinueto

Setup Step D.

8. InStepD,givetheAdminTeamaccesstotheBPF.

9. Define the following BFP steps:

303

第 322 页 / 共 377 页

Unit6: Labs BPC320

Figure 421: Define Steps

10. Definetheactionsbasedonthefollowinginformation:

Note: EachstepneedstoinheritfromthedataregionofCategory,Entity

and Time for the Current View.

Information to define the actions

Step Interface Task Parameter Value

Step1 BPCforExcel Schedule Lab 35 - Sales Units Input

Library Schedule

Step2 BPCforExcel Schedule Lab 35 - Sales Price Input

Library Schedule

Step3 BPCforExcel Schedule Lab36-COGSInputSchedule

Library

Step4 BPCforExcel Schedule Lab 37 - Operating Expenses

Library Input Schedule

Step5 BPCforExcel Schedule Lab38-DepartmentalExpenses

Library Input Schedule

11. MakesuretoEnabletheBPFforUsersandSavetheBPF.

12. Exit the Admin Console.

2. Testing the BPF

1. Launch BPC for Excel.

2. LogontoyourPETDEPOTapplicationsetfortheFINANCEapplication.

3. FromtheActionPane,selectOpenabusinessprocessflow.

304

Step	Interface	Task	Parameter Value
Step1	BPCforExcel	Schedule Library	Lab 35 - Sales Units Input Schedule
Step2	BPCforExcel	Schedule Library	Lab 35 - Sales Price Input Schedule
Step3	BPCforExcel	Schedule Library	Lab36-COGSInputSchedule
Step4	BPCforExcel	Schedule Library	Lab 37 - Operating Expenses Input Schedule
Step5	BPCforExcel	Schedule Library	Lab38-DepartmentalExpenses Input Schedule

第 323 页 / 共 377 页

BPC320 Lesson: Labs

4. SelectthenewlycreatedbusinessprocessflowPetDepotBudgeting.

5. Select the following data region:

Category: BUDGET

Entity: STORE1

Time: 2009.TOTAL

6. Checkeachsteptoensurethatthecorrectinputscheduleisdisplayed.

7. After each step, click on Back to BPF from the Action Pane, click on

the NotepadicontotheleftofthestepandthenselectThisstepis

completed from the Action Pane.

8. Aftertestingallsteps, verifythatyourBFPToDoListlookssimilarto

the following:

Figure 422: BFP To Do List

9. Close your browser.

10. Exit BPC for Excel.

Lab 39 – Top Down Modeling and Distribution

Objective: Youhaveahierarchicaldatastructureandyouwanttoplanabudget

onthenodedimensionmemberanddistributeitmanuallytothebasemembers.

Youalsowanttoseethebudgetremainderifoneexists.

Description: BudgetingandDistributionisdonefortheEntitydimension. Asa

firststep,thefollowinghierarchicalstructurewillneedtobecreated:

Figure 423: Hierarchical Structure

305

第 324 页 / 共 377 页

Unit6: Labs BPC320

ThislabisperformedusingyourassignedPETDEPOT_##applicationset.

System Data

System: CITRIXCommonTrainingenvironment

Client: Start/Programs/Accessories/RemoteDesktopConnection

User ID: CPM-##(with##=monitornumber)

Password: training

1. Creation of Master Data

1. Launch BPC Administration.

2. FromtheActionPane,selectManageDimensions.

3. LogontoyourPETDEPOTapplicationset.

4. FromtheleftsideoftheAdminConsole,selecttheEntitydimension.

5. FromtheActionPane,selectMaintaindimensionmembers.

6. Selectrow35andcopyitscontentstorows36–39.

7. Editthenecessarycellsinrows36–39,asshownbelow:

Figure 424: Example

Note: Leavethefollowingpropertyvaluesblankforthenewmembersin

rows36-39: NewID,ParentH2,DrillKey,Elim,andIntCo..

8. FromtheActionPane,selectProcessdimension.

9. Exit the Admin Console and make the application set available, when

prompted.

2. Creating the Input Schedule

1. Launch BPC for Excel.

2. LogontoyourPETDEPOTapplicationsetfortheFINANCEapplication.

3. ChangethecurrentviewTIMEperiodto2008.JAN.

4. Changeyourcurrentviewsettingstomatchthefollowing:

306

第 325 页 / 共 377 页

BPC320 Lesson: Labs

Figure 425: Current View Settings

5. Usingthereportingskillsyougainedinpreviouslabs,andthehintsbelow,

createthefollowingEVDREinputschedule.

Figure 426: Schedule 1

Hint:

• IntheEVDREBuilder,choosetheTimeforthecolumnsandEntity

for the rows.

• EnsureyourPageKeyselectionsmatchthescreenshot.

• Intherows,showPlan_Entity_Nodeanditsdependants.

• In the columns, show base level members from January through

December 2009.

• Manuallyformatyourreportasshowninthescreenshot.

• In Workbook Options, set the Type to Input Schedule with the

Refreshaftersendoptionselected,andthenExpand.

• InC16, settheMemberSettoNoExpand.

6. SavetheinputscheduleasLab39–ManualBudgetDistributioninthe

eExcel→InputSchedules→Managerfolderontheserver.

3. ModelingofBudgetingandTop–DownDistribution

1. Select cell E18 and type Excel formula.

2. SelectcellF18andtypeBudgettobeallocated.

307

第 326 页 / 共 377 页

Unit6: Labs BPC320

3. FormatcellsE18:R18withaFillofGray–25%.

4. Enter the number 0 in cells G15:R17.

5. Verifythatyourscreenlookssimilartothefollowing:

Figure 427: Schedule 2

6. Select cell G18 and enter a budget of 100.

7. CopythevalueincellG18acrossthroughR18.

8. Select cell G15 and enter 10.

9. Select cell G16 and enter 20.

10. CopythevaluesincellsG15:G16acrossthroughR15:R16.

11. SelectcellG17andenter=G18–G15–G16

Note: ThisExcelformularepresentsthedifferencebetweentheBudgetto

beallocatedandthemanualdistributionvalues.

12. CopytheformulainG17acrossthroughR17.

13. Verifythatyourscreenlookssimilartothefollowing:

Figure 428: Schedule 3

308

第 327 页 / 共 377 页

BPC320 Lesson: Labs

14. SavetheinputscheduleasLab39–ManualBudgetDistributioninthe

eExcel→InputSchedules→Managerfolderontheserver.

15. Whenprompted,“Lab39–ManualBudgetDistribution.xltalreadyexists.

Doyouwanttoreplacetheexistingfile?”clickYes.

4. TestingBudgetingandmanualTop–DownDistribution

1. Select cell G18 and enter a budget of 200.

2. Select cell G15 and enter 100.

3. Select cell G16 and enter 50.

Note: Theremainderof50isautomaticallycalculatedincellG17.

4. From the Action Pane, click Send Data.

5. FromtheActionPane,clickSendDatafromactiveworksheet.

6. Whenprompted,“36datarecordswillbesent. Doyouwanttocontinue?””

click Yes.

7. Verifythatyourscreenlookssimilartothefollowing:

Figure 429: Schedule 4

8. Close the input schedule.

9. Exit BPC for Excel.

Lab 40 – Foreign Currency Translation

Objective: UsetheAdminConsoletoviewtheforeigncurrencytranslationset-up

andthenrunacurrencyconversionfromBPCforExcelusingDataManager.

Description: SAP Business Planning and Consolidation comes configured to

perform currency translations. By using the Admin Console you will see the

currency translation setup and then run a currency conversion using the FX

Restatement Data Manager package in BPC for Excel. Verify your results in

a report.

309

第 328 页 / 共 377 页

Unit6: Labs BPC320

ThislabisperformedusingyourassignedPETDEPOT_##applicationset.

System Data

System: CITRIXCommonTrainingenvironment

Client: Start/Programs/Accessories/RemoteDesktopConnection

User ID: CPM-##(with##=monitornumber)

Password: training

Note: Labs40–43correspondtoTrainingIISession5.

1. ReviewingForeignCurrencyTranslationSetupinBPCAdministration

1. Launch BPC Administration.

2. FromtheActionPane,selectManageApplications.

3. LogontoyourPETDEPOTapplicationset.

4. FromtheleftsideoftheAdminConsole,expandtheFinancefolder.

5. Expand the Dimensions folder to view the dimensions in the Finance

application.

6. FromtheleftsideoftheAdminConsole,expandtheDimensionLibrary

and then click on the Account dimension.

7. FromtheActionPane,selectMaintaindimensionproperty.

8. ReviewthepropertiesoftheAccountdimension.

9. FromtheleftsideoftheAdminConsole,selecttheEntitydimension.

10. FromtheActionPane,selectMaintaindimensionproperty.

11. ReviewthepropertiesoftheEntitydimension.

12. Openandreviewthefollowingdimensionmembersheetsbyselectingthe

dimension from the left side of the Admin Console and then selecting

MaintaindimensionmembersfromtheActionPane:

RATE

ACCOUNT

INPUTCURRENCY

ENTITY

RPTCURRENCY

RATESRC

13. Exit the Admin Console.

2. VerifyingForeignCurrencyExchangeRatesinBPCforExcel

1. Launch BPC for Excel.

2. LogontoyourPETDEPOTapplicationsetfortheRATEapplication.

310

第 329 页 / 共 377 页

BPC320 Lesson: Labs

3. ChangethecurrentviewTIMEperiodto2008.JAN.

4. EnsurethecurrentviewRATESRCdimensionissettoRateInput.

5. Usingthereportingskillsyougainedinpreviouslabs,andthehintsbelow,

create the following EVDRE report.

Figure 430: EVDRE Report 1

Note: TheseexchangerateswereloadedintotheRateapplicationusing

Data Manager.

Hint:

• Intherows,showallmembersoftheRATEdimension.

• In the columns, show all members of the INPUTCURRENCY

dimension.

• Formatthedatacellsto4decimalplaces.

6. ChangethecurrentviewRATESRCdimensiontoRateCalc.

7. Refreshthedataandverifythatyourscreenlookssimilartothefollowing:

Figure 431: EVDRE Report 2

Note: TheseexchangeratesarecalculatedbyBPCandareusedtoconvert

local currency values into reporting currency values in the Finance

application.

311

第 330 页 / 共 377 页

Unit6: Labs BPC320

8. Closethereportanddonotsaveanychanges.

9. FromthecurrentviewbarintheActionPane,changetheactiveapplication

back to the FINANCE application.

3. ExecutingForeignCurrencyTranslationviatheDataManager

1. Select eData → Run Package.

2. FromtheFinancialProcessesfolder,selecttheFXRestatementpackage.

3. Click the Run button.

4. SelecttheoptionNo,donotcheckworkstatussettings.

5. Click the Next button.

6. Selecttherestatementrangeasshownbelow:

Figure 432: Restatement Range

7. ClicktheNextbuttonandthentheFinishbutton.

8. Whenprompted,“Therequesttorunthepackage…”clickOK.

9. FromtheDataManagerdialogbox,clicktheViewstatusbutton.

10. SelecttheRefreshStatuseverycheckbox. Thiswillrefreshthedisplay

every 5 seconds, by default.

11. Oncethepackageiscomplete,selectClosetoclosethestatuswindow.

12. SelectCanceltoclosetheDataManagerdialogbox.

Note: The foreign currency translation can also be performed when

running the Default Script Formulas, because the following line is

includedinDefault.lgf: *INCLUDEFXTrans.

4. VerifyingForeignCurrencyTranslationinBPCforExcel

1. Changeyourcurrentviewsettingstomatchthefollowing:

Figure 433: Current View Settings

312

第 331 页 / 共 377 页

BPC320 Lesson: Labs

2. Usingthereportingskillsyougainedinpreviouslabs,andthehintsbelow,

create the following EVDRE report.

Figure 434: EVDRE Report 3

Note: All data was initially loaded into the LC member of the

RptCurrencydimension. Theforeigncurrencytranslationthencalculated

thevaluesforbothUSDollarsandEURObyusingthecalculatedratesin

the RATE application.

Hint:

• Intherows,utilizetheLDEP(2)keywordintheMemberSet.

3. ExitBPCforExcelanddonotsaveanychanges.

Lab 41 – Inter-company Eliminations

Objective: UsetheAdminConsoletoviewinter-companyeliminationset-up.

Thenenterinter–companytransactions,runinter-companyeliminationsusinga

DataManagerpackageandverifyyourresultsinareport.

Description: SAP Business Planning and Consolidation comes with built-in

formulas to perform inter-company eliminations. Inter-company eliminations

letyoueliminatetransactionsbetweenbusinessunitswithacommonparentso

the data at the parent level is accurate.

ThislabisperformedusingyourassignedPETDEPOT_##applicationset.

313

第 332 页 / 共 377 页

Unit6: Labs BPC320

System Data

System: CITRIX Common Training

environment

Client: Start/Programs/Accessories/Remote

Desktop Connection

User ID: CPM-##(with##=monitornumber)

Password: training

1.ReviewingInter-companyEliminationSetupinBPCAdministration

1. Launch BPC Administration.

2. FromtheActionPane,selectManageDimensions.

3. LogontoyourPETDEPOTapplicationset.

4. FromtheleftsideoftheAdminConsole,selecttheEntitydimension.

5. ReviewtheeliminationmembersandELIMpropertycolumn.

6. FromtheActionPane,selectMaintaindimensionmembers.

7. FromtheleftsideoftheAdminConsole,selecttheIntCodimension.

8. FromtheActionPane,selectMaintaindimensionmembers.

9. Review the IntCo members.

10. FromtheleftsideoftheAdminConsole,expandtheApplicationfolder.

11. Expand the Finance folder.

12. Expand the Script Logic folder.

13. From the left side of the Admin Console, select the Script Logic file

ICElim.LGF.

14. FromtheActionPane, selectValidateandSave.

15. When prompted “App:Finance The logic passed the validation test and

was saved successfully”, select OK.

16. Exit the Admin Console.

2.InputtingInter–companyDatainBPCforExcel

1. Launch BPC for Excel.

2. LogontoyourPETDEPOTapplicationsetfortheFINANCEapplication.

3. Changeyourcurrentviewsettingstomatchthefollowing:

314

第 333 页 / 共 377 页

BPC320 Lesson: Labs

Figure 435: Current View Settings 1

4. SelecteTools→OpenDynamicTemplates.

5. OpentheM02ICSchedule.xltfromtheeEXCEL→InputSchedules→

Manager folder.

6. Select eTools → Expand all.

7. Move to cell P47 and enter 10,000 for the Intercompany Accounts

Receivable amount.

8. Click on the Send Data button.

9. SelectActiveworksheetandthenselectRefresh.

10. Whenprompted“1datarecord(s)willbesent. Doyouwanttocontinue?”

select Yes.

11. Verify that one record was submitted successfully and then Close the

Refresh Schedule results dialog box.

12. ChangethecurrentviewentitytoSTORE2.

13. Select eTools → Expand all.

14. MovetocellQ46andenter9,700fortheIntercompanyAccountPayable

amount.

15. Click on the Send Data button.

16. SelectActiveworksheetthenselectRefresh.

17. Whenprompted“1datarecord(s)willbesent. Doyouwanttocontinue?”

select Yes.

18. Verify that one record was submitted successfully and then Close the

Refresh Schedule results dialog box.

19. SelectFile→Closetoclosetheschedule. Donotsaveanychanges.

3.ExecutingInter–companyEliminationsviatheDataManager

1. Select eData → Run Package.

2. FromtheFinancialProcessesfolder,selecttheICEliminationspackage.

3. Click the Run button.

4. SelecttheoptionNo,donotcheckworkstatussettings.

5. Click Next to continue.

6. Select the data range as shown below:

315

第 334 页 / 共 377 页

Unit6: Labs BPC320

Figure 436: Data Range

7. ClicktheNextbuttonandthentheFinishbutton.

8. Whenprompted,“Therequesttorunthepackage…”clickOK.

9. FromtheDataManagerdialogbox,clicktheViewstatusbutton.

10. SelecttheRefreshStatuseverycheckbox. Thiswillrefreshthedisplay

every 5 seconds, by default.

11. Oncethepackageiscomplete,selectClosetoclosethestatuswindow.

12. SelectCanceltoclosetheDataManagerdialogbox.

4.

VerifyingInter–companyEliminationsinBPCforExcel

1. Changeyourcurrentviewsettingstomatchthefollowing:

Figure 437: Current View Settings 2

2. Select eAnalyze → Open Report Library.

3. Open the H01 Intercompany Verification.xlt from the eEXCEL →

Reports → HQ folder.

4. Verifythatyourscreenlookssimilartothefollowing:

Figure 438: Example 1

Note: RunningtheICEliminationspackageinthepreviousstepscreated

thedatavaluesinUSConsolidationElimination.

5. ChangethecurrentviewentitytoCONREGION.

6. Verifythatyourscreenlookssimilartothefollowing:

316

第 335 页 / 共 377 页

BPC320 Lesson: Labs

Figure 439: Example 2

7. ExitBPCforExcelanddonotsaveanychanges.

Lab 42 – Journals

Objective: UsetheAdminConsoletocreateanewJournalTemplateandsetup

JournalSecurity. CreatejournalentriesandrunjournalreportsinBPCforExcel.

Description: Journalsallowyoutocarefullytrackchangestothedatabase. To

usethejournalsfeature,theApplicationadministratorfirstsetsupaJournalEntry

Template for each application.

ThislabisperformedusingyourassignedPETDEPOT_##applicationset.

System Data

System: CITRIXCommonTrainingenvironment

Client: Start/Programs/Accessories/RemoteDesktopConnection

User ID: CPM-##(with##=monitornumber)

Password: training

1.CreatingtheJournalTemplateinBPCAdministration

1. Launch BPC Administration.

2. FromtheActionPane,selectManageApplications.

3. LogontoyourPETDEPOTapplicationset.

4. FromtheleftsideoftheAdminConsole,expandtheFinancefolder.

5. FromtheleftsideoftheAdminConsole,selectJournals.

6. FromtheActionPane, clickJournalWizard.

TheSAPJournalCreatedialogboxisdisplayed.

7. CompletetheSelectHeaderdimensionstabasshownbelow:

317

第 336 页 / 共 377 页

Unit6: Labs BPC320

Figure 440: Header Dimensions 1

8. Click the Next button.

9. Usingtheupanddownbuttons,completetheSetHeaderdimensionorder

tab as shown below:

Figure 441: Header Dimensions 2

10. Click the Next button.

11. OntheSetDetaildimensionsscreen,selecttheEntitydimensionandthen

click the To left button to move the Entity dimension to the left of the

Account dimension.

12. Click the Next button.

13. IntheAddeditemssectionontheleft,clicktheAddbutton.

14. EnterAdjustment_CodeandclicktheAddbutton.

15. ClickOKtoclosetheEnteradditionalitemsdialogbox.

16. IntheSub–itemssectionontheright,clicktheAddbutton.

17. EnterADJ_CODE_001andclicktheAddbutton.

18. EnterADJ_CODE_002andclicktheAddbutton.

19. EnterADJ_CODE_003andclicktheAddbutton.

20. ClickOKtoclosetheEntersubitemsdialogbox.

21. Verifythatyourscreenlookssimilartothefollowing:

318

第 337 页 / 共 377 页

BPC320 Lesson: Labs

Figure 442: Header Items

22. Click the Next button.

23. Click the Finish button.

Note: Thecreationprocesscantakeuptoafewminutes.

24. Whenprompted“Successfullyfinished”,selectOK.

25. Verifythatyourscreenlookssimilartothefollowing:

Figure 443: Example 1

2.SettingupJournalSecurityinBPCAdministration

1. FromtheleftsideoftheAdminConsole,expandtheSecurityfolder.

2. FromtheleftsideoftheAdminConsole,selectTaskProfiles.

3. FromtheActionPane,selectAddanewtaskprofile.

4. CompletetheNametheprofiletabasshownbelow:

319

第 338 页 / 共 377 页

Unit6: Labs BPC320

Figure 444: Name the Profile

5. Click the Next button.

6. CompletetheEnabletaskstabasshownbelow:

Figure 445: Enable Tasks

7. Click the Next button.

8. AssigntheAdminTeamtothetaskprofileasshownbelow:

Figure 446: Assign Users

9. Click the Next button.

10. Click the Apply button.

11. Whenprompted“Thistaskhassuccessfullycompleted”selectOK.

12. Exit the Admin Console.

320

第 339 页 / 共 377 页

BPC320 Lesson: Labs

3.CreatingandPostingMulti–HeaderJournalEntries

1. Launch BPC for Excel.

2. LogontoyourPETDEPOTapplicationsetfortheFINANCEapplication.

3. Select eTools → Journal.

4. Select eJournal → New.

5. Whenprompted,“Doyouwanttocreatemultiplejournalentriesbasedona

single header?” select Yes.

6. DefinetheMultipleJournalasshownbelow:

Figure 447: Multiple Journal

7. Click the OK button.

8. Double-clickintheDataSrcfieldandselectAdjustment.

9. Double-clickintheIntCofieldandselectNon_InterCo.

Note: YouwillneedtoscrolldowntheDataSrcdimensionmemberdialog

box to find the Adjustment member.

10. FromtheAdjustment_Codedrop-downlistbox,selectADJ_CODE_001.

11. IntheDescriptionfield,typeExternalSalesAdjustment.

12. Onthefirstrowofthedetailarea,double-clickintheEntityfieldandselect

STORE10.

13. Onthefirstrowofthedetailarea, double-clickintheAccountfieldand

select ExtSales.

14. Onthefirstrowofthedetailarea,clickintheDebitfieldfortheACTUAL

category section and enter 200.

15. Onthefirstrowofthedetailarea,clickintheDebitfieldfortheBUDGET

category section and enter 225.

321

第 340 页 / 共 377 页

Unit6: Labs BPC320

16. Onthesecondrowofthedetailarea,double-clickintheEntityfieldand

select STORE11.

17. On the second row of the detail area, double-click in the Account field

and select ExtSales.

18. On the second row of the detail area, click in the Credit field for the

ACTUAL category section and enter 200.

19. On the second row of the detail area, click in the Credit field for the

BUDGET category section and enter 225.

20. Verifythatyourscreenlookssimilartothefollowing:

Figure 448: Example 2

1. Select eJournal → Save.

Note: ThesystemautomaticallycreatessixJournalIDs.

2. Whenprompted,“Journalsuccessfullysaved”. selectOK.

3. Select eJournal → Manager.

4. Click the Execute Query button.

5. Whenprompted,“Itmaytakeafewmomentstoprocessthisquery. Doyou

want to continue?” select Yes.

6. SelectthefirstcheckboxtotheleftofJournalID1.

Note: AlltheJournalIDsinthegroupwillbeautomaticallyselected.

7. Click the Post button.

8. Whenprompted,“Doyouwanttovalidatethejournalentriesbeforeposting?”

select Yes.

9. Whenprompted,“Validationsuccessful. Posttheseentries?”selectYes.

Note: Thepostingcantakeuptoafewminutes.

322

第 341 页 / 共 377 页

BPC320 Lesson: Labs

10.Oncecomplete,verifythatyourscreenlooksimilartothefollowing:

Figure 449: Journal Post Results 1

11.Click the Close button.

12.Verifythatyourscreenlookssimilartothefollowing:

Figure 450: Example 3

4.CreatinganAuto–ReversingJournalEntry

1. Select eJournal → New.

2. Whenprompted,“Doyouwanttocreatemultiplejournalentriesbasedona

single header?” select No.

323

第 342 页 / 共 377 页

Unit6: Labs BPC320

Figure 451: Journal Entry 1

3. CompleteyourJournalEntryasshownbelow:

4. Select eJournal → Save.

Note: ThesystemautomaticallycreatestwoJournalIDs.

5. Whenprompted,“Journalsuccessfullysaved”,selectOK.

6. Select eJournal → Manager.

7. Click the Execute Query button.

8. Whenprompted, “Itmaytakeafewmomentstoprocessthisquery. Do

you want to continue?” select Yes.

9. SelectthecheckboxestotheleftofJournalID7andJournalID8.

10. ClickonJournalID7tohighlighttherow.

11. Click the Post button.

12. When prompted, “Do you want to validate the journal entries before

posting?” select Yes.

13. Whenprompted,“Validationsuccessful. Posttheseentries?”selectYes.

Note: Thepostingcantakeuptoafewminutes.

14. Oncecomplete,verifythatyourscreenlooksimilartothefollowing:

324

第 343 页 / 共 377 页

BPC320 Lesson: Labs

Figure 452: Journal Post Results 2

15. Click the Close button.

16. Verifythatyourscreenlookssimilartothefollowing:

Figure 453: Journal Entry 2

5.Opening Journal Entries

1. Select eJournal → Manager.

2. Click the Execute Query button.

3. Whenprompted, “Itmaytakeafewmomentstoprocessthisquery. Do

you want to continue?” select Yes.

4. SelecttheSelectAllcheckboxtoselectallJournalIDs.

325

第 344 页 / 共 377 页

Unit6: Labs BPC320

5. Click the Open button.

6.

Use the icon on the Journal toolbar to move forward through the

Journal Entries.

7.

Use the icon on the Journal toolbar to move backward through the

Journal Entries.

6.Running a Journal Report

1. Select eJournal → Manager.

2. Click the Execute Query button.

3. Whenprompted, “Itmaytakeafewmomentstoprocessthisquery. Do

you want to continue?” select Yes.

4. SelecttheSelectAllcheckboxtoselectallJournalIDs.

5. Click the Report button.

6. WhentheJournalReportWizardisdisplayed,leavethedefaultsasisand

click the Finish button.

The browser is launched.

7. Ifnecessary,press[Alt]+[Tab]toswitchovertotheJournalreportinyour

browser.

8. Verifythatyourscreenlookssimilartothefollowing:

Figure 454: Example 4

326

第 345 页 / 共 377 页

BPC320 Lesson: Labs

9.

Use the navigation buttons to scroll through the

different reports.

10. SelectFile→ClosetoclosethebrowserandreturntoBPCforExcel.

11. ClicktheCancelbuttontoclosetheJournalManager.

12. SelectFile→ClosetoclosetheJournalentry.

13. Exit BPC for Excel.

Lab 43 – Insight

Objective: ImplementtheInsightfeatureforyourapplicationset,synchronizethe

applicationset,changetheInsightparameters,createKPIsanddefinethecurrent

time period and variance categories.

Description: Insight is a powerful feature that gives you a business process

monitorthattracksreal–timeeventsandpredictsfutureperformance. Itallows

youtodefinekeyperformanceindicators(KPIs)correspondingtoaccountsthat

individualuserswishtomonitor. ItalsodisplaystrendsinKPIvalues. Inorderto

takeadvantageofthefeaturesofInsight,theadministratormustenableInsight,

synchronize the database, and create KPIs.

ThislabisperformedusingyourassignedPETDEPOT_##applicationset.

System Data

System: CITRIXCommonTrainingenvironment

Client: Start/Programs/Accessories/RemoteDesktopConnection

User ID: CPM-##(with##=monitornumber)

Password: training

1.Enabling Insight

1. Launch BPC Administration.

2. FromtheActionPane,selectManageApplicationSets

3. Logon to the PETDEPOT application set.

4. FromtheleftsideoftheAdminConsole,selectInsight.

5. FromtheActionPane, selectEnableInsight.

6. Whenprompted“DoyouwanttoenableInsight?”selectYes.

7. Whenprompted“Thetaskhassuccessfullycompleted”selectOK.

8. SelectFile/ClosetoclosetheAdminConsole.

9. LeavetheBPCAdministrationWebpageopenforthenextsection.

327

第 346 页 / 共 377 页

Unit6: Labs BPC320

2.Synchronizing Insight

1. FromtheActionPane, selectManageInsight.

2. FromtheActionPane, selectConfigureSystem.

3. FromtheActionPane, selectSynchronize.

4. FromtheActionPane,clicktheSynchronizebutton.

5. From the upper left corner of your screen, where it reads Insight

Administration>>SystemConfiguration>>Synchronize,clicktheSystem

Configuration link.

3.Configuring Insight

1. FromtheActionPane,selectCurrentTimePeriod.

2. From the Default Time Period drop down list box for the FINANCE

application, select 2008.AUG.

3. Verifyyourscreenlookssimilartothefollowing:

Figure 455: Example 1

Note: Variances are calculated by taking the actual amounts and

comparingthemtothebudgetedamounts. Youcandefinetheactualand

budgetcategoriesyouwanttouseforthesecomparisons.

4.

FromtheActionPane,clickthegreencheck button.

5. FromtheActionPane,selectVarianceCategory.

6. FortheFINANCEapplication,changetheAlternatecategorytoACTUAL.

7. For the FINANCE application, verify your screen looks similar to the

following:

Figure 456: Example 2

328

第 347 页 / 共 377 页

BPC320 Lesson: Labs

8.

FromtheActionPane,clickthegreencheck button.

9. FromtheActionPane, selectMeasuresType.

Note: You can specify a default measures type and an aggregated

measurestypeforeachInsightapplication. Themeasurestypeisusedto

calculate the KPI variance.

10. For the FINANCE application, verify your screen looks similar to the

following:

Figure 457: Example 3

11.

FromtheActionPane,clickthegreencheck button.

12. FromtheActionPane,selectPredictorAlgorithm.

13. EnsuretheCalculationperiodsusedinpredictionsinthisapplicationset

field is set to 12.

14. For the FINANCE application, deselect all algorithms except

LINEARREGRESSION.

15. For the FINANCE application, verify your screen looks similar to the

following:

Figure 458: Example 4

16.

FromtheActionPane,clickthegreencheck button.

17. From the upper left corner of your screen, where it reads Insight

Administration>>SystemConfiguration,clicktheInsightAdministration

link.

329

第 348 页 / 共 377 页

Unit6: Labs BPC320

4.Adding KPIs

1. FromtheActionPane, selectManageUsers.

2. UnderUserName, selectyourassigneduser.

3. FromtheActionPane,selectAddanewuserKPI.

4. OntheStep1–DefineKPItab,defineaKPIasshownbelow:

Figure 459: Example 5

5. Click the Step 2 – Define Basis tab.

6. LeavethePerformanceBandssettothedefault.

7. Click the Step 3 – Select Options tab.

8. OntheStep3–SelectOptionstab,selectoptionsasshownbelow:

Figure 460: Example 6

9.

FromtheActionPane,clickthegreencheck button.

10. FromtheActionPane,selectAddanewuserKPI.

11. OntheStep1–DefineKPItab,defineaKPIasshownbelow:

330

第 349 页 / 共 377 页

BPC320 Lesson: Labs

Figure 461: Example 7

12. Click the Step 3 – Select Options tab.

Note: Wewillleavethebasisdefaultsasis,sothereisnoneedtoclick

on Step 2 – Define Basis.

13. OntheStep3–SelectOptionstab,selectoptionsasshownbelow:

Figure 462: Example 8

14.

FromtheActionPane,clickthegreencheck button.

15. FromtheActionPane,selectAddanewuserKPI.

16. OntheStep1–DefineKPItab,defineaKPIasshownbelow:

331

第 350 页 / 共 377 页

Unit6: Labs BPC320

Figure 463: Example 9

17. Click the Step 3 – Select Options tab.

Note: Wewillleavethebasisdefaultsasis,sothereisnoneedtoclick

on Step 2 – Define Basis.

18. OntheStep3–SelectOptionstab,selectoptionsasshownbelow:

Figure 464: Example 10

19.

FromtheActionPane,clickthegreencheck button.

20. UnderKPINotifications,selecttheEnableEmailNotificationscheckbox.

21. FromtheActionPane,selectUpdateAlertTypes.

22. Verifyyourscreenlookssimilartothefollowing:

332