第 1 页 / 共 377 页
BPC320
SAP Business Planning and
Consolidation
Date
Training Center
Instructors
Education Website
Participant Handbook
Course Version: 91
Course Duration: 5 Days
Material Number: 50093568
An SAP course - use it to learn, reference it for work
第 2 页 / 共 377 页
Copyright
Copyright©2009SAPAG.Allrightsreserved.
Nopartofthispublicationmaybereproducedortransmittedinanyformorforanypurpose
withouttheexpresspermissionofSAPAG.Theinformationcontainedhereinmaybechanged
withoutpriornotice.
SomesoftwareproductsmarketedbySAPAGanditsdistributorscontainproprietarysoftware
componentsofothersoftwarevendors.
Trademarks
• Microsoft®,WINDOWS®,NT®,EXCEL®,Word®,PowerPoint®andSQLServer®are
registeredtrademarksofMicrosoftCorporation.
• IBM®,DB2®,OS/2®,DB2/6000®,ParallelSysplex®,MVS/ESA®,RS/6000®,AIX®,
S/390®,AS/400®,OS/390®,andOS/400®areregisteredtrademarksofIBMCorporation.
• ORACLE®isaregisteredtrademarkofORACLECorporation.
• INFORMIX®-OnLineforSAPandINFORMIX®DynamicServerTMareregistered
trademarksofInformixSoftwareIncorporated.
• UNIX®,X/Open®,OSF/1®,andMotif®areregisteredtrademarksoftheOpenGroup.
• Citrix®,theCitrixlogo,ICA®,ProgramNeighborhood®,MetaFrame®,WinFrame®,
VideoFrame®,MultiWin®andotherCitrixproductnamesreferencedhereinaretrademarks
ofCitrixSystems,Inc.
• HTML,DHTML,XML,XHTMLaretrademarksorregisteredtrademarksofW3C®,World
WideWebConsortium,MassachusettsInstituteofTechnology.
• JAVA®isaregisteredtrademarkofSunMicrosystems,Inc.
• JAVASCRIPT®isaregisteredtrademarkofSunMicrosystems,Inc.,usedunderlicensefor
technologyinventedandimplementedbyNetscape.
• SAP,SAPLogo,R/2,RIVA,R/3,SAPArchiveLink,SAPBusinessWorkflow,WebFlow,SAP
EarlyWatch,BAPI,SAPPHIRE,ManagementCockpit,mySAP.comLogoandmySAP.com
aretrademarksorregisteredtrademarksofSAPAGinGermanyandinseveralothercountries
allovertheworld. Allotherproductsmentionedaretrademarksorregisteredtrademarksof
theirrespectivecompanies.
Disclaimer
THESEMATERIALSAREPROVIDEDBYSAPONAN"ASIS"BASIS,ANDSAPEXPRESSLY
DISCLAIMSANYANDALLWARRANTIES,EXPRESSORAPPLIED,INCLUDING
WITHOUTLIMITATIONWARRANTIESOFMERCHANTABILITYANDFITNESSFORA
PARTICULARPURPOSE,WITHRESPECTTOTHESEMATERIALSANDTHESERVICE,
INFORMATION,TEXT,GRAPHICS,LINKS,ORANYOTHERMATERIALSANDPRODUCTS
CONTAINEDHEREIN.INNOEVENTSHALLSAPBELIABLEFORANYDIRECT,
INDIRECT,SPECIAL,INCIDENTAL,CONSEQUENTIAL,ORPUNITIVEDAMAGESOFANY
KINDWHATSOEVER,INCLUDINGWITHOUTLIMITATIONLOSTREVENUESORLOST
PROFITS,WHICHMAYRESULTFROMTHEUSEOFTHESEMATERIALSORINCLUDED
SOFTWARECOMPONENTS.
g2009111884827
第 3 页 / 共 377 页
About This Handbook
Thishandbookisintendedtocomplementtheinstructor-ledpresentationofthis
course,andserveasasourceofreference. Itisnotsuitableforself-study.
Typographic Conventions
American English is the standard used in this handbook. The following
typographic conventions are also used.
Type Style Description
Example text Wordsorcharactersthatappearonthescreen. These
includefieldnames,screentitles,pushbuttonsaswell
asmenunames, paths, andoptions.
Alsousedforcross-referencestootherdocumentation
both internal and external.
Exampletext Emphasized words or phrases in body text, titles of
graphics, and tables
EXAMPLETEXT Names of elements in the system. These include
reportnames,programnames,transactioncodes,table
names, andindividualkeywordsofaprogramming
language,whensurroundedbybodytext,forexample
SELECT and INCLUDE.
Example text Screenoutput. Thisincludesfileanddirectorynames
and their paths, messages, names of variables and
parameters, and passages of the source text of a
program.
Example text Exactuserentry. Thesearewordsandcharactersthat
youenterinthesystemexactlyastheyappearinthe
documentation.
<Example text> Variableuserentry. Pointedbracketsindicatethatyou
replacethesewordsandcharacterswithappropriate
entries.
iii
2009 © 2009 SAP AG. All rights reserved.
| Type Style | Description |
|---|---|
| Example text | Wordsorcharactersthatappearonthescreen. These includefieldnames,screentitles,pushbuttonsaswell asmenunames, paths, andoptions. Alsousedforcross-referencestootherdocumentation both internal and external. |
| Exampletext | Emphasized words or phrases in body text, titles of graphics, and tables |
| EXAMPLETEXT | Names of elements in the system. These include reportnames,programnames,transactioncodes,table names, andindividualkeywordsofaprogramming language,whensurroundedbybodytext,forexample SELECT and INCLUDE. |
| Example text | Screenoutput. Thisincludesfileanddirectorynames and their paths, messages, names of variables and parameters, and passages of the source text of a program. |
| Example text | Exactuserentry. Thesearewordsandcharactersthat youenterinthesystemexactlyastheyappearinthe documentation. |
| <Example text> | Variableuserentry. Pointedbracketsindicatethatyou replacethesewordsandcharacterswithappropriate entries. |
第 4 页 / 共 377 页
AboutThisHandbook BPC320
Icons in Body Text
Thefollowingiconsareusedinthishandbook.
Icon Meaning
Formoreinformation,tips,orbackground
Noteorfurtherexplanationofpreviouspoint
Exception or caution
Procedures
Indicatesthattheitemisdisplayedintheinstructor's
presentation.
iv
© 2009 SAP AG. All rights reserved. 2009
| Icon | Meaning |
|---|---|
| Formoreinformation,tips,orbackground | |
| Noteorfurtherexplanationofpreviouspoint | |
| Exception or caution | |
| Procedures | |
| Indicatesthattheitemisdisplayedintheinstructor's presentation. |
第 5 页 / 共 377 页
Contents
Course Overview......................................................... vii
Course Goals...........................................................vii
Course Objectives .....................................................vii
Unit 1: Session 1...........................................................1
EVSND and Input Schedules..........................................2
EVGTS and Reports....................................................8
EVGTS Multiple Application Reports...............................12
EVGTS Formatting....................................................14
EVEXP and Expansions .............................................17
Control Panel..........................................................20
Filters...................................................................26
Unit 2: Session 2......................................................... 35
Workbook Options....................................................36
EVGTS/EVSND Suppression .......................................41
Indentation and Custom Buttons....................................46
Dynamic Wizard Templates..........................................50
Introduction to EVDRE...............................................56
EVDRE Formatting ...................................................70
Unit 3: Session 3......................................................... 79
Before and AfterRange Options.....................................81
EVDRE Suppression .................................................86
Multiple Key Ranges and EVDREs.................................90
3D Expansions........................................................94
EVDRE Sorting........................................................97
EVDRE Drill Down and PageKey Functionality..................100
EVDRE Indentation..................................................103
EVDRE Best Practices..............................................106
Unit 4: Session 4........................................................111
Budgeting Overview.................................................112
MDX Calculation.....................................................119
Budgeting Input Schedules.........................................123
Viewable Data........................................................125
Budgeting and BPFs.................................................128
Top Down Modeling..................................................136
v
2009 © 2009 SAP AG. All rights reserved.
第 6 页 / 共 377 页
Contents BPC320
Unit 5: Session 5........................................................141
Foreign Currency Translation ......................................142
Inter-company Eliminations.........................................151
Journals...............................................................157
Unit 6: Labs ..............................................................169
Labs....................................................................170
Appendix 1: Insight ..................................................343
vi
© 2009 SAP AG. All rights reserved. 2009
第 7 页 / 共 377 页
Course Overview
Target Audience
Thiscourseisintendedforthefollowingaudiences:
• Project Team
• Application Consultants
Course Prerequisites
Required Knowledge
• BPC310
Course Goals
This course will prepare you to:
•
Course Objectives
Aftercompletingthiscourse, youwillbeableto:
• –
vii
2009 © 2009 SAP AG. All rights reserved.
第 8 页 / 共 377 页
CourseOverview BPC320
viii
© 2009 SAP AG. All rights reserved. 2009
第 9 页 / 共 377 页
Unit 1
Session 1
Unit Overview
Aftercompletingthisunityouwillunderstandhowtocreateinputschedulesand
reportsbyutilizingBPCfunctions,howtocustomizedynamicwizardtemplates
viatheControlPanel, andhowtocreatefilters.
Unit Objectives
After completing this unit, you will be able to:
• createaninputschedulebyutilizingtheEVSNDfunction,aswellasother
BPC functions.
• create a report by utilizing the EVGTS function, as well as work with
EVBET, and EVTIM.
• utilizetheAppNameargumentoftheEVGTSfunctiontoretrievedatafrom
multiple applications into a single report.
• workwithExcelconditionalformattinginanEVGTSreport.
• createrowandcolumnexpansionsusingtheEVEXPfunction.
• customizedynamicwizardtemplatesviatheControlPanel.
• create basic and advanced filters.
Unit Contents
Lesson: EVSND and Input Schedules..........................................2
Lesson: EVGTS and Reports ....................................................8
Lesson: EVGTS Multiple Application Reports ...............................12
Lesson: EVGTS Formatting....................................................14
Lesson: EVEXP and Expansions..............................................17
Lesson: Control Panel...........................................................20
Lesson: Filters....................................................................26
1
2009 © 2009 SAP AG. All rights reserved.
第 10 页 / 共 377 页
Unit1: Session1 BPC320
Lesson: EVSND and Input Schedules
Lesson Overview
In this lesson you will look at the following EV functions: EVSND, EVAPP,
EVAPD,EVAST,EVUSR,EVDIM,EVCVWandEVDES.
Lesson Objectives
Aftercompletingthislesson, youwillbeableto:
• createaninputschedulebyutilizingtheEVSNDfunction,aswellasother
BPC functions.
Business Example
Figure 1: Input Schedules
Figure 2: Saving Input Schedules
2
© 2009 SAP AG. All rights reserved. 2009
第 11 页 / 共 377 页
BPC320 Lesson: EVSND and Input Schedules
Figure 3: The EVSND Function
Figure4: SAPBusinessPlanningandConsolidationFunctions
3
2009 © 2009 SAP AG. All rights reserved.
第 12 页 / 共 377 页
Unit1: Session1 BPC320
Figure 5: The EVAPP Function
Figure 6: The EVAPD Function
Figure 7: The EVAST Function
4
© 2009 SAP AG. All rights reserved. 2009
第 13 页 / 共 377 页
BPC320 Lesson: EVSND and Input Schedules
Figure 8: The EVASD Function
Figure 9: The EVUSR Function
Figure 10: The EVDIM Function
5
2009 © 2009 SAP AG. All rights reserved.
第 14 页 / 共 377 页
Unit1: Session1 BPC320
Figure 11: The EVCVW Function
Figure 12: The EVDES Function
Lab 1a – Converting a Worksheet for EVSND Input
(part of the last unit)
Lab 1b – Converting a Worksheet for EVSND Input
(part of the last unit)
6
© 2009 SAP AG. All rights reserved. 2009
第 15 页 / 共 377 页
BPC320 Lesson: EVSND and Input Schedules
Lesson Summary
You should now be able to:
• createaninputschedulebyutilizingtheEVSNDfunction,aswellasother
BPC functions.
7
2009 © 2009 SAP AG. All rights reserved.
第 16 页 / 共 377 页
Unit1: Session1 BPC320
Lesson: EVGTS and Reports
Lesson Overview
InthislessonyouwilluseBPCreportingfunctionstocreateareporttemplate
from a Blank Excel Workbook
Lesson Objectives
Aftercompletingthislesson, youwillbeableto:
• create a report by utilizing the EVGTS function, as well as work with
EVBET, and EVTIM.
Business Example
Figure 13: Reports
Figure 14: Saving Reports
8
© 2009 SAP AG. All rights reserved. 2009
第 17 页 / 共 377 页
BPC320 Lesson: EVGTS and Reports
Figure 15: The EVGTS Function
Lab 2 – Creating an EVGTS Report
(part of the last unit)
Figure 16: The EVBET Function
9
2009 © 2009 SAP AG. All rights reserved.
第 18 页 / 共 377 页
Unit1: Session1 BPC320
Figure 17: The EVTIM Function
Lab 3 – Creating a Variance Calculation with EVBET
(part of the last unit)
Lab 4 – Creating a Trend Report with EVTIM
(part of the last unit)
10
© 2009 SAP AG. All rights reserved. 2009
第 19 页 / 共 377 页
BPC320 Lesson: EVGTS and Reports
Lesson Summary
You should now be able to:
• create a report by utilizing the EVGTS function, as well as work with
EVBET, and EVTIM.
11
2009 © 2009 SAP AG. All rights reserved.
第 20 页 / 共 377 页
Unit1: Session1 BPC320
Lesson: EVGTS Multiple Application Reports
Lesson Overview
Lesson Objectives
Aftercompletingthislesson, youwillbeableto:
• utilizetheAppNameargumentoftheEVGTSfunctiontoretrievedatafrom
multiple applications into a single report.
Business Example
Figure18: RetrievingDatafromMultipleApplications
Lab 5 – Retrieving Data from Multiple Applications
with EVGTS
(part of the last unit)
12
© 2009 SAP AG. All rights reserved. 2009
第 21 页 / 共 377 页
BPC320 Lesson: EVGTS Multiple Application Reports
Lesson Summary
You should now be able to:
• utilizetheAppNameargumentoftheEVGTSfunctiontoretrievedatafrom
multiple applications into a single report.
13
2009 © 2009 SAP AG. All rights reserved.
第 22 页 / 共 377 页
Unit1: Session1 BPC320
Lesson: EVGTS Formatting
Lesson Overview
InthislessonyouwillincorporateExcelConditionalFormattingintoanexisting
report template.
Lesson Objectives
Aftercompletingthislesson, youwillbeableto:
• workwithExcelconditionalformattinginanEVGTSreport.
Business Example
Excel’s Conditional Formatting feature can be used to automatically format
certaincellsinyourreportsandinputschedules. Thisfeaturecanbeusedtoapply
fonts/styles,borders,andcellshadingtocellsthatmeetaspecifiedcriteria. You
cancomparethevaluesofselectedcellstoaconstantortotheresultsofaformula.
Itisimportanttoutilizeconditionalformattinginordertomakeyourreportsand
input schedules as user–friendly as possible.
Figure 19: Conditional Formatting
14
© 2009 SAP AG. All rights reserved. 2009
第 23 页 / 共 377 页
BPC320 Lesson: EVGTS Formatting
Figure 20: Conditional Formatting Examples
Lab 6 – Adding Conditional Formatting to an EVGTS
Report
(part of the last unit)
Lab 7 – Modifying an Existing EVGTS Report
(part of the last unit)
15
2009 © 2009 SAP AG. All rights reserved.
第 24 页 / 共 377 页
Unit1: Session1 BPC320
Lesson Summary
You should now be able to:
• workwithExcelconditionalformattinginanEVGTSreport.
16
© 2009 SAP AG. All rights reserved. 2009
第 25 页 / 共 377 页
BPC320 Lesson: EVEXP and Expansions
Lesson: EVEXP and Expansions
Lesson Overview
Lesson Objectives
Aftercompletingthislesson, youwillbeableto:
• createrowandcolumnexpansionsusingtheEVEXPfunction.
Business Example
Figure 21: Expansion Functions
Figure 22: Dynamic Expansions & Drill Downs
Figure 23: The EVEXP Function
17
2009 © 2009 SAP AG. All rights reserved.
第 26 页 / 共 377 页
Unit1: Session1 BPC320
DataRange – the first row of the data ranges formulas are copied and used in
the expansion.
IncludeFlag–dependingontheflag, defineswhichmembersinrelationtothe
Memberareincluded. ThereareEverestflagsandalsoMDXflags.
Lab 8 – Creating Expansions with EVEXP
(part of the last unit)
18
© 2009 SAP AG. All rights reserved. 2009
第 27 页 / 共 377 页
BPC320 Lesson: EVEXP and Expansions
Lesson Summary
You should now be able to:
• createrowandcolumnexpansionsusingtheEVEXPfunction.
19
2009 © 2009 SAP AG. All rights reserved.
第 28 页 / 共 377 页
Unit1: Session1 BPC320
Lesson: Control Panel
Lesson Overview
Lesson Objectives
Aftercompletingthislesson, youwillbeableto:
• customizedynamicwizardtemplatesviatheControlPanel.
Business Example
Figure 24: The Control Panel
Figure 25: Configure the Layout
20
© 2009 SAP AG. All rights reserved. 2009
第 29 页 / 共 377 页
BPC320 Lesson: Control Panel
Figure 26: Specify Expansion Options
Figure 27: EV Expansion Options
21
2009 © 2009 SAP AG. All rights reserved.
第 30 页 / 共 377 页
Unit1: Session1 BPC320
Figure 28: MDX Expansion Options
Figure 29: Freeze Dimension Settings
22
© 2009 SAP AG. All rights reserved. 2009
第 31 页 / 共 377 页
BPC320 Lesson: Control Panel
Figure 30: Scale
Figure 31: Utilize Expansions
Figure 32: Filter
23
2009 © 2009 SAP AG. All rights reserved.
第 32 页 / 共 377 页
Unit1: Session1 BPC320
Lab 9 – Filtering via the Control Panel
(part of the last unit)
24
© 2009 SAP AG. All rights reserved. 2009
第 33 页 / 共 377 页
BPC320 Lesson: Control Panel
Lesson Summary
You should now be able to:
• customizedynamicwizardtemplatesviatheControlPanel.
25
2009 © 2009 SAP AG. All rights reserved.
第 34 页 / 共 377 页
Unit1: Session1 BPC320
Lesson: Filters
Lesson Overview
Lesson Objectives
Aftercompletingthislesson, youwillbeableto:
• create basic and advanced filters.
Business Example
Figure33: UserDefinedPropertiesandReportFiltering
26
© 2009 SAP AG. All rights reserved. 2009
第 35 页 / 共 377 页
BPC320 Lesson: Filters
Figure34: UserDefinedPropertiesandReportFiltering
Figure35: UserDefinedPropertiesandReportFiltering
27
2009 © 2009 SAP AG. All rights reserved.
第 36 页 / 共 377 页
Unit1: Session1 BPC320
Figure36: UtilizingtheNewPropertyintheControlPanel
Figure 37: Filtering via the Control Panel
Figure 38: The EVPRO Function
28
© 2009 SAP AG. All rights reserved. 2009
第 37 页 / 共 377 页
BPC320 Lesson: Filters
Figure39: TheEVPROFunctionandDynamicFiltering
Figure 40: Custom Report Filtering
Figure 41: Custom Report Filtering Syntax
29
2009 © 2009 SAP AG. All rights reserved.
第 38 页 / 共 377 页
Unit1: Session1 BPC320
Figure42: FilteringonMultipleProperties: Example
Figure43: FilteringonMultipleProperties: Example
Figure44: FilteringonMultipleProperties: Example
30
© 2009 SAP AG. All rights reserved. 2009
第 39 页 / 共 377 页
BPC320 Lesson: Filters
Figure 45: The Name Function
Figure 46: The Count Function
Lab 10 – Utilizing EVPRO in Control Panel Filtering
(part of the last unit)
Lab 11 – Filtering on Multiple Properties in an EVGTS
Report
(part of the last unit)
Lab 12 – Filtering with MDX Functions in an EVGTS
Report
(part of the last unit)
31
2009 © 2009 SAP AG. All rights reserved.
第 40 页 / 共 377 页
Unit1: Session1 BPC320
Lesson Summary
You should now be able to:
• create basic and advanced filters.
32
© 2009 SAP AG. All rights reserved. 2009
第 41 页 / 共 377 页
BPC320 Unit Summary
Unit Summary
You should now be able to:
• createaninputschedulebyutilizingtheEVSNDfunction,aswellasother
BPC functions.
• create a report by utilizing the EVGTS function, as well as work with
EVBET, and EVTIM.
• utilizetheAppNameargumentoftheEVGTSfunctiontoretrievedatafrom
multiple applications into a single report.
• workwithExcelconditionalformattinginanEVGTSreport.
• createrowandcolumnexpansionsusingtheEVEXPfunction.
• customizedynamicwizardtemplatesviatheControlPanel.
• create basic and advanced filters.
33
2009 © 2009 SAP AG. All rights reserved.
第 42 页 / 共 377 页
UnitSummary BPC320
34
© 2009 SAP AG. All rights reserved. 2009
第 43 页 / 共 377 页
第 44 页 / 共 377 页
第 45 页 / 共 377 页
Unit 2
Session 2
Unit Overview
After completing this unit you will understand how to work with workbook
options, suppression, indent row headers, and create custom buttons in
EVGTS/EVSNDworkbooks;customizeconditionalformattingindynamicwizard
templates;andcreateformattedEVDREreportsandinputschedules.
Unit Objectives
After completing this unit, you will be able to:
• set workbook options.
• workwithsuppressioninEVGTS/EVSNDworkbooks.
• indentrowheadersbasedonadimension’shierarchicalorganization,aswell
ascreatecustombuttons,inEVGTS/EVSNDworkbooks.
• customize dynamic wizard templates and their built-in conditional
formatting.
• create EVDRE reports and input schedules and work with MemberSet
options.
• utilize the EVDRE Format table.
Unit Contents
Lesson: Workbook Options.....................................................36
Lesson: EVGTS/EVSND Suppression........................................41
Lesson: Indentation and Custom Buttons ....................................46
Lesson: Dynamic Wizard Templates..........................................50
Lesson: Introduction to EVDRE................................................56
Lesson: EVDRE Formatting....................................................70
35
2009 © 2009 SAP AG. All rights reserved.
第 46 页 / 共 377 页
Unit2: Session2 BPC320
Lesson: Workbook Options
Lesson Overview
Lesson Objectives
Aftercompletingthislesson, youwillbeableto:
• set workbook options.
Business Example
Figure 47: Workbook Options
36
© 2009 SAP AG. All rights reserved. 2009
第 47 页 / 共 377 页
BPC320 Lesson: Workbook Options
Figure48: WorkbookTypeandRefreshOptions
Figure 49: Worksheet Password
Figure 50: Override Current View
37
2009 © 2009 SAP AG. All rights reserved.
第 48 页 / 共 377 页
Unit2: Session2 BPC320
Figure 51: Lock Status
Figure 52: Maximum Expansion Limit
Figure 53: Drill Down Options
38
© 2009 SAP AG. All rights reserved. 2009
第 49 页 / 共 377 页
BPC320 Lesson: Workbook Options
Figure 54: Read Options for Comment
Lab 13 – Drilling in Place in an EVGTS Report
(part of the last unit)
39
2009 © 2009 SAP AG. All rights reserved.
第 50 页 / 共 377 页
Unit2: Session2 BPC320
Lesson Summary
You should now be able to:
• set workbook options.
40
© 2009 SAP AG. All rights reserved. 2009
第 51 页 / 共 377 页
BPC320 Lesson: EVGTS/EVSND Suppression
Lesson: EVGTS/EVSND Suppression
Lesson Overview
Lesson Objectives
Aftercompletingthislesson, youwillbeableto:
• workwithsuppressioninEVGTS/EVSNDworkbooks.
Business Example
Figure 55: Suppression via the Control Panel
Figure56: ControlPanelSuppression: HowitWorks
41
2009 © 2009 SAP AG. All rights reserved.
第 52 页 / 共 377 页
Unit2: Session2 BPC320
Figure57: ControlPanelSuppression: HowitWorks
Figure 58: Custom Suppression: Example
Figure 59: Custom Suppression: Example
42
© 2009 SAP AG. All rights reserved. 2009
第 53 页 / 共 377 页
BPC320 Lesson: EVGTS/EVSND Suppression
Figure 60: Custom Suppression: Example
Figure61: CustomSuppression: AsymmetricExample
43
2009 © 2009 SAP AG. All rights reserved.
第 54 页 / 共 377 页
Unit2: Session2 BPC320
Figure62: CustomSuppression: AsymmetricReports
Figure63: CustomSuppression: AsymmetricReports
Lab 14 – Custom Suppression in an EVGTS Report
(part of the last unit)
Lab 15 – Asymmetric Suppression in an EVGTS Report
(part of the last unit)
44
© 2009 SAP AG. All rights reserved. 2009
第 55 页 / 共 377 页
BPC320 Lesson: EVGTS/EVSND Suppression
Lesson Summary
You should now be able to:
• workwithsuppressioninEVGTS/EVSNDworkbooks.
45
2009 © 2009 SAP AG. All rights reserved.
第 56 页 / 共 377 页
Unit2: Session2 BPC320
Lesson: Indentation and Custom Buttons
Lesson Overview
Lesson Objectives
Aftercompletingthislesson, youwillbeableto:
• indentrowheadersbasedonadimension’shierarchicalorganization,aswell
ascreatecustombuttons,inEVGTS/EVSNDworkbooks.
Business Example
Figure 64: Adding Indentation to Reports
Figure 65: Adding Indentation: REPT & EVDES
46
© 2009 SAP AG. All rights reserved. 2009
第 57 页 / 共 377 页
BPC320 Lesson: Indentation and Custom Buttons
Lab 16 – Indenting Row Headers in an EVGTS Report
(part of the last unit)
Figure 66: Custom Buttons
Figure 67: Custom Buttons: Procedures
47
2009 © 2009 SAP AG. All rights reserved.
第 58 页 / 共 377 页
Unit2: Session2 BPC320
Figure 68: Custom Buttons: MNU Commands
Lab 17 – Creating a Custom Button in an EVSND Input
Schedule
(part of the last unit)
48
© 2009 SAP AG. All rights reserved. 2009
第 59 页 / 共 377 页
BPC320 Lesson: Indentation and Custom Buttons
Lesson Summary
You should now be able to:
• indentrowheadersbasedonadimension’shierarchicalorganization,aswell
ascreatecustombuttons,inEVGTS/EVSNDworkbooks.
49
2009 © 2009 SAP AG. All rights reserved.
第 60 页 / 共 377 页
Unit2: Session2 BPC320
Lesson: Dynamic Wizard Templates
Lesson Overview
Lesson Objectives
Aftercompletingthislesson, youwillbeableto:
• customize dynamic wizard templates and their built-in conditional
formatting.
Business Example
Figure69: ConditionalFormattinginDynamicWizardTemplates
50
© 2009 SAP AG. All rights reserved. 2009
第 61 页 / 共 377 页
BPC320 Lesson: Dynamic Wizard Templates
Figure70: ConditionalFormatting: Hlevel,RowStyle,Calc
Figure 71: Conditional Formatting: Row Style
51
2009 © 2009 SAP AG. All rights reserved.
第 62 页 / 共 377 页
Unit2: Session2 BPC320
Figure 72: Dynamic Wizard Templates
Figure73: CustomizingDynamicWizardTemplates
Figure 74: Wizard Dialog Box
52
© 2009 SAP AG. All rights reserved. 2009
第 63 页 / 共 377 页
BPC320 Lesson: Dynamic Wizard Templates
Figure 75: The Description.txt File
Figure 76: The TemplateN.txt File
53
2009 © 2009 SAP AG. All rights reserved.
第 64 页 / 共 377 页
Unit2: Session2 BPC320
Figure 77: The ImageN.bmp File
Figure 78: Template Version Number
Lab 18 – Customizing Dynamic Wizard Templates
(part of the last unit)
54
© 2009 SAP AG. All rights reserved. 2009
第 65 页 / 共 377 页
BPC320 Lesson: Dynamic Wizard Templates
Lesson Summary
You should now be able to:
• customize dynamic wizard templates and their built-in conditional
formatting.
55
2009 © 2009 SAP AG. All rights reserved.
第 66 页 / 共 377 页
Unit2: Session2 BPC320
Lesson: Introduction to EVDRE
Lesson Overview
Lesson Objectives
Aftercompletingthislesson, youwillbeableto:
• create EVDRE reports and input schedules and work with MemberSet
options.
Business Example
Figure 79: EVDRE
Figure 80: Why Use EVDRE?
Figure 81: Why Use EVDRE? (continued)
56
© 2009 SAP AG. All rights reserved. 2009
第 67 页 / 共 377 页
BPC320 Lesson: Introduction to EVDRE
Figure 82: Building an EVDRE Report
Figure 83: The EVDRE Builder
57
2009 © 2009 SAP AG. All rights reserved.
第 68 页 / 共 377 页
Unit2: Session2 BPC320
Figure 84: The EVDRE Builder: Grid Layout
Figure 85: The EVDRE Builder: Grid Design
58
© 2009 SAP AG. All rights reserved. 2009
第 69 页 / 共 377 页
BPC320 Lesson: Introduction to EVDRE
Figure 86: The EVDRE Builder: OK
Figure 87: Workbook Options: Workbook Type
59
2009 © 2009 SAP AG. All rights reserved.
第 70 页 / 共 377 页
Unit2: Session2 BPC320
Figure 88: EVDRE: Main Ranges
Figure 89: Status Message
Figure 90: The Key Range Table
60
© 2009 SAP AG. All rights reserved. 2009
第 71 页 / 共 377 页
BPC320 Lesson: Introduction to EVDRE
Figure 91: Page Key Range
Figure 92: EVCVW
61
2009 © 2009 SAP AG. All rights reserved.
第 72 页 / 共 377 页
Unit2: Session2 BPC320
Figure 93: EVMBR
Figure 94: Col Key Range & Row Key Range
62
© 2009 SAP AG. All rights reserved. 2009
第 73 页 / 共 377 页
BPC320 Lesson: Introduction to EVDRE
Figure 95: Cell Key Range (Optional)
Figure 96: Get Only Range (Optional)
Figure 97: Format Range (Optional)
63
2009 © 2009 SAP AG. All rights reserved.
第 74 页 / 共 377 页
Unit2: Session2 BPC320
Figure98: OptionRangeandSortRange(Optional)
Figure 99: Option Table
Figure 100: The Expand Range Table
64
© 2009 SAP AG. All rights reserved. 2009
第 75 页 / 共 377 页
BPC320 Lesson: Introduction to EVDRE
Figure 101: ExpandIn & Dimenson
Figure 102: MemberSet
Figure 103: Expand All
Lab 19 – Creating an EVDRE Report
(part of the last unit)
Lab 20 – Creating an EVDRE Input Schedule
(part of the last unit)
65
2009 © 2009 SAP AG. All rights reserved.
第 76 页 / 共 377 页
Unit2: Session2 BPC320
Figure 104: MemberSet
Figure 105: MemberSet: Comma-delimited list
Figure 106: MemberSet: Keyword
66
© 2009 SAP AG. All rights reserved. 2009
第 77 页 / 共 377 页
BPC320 Lesson: Introduction to EVDRE
Figure 107: MemberSet: Keyword NOEXPAND
Figure 108: MemberSet: Filter
Figure 109: MemberSet Keywords & Properties
67
2009 © 2009 SAP AG. All rights reserved.
第 78 页 / 共 377 页
Unit2: Session2 BPC320
Figure 110: MemberSet: Null Field
Lab 21 – Working with EVDRE MemberSet Options
(part of the last unit)
68
© 2009 SAP AG. All rights reserved. 2009
第 79 页 / 共 377 页
BPC320 Lesson: Introduction to EVDRE
Lesson Summary
You should now be able to:
• create EVDRE reports and input schedules and work with MemberSet
options.
69
2009 © 2009 SAP AG. All rights reserved.
第 80 页 / 共 377 页
Unit2: Session2 BPC320
Lesson: EVDRE Formatting
Lesson Overview
Lesson Objectives
Aftercompletingthislesson, youwillbeableto:
• utilize the EVDRE Format table.
Business Example
Figure 111: Format Range
70
© 2009 SAP AG. All rights reserved. 2009
第 81 页 / 共 377 页
BPC320 Lesson: EVDRE Formatting
Figure112: FormatRange: Usingthe6columntable
Figure 113: Format Table Columns
71
2009 © 2009 SAP AG. All rights reserved.
第 82 页 / 共 377 页
Unit2: Session2 BPC320
Figure 114: Format Table Columns: CRITERIA
Figure115: FormatTableColumns: EVALUATEIN
Figure 116: Format Table Columns: FORMAT
72
© 2009 SAP AG. All rights reserved. 2009
第 83 页 / 共 377 页
BPC320 Lesson: EVDRE Formatting
Figure 117: Format Table Columns: USE
Figure118: FormatTableColumns: PARAMETERS
73
2009 © 2009 SAP AG. All rights reserved.
第 84 页 / 共 377 页
Unit2: Session2 BPC320
Figure 119: Format Table Columns: APPLY TO
Figure 120: EVDRE Style Sheets
Figure 121: Formatting Tips
74
© 2009 SAP AG. All rights reserved. 2009
第 85 页 / 共 377 页
BPC320 Lesson: EVDRE Formatting
Lab 22 – Working with EVDRE Formatting Options
(part of the last unit)
75
2009 © 2009 SAP AG. All rights reserved.
第 86 页 / 共 377 页
Unit2: Session2 BPC320
Lesson Summary
You should now be able to:
• utilize the EVDRE Format table.
76
© 2009 SAP AG. All rights reserved. 2009
第 87 页 / 共 377 页
BPC320 Unit Summary
Unit Summary
You should now be able to:
• set workbook options.
• workwithsuppressioninEVGTS/EVSNDworkbooks.
• indentrowheadersbasedonadimension’shierarchicalorganization,aswell
ascreatecustombuttons,inEVGTS/EVSNDworkbooks.
• customize dynamic wizard templates and their built-in conditional
formatting.
• create EVDRE reports and input schedules and work with MemberSet
options.
• utilize the EVDRE Format table.
77
2009 © 2009 SAP AG. All rights reserved.
第 88 页 / 共 377 页
UnitSummary BPC320
78
© 2009 SAP AG. All rights reserved. 2009
第 89 页 / 共 377 页
第 90 页 / 共 377 页
第 91 页 / 共 377 页
Unit 3
Session 3
Unit Overview
After completing this unit you will understand how to work with advanced
EVDRE functionality, including: nested dimensions, before and after ranges,
multiple key ranges and EVDRE functions, standard and “3D” expansions,
sorting,“onthefly”pagekeycalculations,indentation,andbestpractices.
Unit Objectives
After completing this unit, you will be able to:
• workwiththeBeforeRangeandAfterRangeoptionsinstandardandnested
EVDRE workbooks.
• UtilizebasicandadvancedsuppressioninEVDREworkbooks.
• understand how the same EvDRE function call can support multiple key
rangesonbothcolumnsandrowssimultaneously,aswellashowtoretrieve
datafrommultipleapplicationsbyusingtwoEVDREfunctionsinthesame
report.
• define a 3D expansion by using the EVDRE Builder, which sets the
ExpandInparametertoSHEETfortheselecteddimension.
• utilize the EVDRE Sort table.
• utilizeEVDREdrilldownfunctionality,aswellasdefinecomma-delimited
membersaspagekeystoaggregatemembersonthefly.
• utilizeBPCandExcelfunctionstoindenttherowheadingsinanEVDRE
reportbaseduponthehierarchicalstructureofthedimension.
• understandbestpracticeswithregardtoEVDREworkbooks.
Unit Contents
Lesson: Before and AfterRange Options.....................................81
Lesson: EVDRE Suppression..................................................86
Lesson: Multiple Key Ranges and EVDREs .................................90
Lesson: 3D Expansions.........................................................94
Lesson: EVDRE Sorting ........................................................97
Lesson: EVDRE Drill Down and PageKey Functionality...................100
Lesson: EVDRE Indentation ..................................................103
79
2009 © 2009 SAP AG. All rights reserved.
第 92 页 / 共 377 页
Unit3: Session3 BPC320
Lesson: EVDRE Best Practices...............................................106
80
© 2009 SAP AG. All rights reserved. 2009
第 93 页 / 共 377 页
BPC320 Lesson: Before and AfterRange Options
Lesson: Before and AfterRange Options
Lesson Overview
After completing this lesson you will understand how to work with the
BeforeRangeandAfterRangeoptionsinstandardandnestedEVDREworkbooks.
Lesson Objectives
Aftercompletingthislesson, youwillbeableto:
• workwiththeBeforeRangeandAfterRangeoptionsinstandardandnested
EVDRE workbooks.
Business Example
Figure 122: Nested Dimensions
81
2009 © 2009 SAP AG. All rights reserved.
第 94 页 / 共 377 页
Unit3: Session3 BPC320
Figure 123: Nested Dimensions (continued)
Figure 124: BeforeRange & AfterRange
82
© 2009 SAP AG. All rights reserved. 2009
第 95 页 / 共 377 页
BPC320 Lesson: Before and AfterRange Options
Figure 125: Before Range Example
Figure 126: After Range Example
83
2009 © 2009 SAP AG. All rights reserved.
第 96 页 / 共 377 页
Unit3: Session3 BPC320
Figure 127: The EVRNG Function
Lab 23 – Creating Nested Dimensions in an EVDRE
Report
(part of the last unit)
Lab 24 – Working with EVDRE AfterRange Options
(part of the last unit)
84
© 2009 SAP AG. All rights reserved. 2009
第 97 页 / 共 377 页
BPC320 Lesson: Before and AfterRange Options
Lesson Summary
You should now be able to:
• workwiththeBeforeRangeandAfterRangeoptionsinstandardandnested
EVDRE workbooks.
85
2009 © 2009 SAP AG. All rights reserved.
第 98 页 / 共 377 页
Unit3: Session3 BPC320
Lesson: EVDRE Suppression
Lesson Overview
Lesson Objectives
Aftercompletingthislesson, youwillbeableto:
• UtilizebasicandadvancedsuppressioninEVDREworkbooks.
Business Example
Figure 128: Suppress
Figure 129: Suppress (Continued)
86
© 2009 SAP AG. All rights reserved. 2009
第 99 页 / 共 377 页
BPC320 Lesson: EVDRE Suppression
Figure130: EVDRESuppression: AsymmetricExample
Figure131: EVDRESuppression: AsymmetricExample(continued)
87
2009 © 2009 SAP AG. All rights reserved.
第 100 页 / 共 377 页
Unit3: Session3 BPC320
Figure132: EVDRESuppression: AsymmetricExample(continued)
Lab 25 – Working with EVDRE Suppression Options
(part of the last unit)
Lab 26 – Utilizing Suppression in an Asymmetric
EVDRE Report
(part of the last unit)
88
© 2009 SAP AG. All rights reserved. 2009
第 101 页 / 共 377 页
BPC320 Lesson: EVDRE Suppression
Lesson Summary
You should now be able to:
• UtilizebasicandadvancedsuppressioninEVDREworkbooks.
89
2009 © 2009 SAP AG. All rights reserved.
第 102 页 / 共 377 页
Unit3: Session3 BPC320
Lesson: Multiple Key Ranges and EVDREs
Lesson Overview
Lesson Objectives
Aftercompletingthislesson, youwillbeableto:
• understand how the same EvDRE function call can support multiple key
rangesonbothcolumnsandrowssimultaneously,aswellashowtoretrieve
datafrommultipleapplicationsbyusingtwoEVDREfunctionsinthesame
report.
Business Example
Figure 133: The EVDRE Function
90
© 2009 SAP AG. All rights reserved. 2009
第 103 页 / 共 377 页
BPC320 Lesson: Multiple Key Ranges and EVDREs
Figure 134: Multiple Key Ranges
Figure135: RetrievingDatafromMultipleApplicationswithEVDRE
91
2009 © 2009 SAP AG. All rights reserved.
第 104 页 / 共 377 页
Unit3: Session3 BPC320
Figure 136: Multiple EVDRE Functions
Lab 27 – Creating Multiple Key Ranges in an EVDRE
Report
(part of the last unit)
Lab 28 – Retrieving Data from Multiple Applications
with EVDRE
(part of the last unit)
92
© 2009 SAP AG. All rights reserved. 2009
第 105 页 / 共 377 页
BPC320 Lesson: Multiple Key Ranges and EVDREs
Lesson Summary
You should now be able to:
• understand how the same EvDRE function call can support multiple key
rangesonbothcolumnsandrowssimultaneously,aswellashowtoretrieve
datafrommultipleapplicationsbyusingtwoEVDREfunctionsinthesame
report.
93
2009 © 2009 SAP AG. All rights reserved.
第 106 页 / 共 377 页
Unit3: Session3 BPC320
Lesson: 3D Expansions
Lesson Overview
Lesson Objectives
Aftercompletingthislesson, youwillbeableto:
• define a 3D expansion by using the EVDRE Builder, which sets the
ExpandInparametertoSHEETfortheselecteddimension.
Business Example
Figure137: 3DExpansions: Spreadacrossworksheets
Figure138: Spreadacrossworksheets(continued)
94
© 2009 SAP AG. All rights reserved. 2009
第 107 页 / 共 377 页
BPC320 Lesson: 3D Expansions
Lab 29 – Expanding Across Sheets with EVDRE
(part of the last unit)
95
2009 © 2009 SAP AG. All rights reserved.
第 108 页 / 共 377 页
Unit3: Session3 BPC320
Lesson Summary
You should now be able to:
• define a 3D expansion by using the EVDRE Builder, which sets the
ExpandInparametertoSHEETfortheselecteddimension.
96
© 2009 SAP AG. All rights reserved. 2009
第 109 页 / 共 377 页
BPC320 Lesson: EVDRE Sorting
Lesson: EVDRE Sorting
Lesson Overview
Lesson Objectives
Aftercompletingthislesson, youwillbeableto:
• utilize the EVDRE Sort table.
Business Example
Figure 139: Sort Table
Figure 140: Sort Table (continued)
97
2009 © 2009 SAP AG. All rights reserved.
第 110 页 / 共 377 页
Unit3: Session3 BPC320
Lab 30 – Working with EVDRE Sorting Options
(part of the last unit)
98
© 2009 SAP AG. All rights reserved. 2009
第 111 页 / 共 377 页
BPC320 Lesson: EVDRE Sorting
Lesson Summary
You should now be able to:
• utilize the EVDRE Sort table.
99
2009 © 2009 SAP AG. All rights reserved.
第 112 页 / 共 377 页
Unit3: Session3 BPC320
Lesson: EVDRE Drill Down and PageKey Functionality
Lesson Overview
Lesson Objectives
Aftercompletingthislesson, youwillbeableto:
• utilizeEVDREdrilldownfunctionality,aswellasdefinecomma-delimited
membersaspagekeystoaggregatemembersonthefly.
Business Example
Figure 141: EVDRE Drill Down Behavior
100
© 2009 SAP AG. All rights reserved. 2009
第 113 页 / 共 377 页
BPC320 Lesson: EVDRE Drill Down and PageKey Functionality
Figure142: PageKeyRange: Comma-delimitedMembers
Lab 31 – Utilizing EVDRE Drill Down and PageKey
Functionality
(part of the last unit)
101
2009 © 2009 SAP AG. All rights reserved.
第 114 页 / 共 377 页
Unit3: Session3 BPC320
Lesson Summary
You should now be able to:
• utilizeEVDREdrilldownfunctionality,aswellasdefinecomma-delimited
membersaspagekeystoaggregatemembersonthefly.
102
© 2009 SAP AG. All rights reserved. 2009
第 115 页 / 共 377 页
BPC320 Lesson: EVDRE Indentation
Lesson: EVDRE Indentation
Lesson Overview
Lesson Objectives
Aftercompletingthislesson, youwillbeableto:
• utilizeBPCandExcelfunctionstoindenttherowheadingsinanEVDRE
reportbaseduponthehierarchicalstructureofthedimension.
Business Example
Figure143: AddingIndentationtoEVDREReports
103
2009 © 2009 SAP AG. All rights reserved.
第 116 页 / 共 377 页
Unit3: Session3 BPC320
Figure144: AddingIndentation: REPT&EVDES
Lab 32 – Indenting Row Headers in an EVDRE Report
(part of the last unit)
104
© 2009 SAP AG. All rights reserved. 2009
第 117 页 / 共 377 页
BPC320 Lesson: EVDRE Indentation
Lesson Summary
You should now be able to:
• utilizeBPCandExcelfunctionstoindenttherowheadingsinanEVDRE
reportbaseduponthehierarchicalstructureofthedimension.
105
2009 © 2009 SAP AG. All rights reserved.
第 118 页 / 共 377 页
Unit3: Session3 BPC320
Lesson: EVDRE Best Practices
Lesson Overview
Lesson Objectives
Aftercompletingthislesson, youwillbeableto:
• understandbestpracticeswithregardtoEVDREworkbooks.
Business Example
Figure 145: EVDRE Best Practices
Figure 146: EVDRE Best Practices (continued)
106
© 2009 SAP AG. All rights reserved. 2009
第 119 页 / 共 377 页
BPC320 Lesson: EVDRE Best Practices
Figure 147: EVDRE Best Practices (continued)
Figure 148: EVDRE Best Practices (continued)
Figure 149: EVDRE Best Practices (continued)
107
2009 © 2009 SAP AG. All rights reserved.
第 120 页 / 共 377 页
Unit3: Session3 BPC320
Figure 150: EVDRE Best Practices (continued)
108
© 2009 SAP AG. All rights reserved. 2009
第 121 页 / 共 377 页
BPC320 Lesson: EVDRE Best Practices
Lesson Summary
You should now be able to:
• understandbestpracticeswithregardtoEVDREworkbooks.
109
2009 © 2009 SAP AG. All rights reserved.
第 122 页 / 共 377 页
UnitSummary BPC320
Unit Summary
You should now be able to:
• workwiththeBeforeRangeandAfterRangeoptionsinstandardandnested
EVDRE workbooks.
• UtilizebasicandadvancedsuppressioninEVDREworkbooks.
• understand how the same EvDRE function call can support multiple key
rangesonbothcolumnsandrowssimultaneously,aswellashowtoretrieve
datafrommultipleapplicationsbyusingtwoEVDREfunctionsinthesame
report.
• define a 3D expansion by using the EVDRE Builder, which sets the
ExpandInparametertoSHEETfortheselecteddimension.
• utilize the EVDRE Sort table.
• utilizeEVDREdrilldownfunctionality,aswellasdefinecomma-delimited
membersaspagekeystoaggregatemembersonthefly.
• utilizeBPCandExcelfunctionstoindenttherowheadingsinanEVDRE
reportbaseduponthehierarchicalstructureofthedimension.
• understandbestpracticeswithregardtoEVDREworkbooks.
110
© 2009 SAP AG. All rights reserved. 2009