BPC311_EN_Col91_FV_Part_A4 (第4页)

第 187 页 / 共 237 页

BPC310 Lesson: Business Process Flows

Figure 210: Enable Completion Criteria

Enable completion criteria:

• maybeenabledifWorkStatushasbeenenabledinthecontrollingapplication

of the BPF.

If defined here, the selected combinationsof membersmust beset to the

specifiedworkstatusbeforethestepcanbeconsideredcomplete.

The dimensionvalues maybeinherited fromthedataregion meansthedata

region can bedeterminedwhentheBPFisexecuted.

Memberlookup meansthatthedimension member isprovidedasadefaultin

the BPF.

Dimensionsmembersmay also be inherited fromthecurrentview whenthe

BPF is executed.

173

第 188 页 / 共 237 页

Unit4: AdministrationinBPC BPC310

Figure 211: Define Actions

The first action is defaulted in by the system and cannot be deleted if it is the

only one.

Thedataregioncanbefilledinbelowthetaskandthereforenotrequiretheuserto

changetheircurrentview. Itsawaytoprovideusefuldefaultmembervalues.

Intheimportfileaction,aspecificpackageandfilecanbefullyspecifiedinthe

BPF.

Figure 212: Finish

174

第 189 页 / 共 237 页

BPC310 Lesson: Business Process Flows

ToenabletheBPFforimmediateuse,selecttheEnablethisBPFforusersboxin

the lower left

corner of the screen.

DeselectthecheckboxifyoudonotwanttheBPFtobeavailableatthepresent

time.

YoucandeleteaBusinessProcessFlow(BPF)whenyouwanttoremoveitfrom

the application set entirely.

Note: Asan alternativetodeleting, you can disableaBPF.Adisabled

BPFdoesnotappearinanyenduseractionpanesbutdoesremainonthe

administrator'slist. Itremainsavailabletocopyandmodifyinthefuture.

Figure 213: Tips on BPFs

YoucangeneratetwodifferenttypesofBPFreports: astandardBPFreportanda

BPF step report.

Bothreportsallowyoutospecifythebusinessprocessflow,timeframe,associated

data region, and page orientation.

ThestandardBPFreportliststhestepsandsub-stepsintherightcolumn,and

thestatusofeachstep or sub-stepintheleft column.

TheBPFstepreportliststheentitiesforwhichthereportisrunintherows,and

thestatusof each stepandsub-step inthe columns.

FromtheAdminConsole,youcanprepareastandard-typereportonly.

To prepare a standard BPF report from the Admin Console, expand Business

ProcessFlows,selecttheBPFforwhichyouwanttoreporton,andselectBPF

status report.

175

第 190 页 / 共 237 页

Unit4: AdministrationinBPC BPC310

Figure 214: BPF, Work Status, Security Integration

BPFs,WorkStatus,andSecuritycantbebuiltinavacuum. Thedeveloperneeds

to know about all three.

Forexample,ifanactionisputintoaBPF,thentheuserwillneedtohaverightsto

perform that task in security.

176

第 191 页 / 共 237 页

BPC310 Lesson: Business Process Flows

Lesson Summary

You should now be able to:

• Createa businessprocessflow which will facilitate thecoordination and

statuscheckingaspectsofperformingplanningorconsolidationsactivities.

177

第 192 页 / 共 237 页

Unit4: AdministrationinBPC BPC310

Lesson: Audit

Lesson Overview

Lesson Objectives

After completingthislesson, you will beable to:

• Describethedifferenttypesofauditcapabilitiesandthedatayoucancapture

to help provide adequate control.

Business Example

Figure 215: Audit Function

178

第 193 页 / 共 237 页

BPC310 Lesson: Audit

Audit is broken up into 2 categories:

• 1.Activity Audit:

Captures“metadata”changes,suchasAdd,Create,Change,andDelete

– AppSets

– Applications

– Dimensions.

ActivityauditiscapturedattheAppSetlevel.

• 2.Data Audit:

Captures“transactional”datachanges–i.e. captureinformationonchanges

torecordsinanApplication. DataauditiscapturedattheApplicationlevel.

Figure 216: Audit Setup

Activityauditingallowsyou totracktheadministrativetasks performedinthe

system.

Onceactivityisrecorded,youcanrunareportthatshowssystemactivity,based

on specified criteria.

