BPC321_EN_Col91_FV_Part_A4 (第1页)

第 1 页 / 共 195 页

BPC321

SAP Business Planning and

Consolidation

Date

Training Center

Instructors

Education Website

Participant Handbook

Course Version: 91

CourseDuration:5Days

Material Number: 50093568

An SAP course - use it to learn, reference it for work

第 2 页 / 共 195 页

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.

g200944045

第 3 页 / 共 195 页

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

bothinternal(inthisdocumentation)andexternal(in

other locations, such asSAPNet).

Example text Emphasizedwords or phrases in bodytext, titlesof

graphics, and tables

EXAMPLETEXT Names of elements in the system. These include

reportnames,programnames,transactioncodes,table

names, andindividualkey wordsof aprogramming

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.

Icons in Body Text

The following iconsareused in thishandbook.

iii

Type Style	Description
Example text	Wordsorcharactersthatappearonthescreen. These includefieldnames,screentitles,pushbuttonsaswell asmenunames, paths, andoptions. Alsousedforcross-referencestootherdocumentation bothinternal(inthisdocumentation)andexternal(in other locations, such asSAPNet).
Example text	Emphasizedwords or phrases in bodytext, titlesof graphics, and tables
EXAMPLETEXT	Names of elements in the system. These include reportnames,programnames,transactioncodes,table names, andindividualkey wordsof aprogramming 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 页 / 共 195 页

AboutThisHandbook BPC320

Icon Meaning

Formoreinformation,tips,orbackground

Noteorfurtherexplanationofpreviouspoint

Exception or caution

Procedures

Indicatesthattheitemisdisplayedintheinstructor's

presentation.

Icon	Meaning
	Formoreinformation,tips,orbackground
	Noteorfurtherexplanationofpreviouspoint
	Exception or caution
	Procedures
	Indicatesthattheitemisdisplayedintheinstructor's presentation.

第 5 页 / 共 195 页

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...................................................................25

Unit 2: Session 2......................................................... 35

Workbook Options....................................................36

EVGTS/EVSND Suppression .......................................41

Indentation and Custom Buttons....................................46

Dynamic Wizard Templates..........................................49

Introduction to EVDRE...............................................55

EVDRE Formatting ...................................................69

Unit 3: Session 3......................................................... 79

Before and AfterRange Options.....................................81

EVDRE Suppression .................................................86

Multiple Key Ranges and EVDREs.................................90

3D Expansions........................................................94

EVDRE Sorting........................................................96

EVDRE Drill Down and PageKey Functionality...................98

EVDRE Indentation..................................................101

EVDRE Best Practices..............................................104

Unit 4: Session 4........................................................113

Budgeting Overview.................................................114

MDX Calculation.....................................................121

Budgeting Input Schedules.........................................125

Viewable Data........................................................127

Budgeting and BPFs.................................................130

Top Down Modeling..................................................138

第 6 页 / 共 195 页

Contents BPC320

Unit 5: Session 5........................................................145

Foreign Currency Translation ......................................146

Inter-company Eliminations.........................................155

Journals...............................................................161

Insight .................................................................172

第 7 页 / 共 195 页

Unit 1

Session 1

Unit Overview

Aftercompletingthisunityouwillunderstandhowtocreateinputschedulesand

reportsbyutilizingBPCfunctions,howtocustomizedynamicwizardtemplates

via the Control Panel, and howto create filters.

Unit Objectives

After completing thisunit, you will beableto:

• 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....................................................................25

第 8 页 / 共 195 页

Unit1: Session1 BPC320

Lesson: EVSND and Input Schedules

Lesson Overview

Lesson Objectives

After completingthislesson, you will beable to:

• createaninputschedulebyutilizingtheEVSNDfunction,aswellasother

BPC functions.

Business Example

Figure 1: Input Schedules

Figure 2: Saving Input Schedules

第 9 页 / 共 195 页

BPC320 Lesson: EVSND and Input Schedules

Figure 3: The EVSND Function

Figure4: SAPBusinessPlanningandConsolidationFunctions

第 10 页 / 共 195 页

Unit1: Session1 BPC320

Figure 5: The EVAPP Function

Figure 6: The EVAPD Function

Figure 7: The EVAST Function

第 11 页 / 共 195 页

BPC320 Lesson: EVSND and Input Schedules

Figure 8: The EVASD Function

Figure 9: The EVUSR Function

Figure 10: The EVDIM Function

第 12 页 / 共 195 页

Unit1: Session1 BPC320

Figure 11: The EVCVW Function

Figure 12: The EVDES Function

第 13 页 / 共 195 页

BPC320 Lesson: EVSND and Input Schedules

Lesson Summary

You should now be able to:

• createaninputschedulebyutilizingtheEVSNDfunction,aswellasother

BPC functions.

第 14 页 / 共 195 页

Unit1: Session1 BPC320

Lesson: EVGTS and Reports

Lesson Overview

Lesson Objectives

After completingthislesson, you will beable to:

• 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

第 15 页 / 共 195 页

BPC320 Lesson: EVGTS and Reports

Figure 15: The EVGTS Function

Figure 16: The EVBET Function

第 16 页 / 共 195 页

Unit1: Session1 BPC320

Figure 17: The EVTIM Function

第 17 页 / 共 195 页

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.

第 18 页 / 共 195 页

Unit1: Session1 BPC320

Lesson: EVGTS Multiple Application Reports

Lesson Overview

Lesson Objectives

After completingthislesson, you will beable to:

• utilizetheAppNameargumentoftheEVGTSfunctiontoretrievedatafrom

multiple applications into asingle report.

Business Example

Figure 18: Retrieving Data from Multiple Applications

第 19 页 / 共 195 页

BPC320 Lesson: EVGTS Multiple Application Reports

Lesson Summary

You should now be able to:

• utilizetheAppNameargumentoftheEVGTSfunctiontoretrievedatafrom

multiple applications into a single report.

第 20 页 / 共 195 页

Unit1: Session1 BPC320

Lesson: EVGTS Formatting

Lesson Overview

Lesson Objectives

After completingthislesson, you will beable to:

• workwithExcelconditionalformattinginanEVGTSreport.

Business Example

Figure 19: Conditional Formatting

第 21 页 / 共 195 页

BPC320 Lesson: EVGTS Formatting

Figure 20: Conditional Formatting Examples

第 22 页 / 共 195 页

Unit1: Session1 BPC320

Lesson Summary

You should now be able to:

• workwithExcelconditionalformattinginanEVGTSreport.

第 23 页 / 共 195 页

BPC320 Lesson: EVEXP and Expansions

Lesson: EVEXP and Expansions

Lesson Overview

Lesson Objectives

After completingthislesson, youwillbeable to:

• createrowandcolumnexpansionsusingtheEVEXPfunction.

Business Example

Figure 21: Expansion Functions

Figure 22: Dynamic Expansions & Drill Downs

Figure 23: The EVEXP Function

第 24 页 / 共 195 页

Unit1: Session1 BPC320

DataRange – the first row of the data ranges formulas are copied and used in

the expansion.

IncludeFlag–dependingontheflag, defineswhich members inrelation tothe

Memberareincluded. ThereareEverestflagsandalsoMDXflags.

第 25 页 / 共 195 页

BPC320 Lesson: EVEXP and Expansions

Lesson Summary

You should now be able to:

• createrowandcolumnexpansionsusingtheEVEXPfunction.

第 26 页 / 共 195 页

Unit1: Session1 BPC320

Lesson: Control Panel

Lesson Overview

Lesson Objectives

After completingthislesson, you will beable to:

• customizedynamicwizardtemplatesviatheControlPanel.

Business Example

Figure 24: The Control Panel

Figure 25: Configure the Layout

第 27 页 / 共 195 页

BPC320 Lesson: Control Panel

Figure 26: Specify Expansion Options

Figure 27: EV Expansion Options

第 28 页 / 共 195 页

Unit1: Session1 BPC320

Figure 28: MDX Expansion Options

Figure 29: Freeze Dimension Settings

第 29 页 / 共 195 页

BPC320 Lesson: Control Panel

Figure 30: Scale

Figure 31: Utilize Expansions

Figure 32: Filter

第 30 页 / 共 195 页

Unit1: Session1 BPC320

Lesson Summary

You should now be able to:

• customizedynamicwizardtemplatesviatheControlPanel.

第 31 页 / 共 195 页

BPC320 Lesson: Filters

Lesson: Filters

Lesson Overview

Lesson Objectives

After completingthislesson, youwillbeable to:

• create basic and advanced filters.

Business Example

Figure 33: UserDefined Properties and ReportFiltering

第 32 页 / 共 195 页

Unit1: Session1 BPC320