Thereportshowswhenthetaskwasperformed,andbywhom. Ifenabled,BPC

tracksactivityfor thefollowing functional tasks:

• Application set and application setup

• User and team setup

179

第 194 页 / 共 237 页

Unit4: AdministrationinBPC BPC310

Member access and task profile setup:

• Business Process Flow management; Adding, deleting, and modifying

business process flows; Saving business process flows to new names;

Dataauditmaintenanceandactivationof dataaudits; Document typeand

documentsub-typesetup; Activationofactivityaudit.

• To enable activity auditing

1. Start BPC Administration, and from the Administration Configuration

actionpane, selectManage activity auditing.

2. SelectEnable Admin Activity to record all administrative activity, and

selectEnableuseractivitytorecordallenduseractivity.

3. Click Update.

Figure 217: Activate Activity Audit

The settingsfor Activity Audit are verysimple:

• Log activity for “Admin” tasks (or not)

• Log activity for “User” tasks (or not)

180

第 195 页 / 共 237 页

BPC310 Lesson: Audit

“Admin Activity” includes:

• Add/Modify/Delete/Copy operations for AppSets, Applications, and

Dimensions (including Process Dimension)

• SecurityChanges(add/change/deleteusers,teams,andtask/memberprofiles)

• Web Admin Changes (AppSet/Application parameters; Document

Types/Subtypes;andChangingActivityorDataAuditsettings)

• Validation rules changes

“User Activity” includes:

• Set Work Status locks

Figure 218: Audit Setup

The settings above can be determined by running the report without any

restrictions tosee the systemgenerated results.

Forexample,whenaTaskProfileischanged,theFunctionTaskisModifyTask

Profile,thesourceisthetaskprofilebeingchanged,noparameterappliesinthis

case. Whenadimensionisprocessed,thefunctiontaskisProcessDimension,the

Sourceisthedimensionitself,theparameterisIncrementalProcess.

181

第 196 页 / 共 237 页

Unit4: AdministrationinBPC BPC310

Figure 219: Audit Setup

Therearequiteafewformatssupportedforexportingthereport. Forexample,the

TIFFoptionexportsthedatatoMicrosoftOfficeDocumentImaging.

Figure 220: Data Audit

You can set up data auditing to record an audit trail of BPC activity. You can

set it up by application and category.

182

第 197 页 / 共 237 页

BPC310 Lesson: Audit

To manage audit data

1. Start BPC Administration, and select Manage data audit from the

Administration Configuration action pane.

2. FromtheSelectApplicationfield,selecttheapplicationforwhichyouwant

to set properties.

3. SelectEnableDataActivitytoturnonauditingfortheselectedapplication.

ClicktheViewAuditSettingsforAllCategorieslinkfromtheactionpane

to see a report that shows which categories and tasksare enabled for the

selected application.

4. Selectacategory,thenselectoneormoretaskstoaudit. SelecttheSelectAll

buttontoselect allofthetaskcheckboxes, orselecttheClearAllbutton

toclearallcheckboxes. Youcanselectfromthefollowingtasks: BPCfor

Excel, DataManagerImport,DataManagerClear,LogicExecution,Live

Report, Journals.

Figure 221: Audit Setup

5. Under the Set Log Limits section, do one of the following: If you want to

keep all audit data for the selected category in the database, leave the default

selected, Never purge audit data. If you want to purge audit records for the

selectedcategoryafteraspecifiednumberofdays,selectSetpurgefrequence,

andenterthenumberofdaysforwhichtokeepauditrecordsinthedatabase. In

addition,youmustruntheDTSPurgepackagetoclearthedatabaseforeverything

beyond the specified number of days.

6. Under the Schedule Synchronization section, set up a synchronization

schedulebyselectingEnableschedule,andenteringthedesiredtimefrequency.

Bydefault,auditrecordsaresynchronizedevery12hours,ifenabled. IntheSAP

BusinessPlanningandConsolidation5.xDataAuditsettings,thereisanoption

to “schedule synchronization”. This is because BPC stores audit records in a

temporary table first.

183

第 198 页 / 共 237 页

Unit4: AdministrationinBPC BPC310

7. ClicktheSaveAuditDataNowlinktorunthesynchronizationprocessright

away.

8. ClickthePublishauditreportlinktosendadataauditreporttotheSystem