Figure 34: UserDefined Propertiesand Report Filtering

Figure 35: UserDefined Propertiesand Report Filtering

第 33 页 / 共 195 页

BPC320 Lesson: Filters

Figure 36: UtilizingtheNew Propertyin the ControlPanel

Figure 37: Filtering via the Control Panel

Figure 38: The EVPRO Function

第 34 页 / 共 195 页

Unit1: Session1 BPC320

Figure 39: The EVPRO Function and Dynamic Filtering

Figure 40: Custom Report Filtering

Figure 41: Custom Report Filtering Syntax

第 35 页 / 共 195 页

BPC320 Lesson: Filters

Figure 42: Filtering on Multiple Properties: Example

Figure 43: Filtering on Multiple Properties: Example

Figure 44: Filtering on Multiple Properties: Example

第 36 页 / 共 195 页

Unit1: Session1 BPC320

Figure 45: The Name Function

Figure 46: The Count Function

第 37 页 / 共 195 页

BPC320 Lesson: Filters

Lesson Summary

You should now be able to:

• create basic and advanced filters.

第 38 页 / 共 195 页

UnitSummary BPC320

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 asingle report.

• workwithExcelconditionalformattinginanEVGTSreport.

• createrowandcolumnexpansionsusingtheEVEXPfunction.

• customizedynamicwizardtemplatesviatheControlPanel.

• create basic and advanced filters.

第 39 页 / 共 195 页

第 40 页 / 共 195 页

第 41 页 / 共 195 页

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 thisunit, you will beableto:

• 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..........................................49

Lesson: Introduction to EVDRE................................................55

Lesson: EVDRE Formatting....................................................69

第 42 页 / 共 195 页

Unit2: Session2 BPC320

Lesson: Workbook Options

Lesson Overview

Lesson Objectives

After completingthislesson, you will beable to:

• set workbook options.

Business Example

Figure 47: Workbook Options

第 43 页 / 共 195 页

BPC320 Lesson: Workbook Options

Figure 48: Workbook Type and Refresh Options

Figure 49: Worksheet Password

Figure 50: Override Current View

第 44 页 / 共 195 页

Unit2: Session2 BPC320

Figure 51: Lock Status

Figure 52: Maximum Expansion Limit

Figure 53: Drill Down Options

第 45 页 / 共 195 页

BPC320 Lesson: Workbook Options

Figure 54: Read Options for Comment

第 46 页 / 共 195 页

Unit2: Session2 BPC320

Lesson Summary

You should now be able to:

• set workbook options.

第 47 页 / 共 195 页

BPC320 Lesson: EVGTS/EVSND Suppression

Lesson: EVGTS/EVSND Suppression

Lesson Overview

Lesson Objectives

After completingthislesson, youwillbeable to:

• workwithsuppressioninEVGTS/EVSNDworkbooks.

Business Example

Figure 55: Suppression via the Control Panel

Figure 56: ControlPanel Suppression: How it Works

第 48 页 / 共 195 页

Unit2: Session2 BPC320

Figure 57: Control PanelSuppression: How it Works

Figure 58: Custom Suppression: Example

Figure 59: Custom Suppression: Example

第 49 页 / 共 195 页

BPC320 Lesson: EVGTS/EVSND Suppression

Figure 60: Custom Suppression: Example

Figure 61: Custom Suppression: Asymmetric Example

第 50 页 / 共 195 页

Unit2: Session2 BPC320

Figure 62: Custom Suppression: Asymmetric Reports

Figure 63: Custom Suppression: Asymmetric Reports

第 51 页 / 共 195 页

BPC320 Lesson: EVGTS/EVSND Suppression

Lesson Summary

You should now be able to:

• workwithsuppressioninEVGTS/EVSNDworkbooks.

第 52 页 / 共 195 页

Unit2: Session2 BPC320

Lesson: Indentation and Custom Buttons

Lesson Overview

Lesson Objectives

After completingthislesson, you will beable to:

• indentrowheadersbasedonadimension’shierarchicalorganization,aswell

ascreatecustombuttons,inEVGTS/EVSNDworkbooks.

Business Example

Figure 64: Adding Indentation to Reports

Figure 65: Adding Indentation: REPT & EVDES

第 53 页 / 共 195 页

BPC320 Lesson: Indentation and Custom Buttons

Figure 66: Custom Buttons

Figure 67: Custom Buttons: Procedures