Reports page.

9. Click Update to save your changes.

Figure 222: Audit Setup

• The Audit Settings show which categories and tasks are active for the

application.

184

第 199 页 / 共 237 页

BPC310 Lesson: Audit

Figure 223: Creating an Audit Data Report

• TheupperscreenshotshowswithwhichparametersyoucanopentheAudit

DataReportandhowyoucanconfigurethereport.

Figure 224: The Audit Data Report

• Theauditreportcansetwhichdimensiontogrouptherowsby,youcanalso

set3dimensionsortaskstoappearonthecolumns,andyoucanset2report

currentviewdimensionsortasksandusethemforfiltering.

185

第 200 页 / 共 237 页

Unit4: AdministrationinBPC BPC310

Lesson Summary

You should now be able to:

• Describethedifferenttypesofauditcapabilitiesandthedatayoucancapture

to help provide adequate control.

186

第 201 页 / 共 237 页

BPC310 Unit Summary

Unit Summary

You should now be able to:

• Understand the four components of the security model and how they are

integrated.

• DescribeatypicalcustomerscenarioforWorkStatus.

• Describe how to set Work Status.

• Createa businessprocessflow which will facilitate thecoordination and

statuscheckingaspectsofperformingplanningorconsolidationsactivities.

• Describethedifferenttypesofauditcapabilitiesandthedatayoucancapture

to help provide adequate control.

187

第 202 页 / 共 237 页

UnitSummary BPC310

188

第 203 页 / 共 237 页

BPC310 Test Your Knowledge

Test Your Knowledge

1.

2.

3.

4.

189

第 204 页 / 共 237 页

TestYourKnowledge BPC310

Answers

1.

Answer:

2.

Answer:

3.

Answer:

4.

Answer:

190

第 205 页 / 共 237 页

第 206 页 / 共 237 页

第 207 页 / 共 237 页

Unit 5

Miscellaneous

Unit Overview

Unit Objectives

After completing thisunit, you will beableto:

• Explainthedeltasfrom5.1Mto7.0MusingtheDeliveredReferenceGuide.

• Understand which newfeatures areplanned after 7.0M for the Microsoft

Platform.

• See the differencesbetween 7.0M and 7.0NW and how the NW solution

will develop in future.

Unit Contents

Lesson: Miscellaneous.........................................................192

191

第 208 页 / 共 237 页

Unit5: Miscellaneous BPC310

Lesson: Miscellaneous

Lesson Overview

Lesson Objectives

After completingthislesson, you will beable to:

• Explainthedeltasfrom5.1Mto7.0MusingtheDeliveredReferenceGuide.

• Understand which newfeaturesareplanned after 7.0M for theMicrosoft

Platform.

• Seethe differencesbetween 7.0M and 7.0NW and howthe NW solution

will develop in future.

Business Example

Figure225: Whatsnewfrom5.1Mto7.0M-QuickReference(1of2)

SAPBusinessPlanningandConsolidation7.0deliversannew,optimizedshared

queryengine(SQE)thatdeliversfasterqueryperformanceandgreaterscalability

whileusinglessmemory. Youspendlesstimewaitingfordata.

ThenewManagementConsoleinSAPBusinessallowsadministratorstoview

andmanagelogsandmonitorsystemperformance,processes,useractivityandthe

sharedqueryengine,allinoneinterfacethusimprovingefficiency.

192

第 209 页 / 共 237 页

BPC310 Lesson: Miscellaneous

SAPBusinessPlanningandConsolidation7.0deliversmoreflexibilityandoptions

forcreatingreports. ItsupportsmultiplehierarchiesontheTimedimension.

Youcannowhavemultiplehierarchiesonatimedimensionandaddanewtime

level (HALFYEAR). You canimplementCalendarandFiscaltimedimensions

easily and add more hierarchies.

Having hierarchiesin theTime dimension allowsyou to definehowyou want

time periods to aggregate.

SAP Business Planning and Consolidation 7.0 delivers updated SQL 2005

compatibilitymode(updateTSQLtoANSIstandardSQL).

TSQLhasbeenupdatedtoANSIstandardSQLtosupporthighercompatibility

modewithinSQLServer 2005. Nowallmulti-dimensionaldataaccessisdone

through the SQE.

193

第 210 页 / 共 237 页

Unit5: Miscellaneous BPC310

Figure226: Whatsnewfrom5.1Mto7.0M-QuickReference(2of2)

• Support for Microsoft Vista and Office2007* means you dont haveto

support multiple Microsoft operating systems and Office environments.

Vista support is for 32-bit only.

• SupportforMicrosoftSQLServer2000andExcel2000isdropped.

• Seasonality is acharacteristic of a time series in which data experiences

regular and predictable changes which recur every calendar year. Any

predictablechangeorpatterninatimeseriesthat recursorrepeatsover a

one-year period canbe saidto be seasonal.

For example, sales of childrens toys typically increase every December.

Seasonalitymakesithardforbusinessanalyststointerprettheunderlying

trendinsomedataseries. Forexample,weretoysalesbetterthisDecember

orwasitjusttheusualholidayspike? Businessanalystswanttoknowifsales

werebetter(orworse)thanthenormalseasonalincrease. Tounderstandwhat

dataisreallysaying,analystsneedtoremovesuchpredictablefluctuationsor

seasonalityfromdata. EmbeddedseasonalitycapabilitiesinSAPBusiness

Planning and Consolidation increase the accuracy of predictive analytic

capabilitiesbyremovingtheseasonalcomponentofdata.

• With the first pass of the seasonality algorithms analysis we “seasonally

adjust”allofKPIsandaccountdataatthetoplevels. Thiswouldbedoneby

calculatingatimetrendfortheaccount,creatingseasonalbuckets,averaging

thevaluesineachbucket,thencreatingthe“seasonallyadjusted”datawhich

istheactualdatawiththeseasonalcomponentsubtractedfromit. Insight

wouldusetheseasonallyadjusteddataforthecorrelationanalysisandthe

calculation of slope and intercept.

• Enhanced Business Process Flows support multiple reviewers/teams

of reviewers and auto email notification to reviewer(s) when steps are

completedwhichreducesbottlenecks/backlogandallowsyoutocomplete

and monitor your planning cycles faster.

194

第 211 页 / 共 237 页

BPC310 Lesson: Miscellaneous

Figure 227: Planned future Releases in BPC, Version of the Microsoft

Platform

Thekeythemeofthe7.5versionfortheMicrosoftplatformreleaseisintegration

with the Business Objects BI platform.

The plan for customers who utilize certain tools within the Business Objects

BI portfolio is to be able to leverage these with SAP Business Planning and

Consolidation data.

Business Process Flows will be enhanced and the application will support the

latestreleasesofSQLServerandWindowsServer(2008)–subjecttoavailability

from Microsoft.

• While version 8.0 is still beyond the horizon, the plan is to continue to

improvetheuserexperienceacrosstheEPMsuiteaswellasenhanceSAP

BusinessPlanningandConsolidationsconsolidationcapabilities.

195

第 212 页 / 共 237 页

Unit5: Miscellaneous BPC310

Figure228: Differences betweenBPC7.0M and BPC7.0NW

Bothofthe7.0versionshavesimilarcapabilitiesfromauserperspective:

-TheyleverageMicrosoftOfficeinterfaces(Excel,Word,PowerPoint)

-Havewebadministrationclients,live(web)reportingandmore

Keydifferencesincludethe7.0versionforSAPNetWeaversutilizationofSAP

NetWeavercomponentsandcapabilitiessuchasprocesschains,thechangeand

transportsystem,BIAccelerator,anddatabaseindependence.

Business Process Flows, Briefing Books, Drill-Through, Insight (embedded

predictive analytics) and other capabilities pertain only to the version for the

Microsoft platform at this point in time(7.0).

So, while the implementation and architecture of the two versions is different

thereismuchsimilarityfromafunctional perspective.

196

第 213 页 / 共 237 页

BPC310 Lesson: Miscellaneous

Figure229: FutureStrategyforMicrosoftandNetweaverSolution

Movingforward, both versionswilloverlaplessandlessfromanarchitectural

perspective.

TheversionfortheMicrosoftplatformwillcontinuetobeinvestedinasabestof

breed,unifiedplanningandconsolidationapplicationwhiletheversionforSAP

NetWeaverwillcontinuetobeoptimizedforcustomersinvestmentsintheSAP

NetWeaver platform and SAP applications.

197

第 214 页 / 共 237 页

Unit5: Miscellaneous BPC310