Figure 68: Custom Buttons: MNU Commands

第 54 页 / 共 195 页

Unit2: Session2 BPC320

Lesson Summary

You should now be able to:

• indentrowheadersbasedonadimension’shierarchicalorganization,aswell

ascreatecustombuttons,inEVGTS/EVSNDworkbooks.

第 55 页 / 共 195 页

BPC320 Lesson: Dynamic Wizard Templates

Lesson: Dynamic Wizard Templates

Lesson Overview

Lesson Objectives

After completingthislesson, youwillbeable to:

• customize dynamic wizard templates and their built-in conditional

formatting.

Business Example

Figure69: ConditionalFormattinginDynamicWizardTemplates

Figure 70: ConditionalFormatting: Hlevel,RowStyle, Calc

第 56 页 / 共 195 页

Unit2: Session2 BPC320

Figure 71: Conditional Formatting: Row Style

Figure 72: Dynamic Wizard Templates

第 57 页 / 共 195 页

BPC320 Lesson: Dynamic Wizard Templates

Figure 73: Customizing Dynamic Wizard Templates

Figure 74: Wizard Dialog Box

第 58 页 / 共 195 页

Unit2: Session2 BPC320

Figure 75: The Description.txt File

Figure 76: The TemplateN.txt File

第 59 页 / 共 195 页

BPC320 Lesson: Dynamic Wizard Templates

Figure 77: The ImageN.bmp File

Figure 78: Template Version Number

第 60 页 / 共 195 页

Unit2: Session2 BPC320

Lesson Summary

You should now be able to:

• customize dynamic wizard templates and their built-in conditional

formatting.

第 61 页 / 共 195 页

BPC320 Lesson: Introduction to EVDRE

Lesson: Introduction to EVDRE

Lesson Overview

Lesson Objectives

After completingthislesson, youwillbeable to:

• 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)

第 62 页 / 共 195 页

Unit2: Session2 BPC320

Figure 82: Building an EVDRE Report

Figure 83: The EVDRE Builder

第 63 页 / 共 195 页

BPC320 Lesson: Introduction to EVDRE

Figure 84: The EVDRE Builder: Grid Layout

Figure 85: The EVDRE Builder: Grid Design

第 64 页 / 共 195 页

Unit2: Session2 BPC320

Figure 86: The EVDRE Builder: OK

Figure 87: Workbook Options: Workbook Type

第 65 页 / 共 195 页

BPC320 Lesson: Introduction to EVDRE

Figure 88: EVDRE: Main Ranges

Figure 89: Status Message

Figure 90: The Key Range Table

第 66 页 / 共 195 页

Unit2: Session2 BPC320

Figure 91: Page Key Range

Figure 92: EVCVW

第 67 页 / 共 195 页

BPC320 Lesson: Introduction to EVDRE

Figure 93: EVMBR

Figure 94: Col Key Range & Row Key Range

第 68 页 / 共 195 页

Unit2: Session2 BPC320

Figure 95: Cell Key Range (Optional)

Figure 96: Get Only Range (Optional)

Figure 97: Format Range (Optional)

第 69 页 / 共 195 页

BPC320 Lesson: Introduction to EVDRE

Figure 98: Option Range and Sort Range (Optional)

Figure 99: Option Table

Figure 100: The Expand Range Table

第 70 页 / 共 195 页

Unit2: Session2 BPC320

Figure 101: ExpandIn & Dimenson

Figure 102: MemberSet

Figure 103: Expand All

第 71 页 / 共 195 页

BPC320 Lesson: Introduction to EVDRE

Figure 104: MemberSet

Figure 105: MemberSet: Comma-delimited list

Figure 106: MemberSet: Keyword

第 72 页 / 共 195 页

Unit2: Session2 BPC320

Figure 107: MemberSet: Keyword NOEXPAND

Figure 108: MemberSet: Filter

Figure 109: MemberSet Keywords & Properties

第 73 页 / 共 195 页

BPC320 Lesson: Introduction to EVDRE

Figure 110: MemberSet: Null Field

第 74 页 / 共 195 页

Unit2: Session2 BPC320

Lesson Summary

You should now be able to:

• create EVDRE reports and input schedules and work with MemberSet

options.

第 75 页 / 共 195 页

BPC320 Lesson: EVDRE Formatting

Lesson: EVDRE Formatting

Lesson Overview

Lesson Objectives

After completingthislesson, youwillbeable to:

• utilize the EVDRE Format table.

Business Example

Figure 111: Format Range

第 76 页 / 共 195 页

Unit2: Session2 BPC320

Figure 112: Format Range: Using the 6 column table

Figure 113: Format Table Columns

第 77 页 / 共 195 页

BPC320 Lesson: EVDRE Formatting

Figure 114: Format Table Columns: CRITERIA

Figure 115: Format Table Columns: EVALUATE IN

Figure 116: Format Table Columns: FORMAT

第 78 页 / 共 195 页

Unit2: Session2 BPC320

Figure 117: Format Table Columns: USE

Figure 118: Format Table Columns: PARAMETERS

第 79 页 / 共 195 页

BPC320 Lesson: EVDRE Formatting

Figure 119: Format Table Columns: APPLY TO

Figure 120: EVDRE Style Sheets

Figure 121: Formatting Tips

第 80 页 / 共 195 页

Unit2: Session2 BPC320

Lesson Summary

You should now be able to:

• utilize the EVDRE Format table.

第 81 页 / 共 195 页

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.

第 82 页 / 共 195 页

UnitSummary BPC320

第 83 页 / 共 195 页

第 84 页 / 共 195 页

第 85 页 / 共 195 页

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 thisunit, you will beableto:

• workwiththeBeforeRangeandAfterRangeoptionsinstandardandnested

EVDRE workbooks.

• UtilizebasicandadvancedsuppressioninEVDREworkbooks.

• understand howthe 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 ........................................................96

Lesson: EVDRE Drill Down and PageKey Functionality....................98

Lesson: EVDRE Indentation ..................................................101

第 86 页 / 共 195 页

Unit3: Session3 BPC320

Lesson: EVDRE Best Practices...............................................104

第 87 页 / 共 195 页

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

After completingthislesson, youwillbeable to:

• workwiththeBeforeRangeandAfterRangeoptionsinstandardandnested

EVDRE workbooks.

Business Example

Figure 122: Nested Dimensions

第 88 页 / 共 195 页

Unit3: Session3 BPC320

Figure 123: Nested Dimensions (continued)

Figure 124: BeforeRange & AfterRange

第 89 页 / 共 195 页

BPC320 Lesson: Before and AfterRange Options

Figure 125: Before Range Example

Figure 126: After Range Example

第 90 页 / 共 195 页

Unit3: Session3 BPC320

Figure 127: The EVRNG Function

第 91 页 / 共 195 页

BPC320 Lesson: Before and AfterRange Options

Lesson Summary

You should now be able to:

• workwiththeBeforeRangeandAfterRangeoptionsinstandardandnested

EVDRE workbooks.

第 92 页 / 共 195 页

Unit3: Session3 BPC320

Lesson: EVDRE Suppression

Lesson Overview

Lesson Objectives

After completingthislesson, you will beable to:

• UtilizebasicandadvancedsuppressioninEVDREworkbooks.

Business Example

Figure 128: Suppress

Figure 129: Suppress (Continued)

第 93 页 / 共 195 页

BPC320 Lesson: EVDRE Suppression

Figure 130: EVDRESuppression: Asymmetric Example

Figure131: EVDRESuppression: AsymmetricExample(continued)

第 94 页 / 共 195 页

Unit3: Session3 BPC320

Figure132: EVDRESuppression: AsymmetricExample(continued)

第 95 页 / 共 195 页

BPC320 Lesson: EVDRE Suppression

Lesson Summary

You should now be able to:

• UtilizebasicandadvancedsuppressioninEVDREworkbooks.

Related Information

•

第 96 页 / 共 195 页

Unit3: Session3 BPC320

Lesson: Multiple Key Ranges and EVDREs

Lesson Overview

Lesson Objectives

After completingthislesson, you will beable to:

• understand howthe same EvDRE function call can support multiplekey

rangesonbothcolumnsandrowssimultaneously,aswellashowtoretrieve

datafrommultipleapplicationsbyusingtwoEVDREfunctionsinthesame

report.

Business Example

Figure 133: The EVDRE Function

第 97 页 / 共 195 页

BPC320 Lesson: Multiple Key Ranges and EVDREs

Figure 134: Multiple Key Ranges

Figure135: RetrievingDatafromMultipleApplicationswithEVDRE

第 98 页 / 共 195 页

Unit3: Session3 BPC320

Figure 136: Multiple EVDRE Functions

第 99 页 / 共 195 页

BPC320 Lesson: Multiple Key Ranges and EVDREs

Lesson Summary

You should now be able to:

• understand howthe same EvDRE function call can support multiple key

rangesonbothcolumnsandrowssimultaneously,aswellashowtoretrieve

datafrommultipleapplicationsbyusingtwoEVDREfunctionsinthesame

report.

第 100 页 / 共 195 页

Unit3: Session3 BPC320

Lesson: 3D Expansions

Lesson Overview

Lesson Objectives

After completingthislesson, you will beable to:

• define a 3D expansion by using the EVDRE Builder, which sets the

ExpandInparametertoSHEETfortheselecteddimension.

Business Example

Figure 137: 3DExpansions: Spread across worksheets

Figure 138: Spread across worksheets (continued)

第 101 页 / 共 195 页

BPC320 Lesson: 3D Expansions

Lesson Summary

You should now be able to:

• define a 3D expansion by using the EVDRE Builder, which sets the

ExpandInparametertoSHEETfortheselecteddimension.

第 102 页 / 共 195 页

Unit3: Session3 BPC320

Lesson: EVDRE Sorting

Lesson Overview

Lesson Objectives

After completingthislesson, you will beable to:

• utilize the EVDRE Sort table.

Business Example

Figure 139: Sort Table

Figure 140: Sort Table (continued)

第 103 页 / 共 195 页

BPC320 Lesson: EVDRE Sorting

Lesson Summary

You should now be able to:

• utilize the EVDRE Sort table.

第 104 页 / 共 195 页

Unit3: Session3 BPC320

Lesson: EVDRE Drill Down and PageKey Functionality

Lesson Overview

Lesson Objectives

After completingthislesson, you will beable to:

• utilizeEVDREdrilldownfunctionality,aswellasdefinecomma-delimited

membersaspagekeystoaggregatemembersonthefly.

Business Example

Figure 141: EVDRE Drill Down Behavior

第 105 页 / 共 195 页

BPC320 Lesson: EVDRE Drill Down and PageKey Functionality

Figure 142: PageKey Range: Comma-delimited Members

第 106 页 / 共 195 页

Unit3: Session3 BPC320

Lesson Summary

You should now be able to:

• utilizeEVDREdrilldownfunctionality,aswellasdefinecomma-delimited

membersaspagekeystoaggregatemembersonthefly.

100

第 107 页 / 共 195 页

BPC320 Lesson: EVDRE Indentation

Lesson: EVDRE Indentation

Lesson Overview

Lesson Objectives

After completingthislesson, youwillbeable to:

• utilizeBPCandExcelfunctionstoindenttherowheadingsinanEVDRE

reportbaseduponthehierarchicalstructureofthedimension.

Business Example

Figure 143: Adding Indentation to EVDRE Reports

101

第 108 页 / 共 195 页

Unit3: Session3 BPC320

Figure 144: Adding Indentation: REPT & EVDES

102

第 109 页 / 共 195 页

BPC320 Lesson: EVDRE Indentation

Lesson Summary

You should now be able to:

• utilizeBPCandExcelfunctionstoindenttherowheadingsinanEVDRE

reportbaseduponthehierarchicalstructureofthedimension.

103

第 110 页 / 共 195 页

Unit3: Session3 BPC320

Lesson: EVDRE Best Practices

Lesson Overview

Lesson Objectives

After completingthislesson, you will beable to:

• understandbestpracticeswithregardtoEVDREworkbooks.

Business Example

Figure 145: EVDRE Best Practices

Figure 146: EVDRE Best Practices (continued)

104

第 111 页 / 共 195 页

BPC320 Lesson: EVDRE Best Practices

Figure 147: EVDRE Best Practices (continued)

Figure 148: EVDRE Best Practices (continued)

Figure 149: EVDRE Best Practices (continued)

105

第 112 页 / 共 195 页

Unit3: Session3 BPC320

Figure 150: EVDRE Best Practices (continued)

106

第 113 页 / 共 195 页

BPC320 Lesson: EVDRE Best Practices

Lesson Summary

You should now be able to:

• understandbestpracticeswithregardtoEVDREworkbooks.

107

第 114 页 / 共 195 页

UnitSummary BPC320

Unit Summary

You should now be able to:

• workwiththeBeforeRangeandAfterRangeoptionsinstandardandnested

EVDRE workbooks.

• UtilizebasicandadvancedsuppressioninEVDREworkbooks.