Lesson Summary

You should now be able to:

• Explainthedeltasfrom5.1Mto7.0MusingtheDeliveredReferenceGuide.

• Understand which newfeaturesareplanned after 7.0M for theMicrosoft

Platform.

• Seethe differencesbetween 7.0M and 7.0NW and howthe NW solution

will develop in future.

198

第 215 页 / 共 237 页

BPC310 Unit Summary

Unit Summary

You should now be able to:

• Explainthedeltasfrom5.1Mto7.0MusingtheDeliveredReferenceGuide.

• Understand which newfeatures areplanned after 7.0M for the Microsoft

Platform.

• See the differencesbetween 7.0M and 7.0NW and how the NW solution

will develop in future.

199

第 216 页 / 共 237 页

UnitSummary BPC310

200

第 217 页 / 共 237 页

BPC310 Test Your Knowledge

Test Your Knowledge

1.

201

第 218 页 / 共 237 页

TestYourKnowledge BPC310

Answers

1.

Answer:

202

第 219 页 / 共 237 页

第 220 页 / 共 237 页

第 221 页 / 共 237 页

Unit 6

Case Study – optional

Unit Overview

Unit Objectives

After completing thisunit, you will beableto:

• Better understand how to create an AppSet, update dimension date

dimensions, validate script logic, modify member access profiles, load

transaction data along with conversion and transformation files, publish

bookstowebpage,andconfiguredocumenttypes.

Unit Contents

Lesson: Case Study – optional ...............................................204

203

第 222 页 / 共 237 页

Unit6: CaseStudy–optional BPC310

Lesson: Case Study – optional

Lesson Overview

Lesson Objectives

After completingthislesson, you will beable to:

• Better understand how to create an AppSet, update dimension date

dimensions, validate script logic, modify member access profiles, load

transaction data along with conversion and transformation files, publish

bookstowebpage, andconfiguredocumenttypes.

Business Example

Figure230: SAPBusinessPlanningandConsolidationCaseStudy

PIP – Parts is Parts.

204

第 223 页 / 共 237 页

BPC310 Lesson: Case Study – optional

Figure 231: Key Financial Application Requirements

Figure 232: Key Financial Application Requirements

205

第 224 页 / 共 237 页

Unit6: CaseStudy–optional BPC310

Figure 233: Guidance Notes

Figure 234: Guidance Notes

Figure 235: Guidance Notes

206

第 225 页 / 共 237 页

BPC310 Lesson: Case Study – optional

Figure 236: Transformation & Conversion Files

Figure 237: Guidance Notes

207

第 226 页 / 共 237 页

Unit6: CaseStudy–optional BPC310

Figure 238: Guidance Notes

Figure 239: Guidance Notes

208

第 227 页 / 共 237 页

BPC310 Lesson: Case Study – optional

Figure 240: Guidance Notes

Figure 241: Guidance Notes

209

第 228 页 / 共 237 页

Unit6: CaseStudy–optional BPC310

Lesson Summary

You should now be able to:

• Better understand how to create an AppSet, update dimension date

dimensions, validate script logic, modify member access profiles, load

transaction data along with conversion and transformation files, publish

bookstowebpage, andconfiguredocumenttypes.

210

第 229 页 / 共 237 页

BPC310 Unit Summary

Unit Summary

You should now be able to:

• Better understand how to create an AppSet, update dimension date

dimensions, validate script logic, modify member access profiles, load

transaction data along with conversion and transformation files, publish

bookstowebpage,andconfiguredocumenttypes.

211

第 230 页 / 共 237 页

UnitSummary BPC310

212

第 231 页 / 共 237 页

BPC310 Test Your Knowledge

Test Your Knowledge

1.

213

第 232 页 / 共 237 页

TestYourKnowledge BPC310

Answers

1.

Answer:

214

第 233 页 / 共 237 页

第 234 页 / 共 237 页

第 235 页 / 共 237 页

BPC310 Course Summary

Course Summary

You should now be able to:

• [Enter a course objective.]

• [Enter acourseobjectiveor deleteifnotused.]

215

第 236 页 / 共 237 页

CourseSummary BPC310

216

第 237 页 / 共 237 页

Feedback

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

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

suggestionsforimprovement,pleaserecordthemintheappropriateplaceinthe

course evaluation.

217