• understand howthe same EvDRE function call can support multiplekey

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.

108

第 115 页 / 共 195 页

第 116 页 / 共 195 页

第 117 页 / 共 195 页

Unit 4

Session 4

Unit Overview

Aftercompletingthisunityouwillunderstandbudgetingsystembestpractices;

knowhowto utilizethe Data Manager, transformation, andconversionfilesto

seed next year’s budget; add an MDX calculation to a script logic file; create

budgetinginputscheduleswithEVDRE;andcreateabudgetingBPF.

Unit Objectives

After completing thisunit, you will beableto:

• understandbudgetingsystembestpracticesandknowhowtoutilizetheData

Manager,transformation,andconversionfilestoseednextyear’sbudget.

• addanMDXcalculationtoyourDefault.lgfscriptlogicfile.

• define and createbudgeting input schedules.

• understand viewable dataconsiderationswhencreating an EVSND or an

EVDRE input schedule.

• createandtestabudgetingBPF,aswellasreportonBPFs.

• create top down modeling that allows you to plan on a non-base level

member.

Unit Contents

Lesson: Budgeting Overview..................................................114

Lesson: MDX Calculation......................................................121

Lesson: Budgeting Input Schedules..........................................125

Lesson: Viewable Data.........................................................127

Lesson: Budgeting and BPFs.................................................130

Lesson: Top Down Modeling..................................................138

113

第 118 页 / 共 195 页

Unit4: Session4 BPC320

Lesson: Budgeting Overview

Lesson Overview

Lesson Objectives

After completingthislesson, you will beable to:

• understandbudgetingsystembestpracticesandknowhowtoutilizetheData

Manager,transformation,andconversionfilestoseednextyear’sbudget.

Business Example

Figure 151: Budget Approach Considerations

114

第 119 页 / 共 195 页

BPC320 Lesson: Budgeting Overview

Figure 152: Best Practice: Multiple iterations

Figure 153: Modeling Requirements

115

第 120 页 / 共 195 页

Unit4: Session4 BPC320

Figure 154: Level of Detail Options

Figure 155: Modeling Requirements

Figure 156: Budgeting Tips

Figure 157: Seeding Options

116

第 121 页 / 共 195 页

BPC320 Lesson: Budgeting Overview

Figure 158: Transformation Files

Figure 159: Transformation Files: *OPTIONS

117

第 122 页 / 共 195 页

Unit4: Session4 BPC320

Figure 160: Transformation Files: *MAPPING

Figure 161: Transformation Files: *CONVERSION

Figure 162: Conversion Files

118

第 123 页 / 共 195 页

BPC320 Lesson: Budgeting Overview

Figure 163: Conversion Files: Imports and Exports

119

第 124 页 / 共 195 页

Unit4: Session4 BPC320

Lesson Summary

You should now be able to:

• understandbudgetingsystembestpracticesandknowhowtoutilizetheData

Manager,transformation,andconversionfilestoseednextyear’sbudget.

120

第 125 页 / 共 195 页

BPC320 Lesson: MDX Calculation

Lesson: MDX Calculation

Lesson Overview

Lesson Objectives

After completingthislesson, youwillbeable to:

• addanMDXcalculationtoyourDefault.lgfscriptlogicfile.

Business Example

Figure 164: Budget Method

Figure 165: Logic Types

121

第 126 页 / 共 195 页

Unit4: Session4 BPC320

Figure 166: Dimension Logic Considerations

Figure 167: Dimension Logic Example

Figure 168: Script Logic Considerations

Figure 169: Script Logic Example

122

第 127 页 / 共 195 页

BPC320 Lesson: MDX Calculation

Figure 170: MDX Considerations

123

第 128 页 / 共 195 页

Unit4: Session4 BPC320

Lesson Summary

You should now be able to:

• addanMDXcalculationtoyourDefault.lgfscriptlogicfile.

124

第 129 页 / 共 195 页

BPC320 Lesson: Budgeting Input Schedules

Lesson: Budgeting Input Schedules

Lesson Overview

Lesson Objectives

After completingthislesson, youwillbeable to:

• define and createbudgeting input schedules.

Business Example

Figure 171: Budgeting Input Schedules

Figure 172: Built-in modeling functions

125

第 130 页 / 共 195 页

Unit4: Session4 BPC320

Lesson Summary

You should now be able to:

• define and createbudgeting input schedules.

126