BPC310_EN_Col91_FV_Part_A4 (第1页)

第 1 页 / 共 473 页

BPC310

SAP BusinessObjects Planning

and Consolidation: Application

Configuration

SAP CPM

Date

Training Center

Instructors

Education Website

Participant Handbook

Course Version: 91

Course Duration: 5 Days

Material Number: 50095516

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

第 2 页 / 共 473 页

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.

g200910113165

第 3 页 / 共 473 页

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

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 页 / 共 473 页

AboutThisHandbook BPC310

Icons in Body Text

Thefollowingiconsareusedinthishandbook.

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 页 / 共 473 页

Contents

Course Overview......................................................... vii

Course Goals...........................................................vii

Course Objectives .....................................................vii

Unit 1: Creating Application Sets, Dimensions and Properties.1

Getting Started & Terminology ........................................2

Dimensions, Properties & Hierarchies .............................18

Unit 2: Creating Applications, Introduction to Logic and

Loading of Transaction Data .......................................... 33

Creating Applications.................................................34

Introduction to Logic..................................................46

Loading of Transaction Data ........................................61

Unit 3: Working with BPC for Excel, BPC Web, BPC for Word

and BPC for PowerPoint................................................ 77

BPC for Excel..........................................................78

BPC Web..............................................................122

BPC for Word and BPC for PowerPoint...........................134

Unit 4: Administration in BPC .......................................141

Security................................................................142

Work Status...........................................................154

Business Process Flows............................................163

Audit...................................................................176

Unit 5: Miscellaneous..................................................187

Miscellaneous........................................................188

Unit 6: Case Study – optional........................................197

Case Study – optional...............................................198

Unit 7: Labs ..............................................................207

Labs....................................................................208

第 6 页 / 共 473 页

Contents BPC310

第 7 页 / 共 473 页

Course Overview

Target Audience

Thiscourseisintendedforthefollowingaudiences:

• WhoisresponsibleforapplicationdevelopmentandadministrationofSAP

Business Planning and Consolidation.

• AllthosewhowanttogetfamiliarwithBPC.

Course Prerequisites

Required Knowledge

• Good knowledge in Microsoft Office.

Recommended Knowledge

• Understandingofbasicfinancialaccountingprinciples.

Course Goals

This course will prepare you to:

•

Course Objectives

Aftercompletingthiscourse, youwillbeableto:

•

vii

第 8 页 / 共 473 页

CourseOverview BPC310

viii

第 9 页 / 共 473 页

Unit 1

Creating Application Sets, Dimensions

and Properties

Unit Overview

Unit Objectives

After completing this unit, you will be able to:

• understand the advantages of BPC, the terminology and how to maintain

Application Sets.

• UnderstandhowtomaintainDimensions,propertiesandhierarchies

Unit Contents

Lesson: Getting Started & Terminology.........................................2

Lesson: Dimensions, Properties & Hierarchies..............................18

第 10 页 / 共 473 页

Unit1: CreatingApplicationSets,DimensionsandProperties BPC310

Lesson: Getting Started & Terminology

Lesson Overview

Lesson Objectives

Aftercompletingthislesson, youwillbeableto:

• understand the advantages of BPC, the terminology and how to maintain

Application Sets.

Business Example

Figure 1: What does BPC have to offer?

Familiaruserexperience–PatentedMicrosoftOfficeToolintegrationand100%

thinclient,Web2.0interfacereduceramp-uptimeandincreaseuseracceptance.

YoucanleverageExcel,PowerPointpresentations,Worddocuments,andAdobe

PDFreportstoaccesscentrallylocatedplans,budgets,andforecastsandimprove

organizational alignment.

Self-servicebusinessprocessflows–Pre-packagedprocessflowsforcommon

business processes, aligned to structured and unstructured data and easily

modifiableviaself-service,enableallstakeholderstoparticipateinthevaluechain

and follow the agreed upon process.

Intelligentactionpanes–Actionpaneswithdiscussionthreadsandunstructured

dataimproveproductivitybyhelpingyourusersunderstandwhatactionstotake,

whenandhowtoact,andwhytheactionsarenecessary.

第 11 页 / 共 473 页

BPC310 Lesson: Getting Started & Terminology

Top-downandbottom-upplanning–Theapplicationprovidesacentralizedforum

forcommunicatingorganizationalfinancialgoalsandobjectives,alongwithtools

for data collection and collaboration.

Multidimensional modeling – Modeling functionality includes “what-if” and

scenarioanalysisthatenablesyouruserstomeasureandassessfutureoutcomes.

Collaborativeforecasting–Theapplicationenablesbi-directional(horizontaland

vertical)communicationandmanagesinteractionbetweenplanstakeholders.

Workflowmanagement–Workflowmanagementfeaturesallowversioningthat

helpstrackplanstatusandprovidesstakeholderswithimmediateaccesstothe

plan.

Financialmanagement–Theapplicationenablesyoutoshavedaysandweeks

off closing books with functionality for currency conversions, inter-company

eliminations, multi-tier allocations, and journal entries, along with access to

predefinedbusinessprocessflowtemplatesthatensureafast,accurateclose. Plus,

youcanproducereportssuchasP&L,balancesheets,cashflow,andfixedassets,

soyoucangetacomprehensiveviewofyourfinanciallandscape.

Compliancemanagement–SAPBusinessPlanningandConsolidationincludes

functionalityforSarbanes-Oxleycomplianceandstandardscompliance,including

IAS, IFRS, FASB, and GAAP. Plus, the application can integrate with SAP

solutions for governance, risk, and compliance to reduce the risk of fraud and

errorsandcreateafully-documentedaudittrail.

Figure2: BusinessProcessFlows–BudgetingExample

OneofthebiggestadvantagesofBPCistheBusinessProcessFlow(BPF).The

graphicaboveshowsatypicalexampleofaBPF.

第 12 页 / 共 473 页

Unit1: CreatingApplicationSets,DimensionsandProperties BPC310

BPFsareusedtoprovideagraphicalviewofthestepsintheprocessaswellasto

providestructure,integrationandreviewingcapability.

Whenstepsarelockedtheycannotberepeatedwithoutre-startingthebusiness

process flow.

Figure 3: SAP Business Planning and Consolidation 7.0, version for the

Microsoft platform

SAP Business Planning and Consolidation 7.0 is the only unified planning,

budgetingandconsolidationapplicationthatisdesignedtobeownedandmanaged

by Finance:

• Faster

• Increased accuracy

• More flexibility

FurthermoreitisdesignedtointegratewithyourexistingITlandscape. Itdelivers

increased performance and scalability, greater accuracy, and a lower cost of

ownership.

TechnicallyspeakingBPCisOLAP-based(On-LineAnalyticalProcessing)and

thusspecificallydevelopedforviewingandanalyzingdata.

Formoretechnicaldetailsincludingtheinstallationseetheinstallationguide7.0:

https://service.sap.com/instguidescpm-bpc. Select7.0VersionfortheMicrosoft

Platform.

第 13 页 / 共 473 页

BPC310 Lesson: Getting Started & Terminology

Figure 4: Server Technology Stack

ThegraphicshowsthatBPChasaservice-orientedlandscapeandwherewhich

information is stored.

Figure5: SingleServerConfigurationorMultiServerConfiguration

When the required server components are located on different servers, this is

considered a multiserver Configuration.

Werecommenda4-serverenvironment, withaWebserver, Applicationserver

(Application/FileShare/Reporting Services), a SQL DB server, and an OLAP

DB server.

Thedifferentservertypescanbeinstalledonupto7differentmachines.

第 14 页 / 共 473 页

Unit1: CreatingApplicationSets,DimensionsandProperties BPC310

Formoreinformationaboutsettingupyourmultiserverenvironment,including

scalabilityguidelinesanddetailedinformationon32/64bitsupport,seetheSAP

BPCMasterGuideinhttp://service.sap.com/instguidescpm-bpc7.0,versionfor

the Microsoft Platform.

Figure 6: Terminology: Application Sets

You begin by copying an existing application set, and then you customize the

applicationsetbycreatingnewapplications,dimensions,andmembers.

ApShell is the delivered application set used as a starting point for client

implementations.

NoobjectswithinanAppSetaresharedwithotherAppSets.

Figure7: Terminology: Dimensions(MasterData)

If there is no hierarchy in the dimension, the dimension is considered to be a

“Flat” dimension.

Ifahierarchyexists,thedimensionisconsideredtobea“Hierarchical”dimension.

第 15 页 / 共 473 页

BPC310 Lesson: Getting Started & Terminology

Figure 8: Terminology: Properties

Inthisexample,theaccountDimensionhasamemberExtSaleswiththeproperty

values:

• Description = External Sales

• Group = Profit & Loss

• Scaling = Y

• AccType = Inc

Figure 9: Terminology: Measures

Measures–timerelatedviewsoftransactiondatasuchasPeriod,Quartertodata,

and Year to date.

第 16 页 / 共 473 页

Unit1: CreatingApplicationSets,DimensionsandProperties BPC310

ApShellmeasuresare: Periodic,QuarterToData,andYearToDate.

The accounts above are cumulative in nature since you can add up operating

income over time.

Figure 10: Terminology: Applications (Cubes)

Thelimitof20dimensionsisnotahardlimitbutratherapracticalone. More

than20dimensionsareallowedbutonlywithsignificantperformancehitswhich

always depend on the situation.

Note: Thescreenshotaboveisintendedtoshowthedatacapturedfor

an application.

Figure 11: Terminology: Applications

Thisslideliststhedimensiontypesthatarerequiredineveryreportingapplication

andthedimensiontypethatisrequiredineachapplicationset.

第 17 页 / 共 473 页

BPC310 Lesson: Getting Started & Terminology

Figure 12: Terminology: Transaction Data

Notethateverydimensioninthecubehasadimensionmemberpostedinevery

record and each one is a base level member. Base level members don't have

children.

Figure 13: ApShell

ApShellcomeswithsamplemasterandtransactiondataandisessentiallyreadyto

run.

ApShellcomeswithaBPF,aTeam,Profiles,WorkStatus,Reports,logic,etc.

ApShellcomeswith5ofthe6applicationtypes(withoutGeneric/non-reporting).

第 18 页 / 共 473 页

Unit1: CreatingApplicationSets,DimensionsandProperties BPC310

Administrator Roles

• TherearedifferenttypesofadministratorsinSAPBusinessPlanningand

Consolidation,withdifferenttaskprofilesandthereforeaccesstodifferent

tasks.

• YouneedtheappropriateadministratortasktobeabletologintotheAdmin

console,andthereforeaccessApplicationAdministrationetc.

• This provides access to all operations such as add/change/copy/delete

applications.

• This task is given at the AppSet level – so you have admin rights for all

applications or none.

• Anadministratormayhaveoneormoreofthese“defaultfunctiontasks”:

– System Admin

– Primary Admin

– Secondary Admin

BPCdoesnothaveanobjectcalledarolethatyoumightbefamiliarwithinBI

or ECC.

Assignment of tasks to users will be required in order to perform application

administration.

Specificallyforapplicationmanagement,thereisonlyonetaskinthetaskprofiles

which is; “Application”.

Basically, this task provides access to all operations regarding managing

applications(Add,Modify,CopyandDeleteapplications).

Figure 14: BPC Administration

第 19 页 / 共 473 页

BPC310 Lesson: Getting Started & Terminology

SAP Business Planning and Consolidation (BPC) Administration lets you

build and maintain BPC applications.

With BPC Administration, you can:

• Create new application sets

• Createandmaintainapplicationsanddimensions

• Create and maintain formulas and logic

• Create and maintain users and security

• Create and maintain business process flows

• Create and maintain business rules.

Figure 15: BPC Login

TheConnectionWizardisanimportanttooltologtodifferentapplicationsets

and to set the default set.

ThefollowingslidegivesmoredetailstotheConnectionWizard.

第 20 页 / 共 473 页

Unit1: CreatingApplicationSets,DimensionsandProperties BPC310

Figure 16: The Connection Wizard

TheConnectionWizardguidestheuserthroughtheprocessofconnectingtothe

BPC server as described in the graphic.

Figure 17: The Admin Console

Usethetreeonthelefttoselectwhichcomponentstodisplayormaintain.

Themiddleareadisplaysthesettingsandmetadataforthecomponentyouhave

selected in the tree.

第 21 页 / 共 473 页

BPC310 Lesson: Getting Started & Terminology

The action pane is on the right.

Figure 18: Admin Console Navigation

AftercreatingcustommenusinBPCforExcel,youcandefinesecurityforthem

andaddthemtothecustommenulistintheBPCforExcelactionpane. Oncethey

areaddedtothelist,theyareavailabletotheappropriateusersforselectioninthe

action pane upon opening BPC for Excel.

Figure19: CreatingaNewApplicationSet(1of2)

第 22 页 / 共 473 页

Unit1: CreatingApplicationSets,DimensionsandProperties BPC310

Figure20: CreatingaNewApplicationSet(2of2)

WhenanAppSetiscopied, Databaserecords, BPFs, ContentLibrarypostings,

Live Reports and Journals can be copied from the source AppSet. If there are

journal entries in the source AppSetl, they are copied by default. Master data

is always copied.

Figure 21: Setting Application Set Status

TheAppSetstatuscanbesettoeither“Available”or“Unavailable”.

A custom message can be created that will inform users that the AppSet is

unavailable.

第 23 页 / 共 473 页

BPC310 Lesson: Getting Started & Terminology

Figure 22: AppSet Offline – Excel

Thisslidecontainsinformationabouttheimplicationofanapplicationsetbeing

offline for other modules.

Onceloggedon,ApplicationAdministratorscanstillgetdata,buttheyshouldbe

verycarefulastheAppSetistypicallyofflineforareason.

Additionally, datamanagerpackagescanstillbeexecutedwhentheAppSetis

offlineifAdministratorsentertheAppSetafterreceivingtheabovewarning.

Administrators can also Write back through input schedules if they decide to

continue, sothiswarningshouldbetakenseriously.

Figure 23: Set Template Version

第 24 页 / 共 473 页

Unit1: CreatingApplicationSets,DimensionsandProperties BPC310

Thetemplateversionnumberisusedtokeepthedynamictemplatesandschedules

in sync between the server and BPC Excel.

Lab 1 – Creating a New Application Set

(part of the last unit)

第 25 页 / 共 473 页

BPC310 Lesson: Getting Started & Terminology

Lesson Summary

You should now be able to:

• understand the advantages of BPC, the terminology and how to maintain

Application Sets.

第 26 页 / 共 473 页

Unit1: CreatingApplicationSets,DimensionsandProperties BPC310

Lesson: Dimensions, Properties & Hierarchies

Lesson Overview

Lesson Objectives

Aftercompletingthislesson, youwillbeableto:

• UnderstandhowtomaintainDimensions,propertiesandhierarchies

Business Example

Figure 24: Before you create Dimensions

Learnthebasicsforaddingdimensionswhicharethebuildingblockstobuilding

anSAPBusinessPlanningandConsolidationapplication.

Aspartofthedesignsession,identifytheapplicationsthatwillbebuilt.

Define the dimensions to be included in each application, including an

understanding of any shared dimensions.

DeterminethesourceoftheMasterDatamembersincludedinadimension.

Considerimportantpropertiesorattributestobeassociatedwiththedimension

members.

Comeupwithamodelpriortothehands-ondesignprocess.

第 27 页 / 共 473 页

BPC310 Lesson: Dimensions, Properties & Hierarchies

Figure 25: Dimension Types

Additionaldimensionscanbecreatedasneeded. However,the9dimensiontypes

are fixed.

IntheCurrentViewinExcelforexample,Measuresalsoappearsasadimension

butitisntreallyadimensionratherasystemprovidedPeriodicvs. ToDateview

of the data.

Figure 26: Where do you create dimensions?

If you select the dimensions folder, you will see a very good listing of all the

dimension types and their other meta data.

第 28 页 / 共 473 页

Unit1: CreatingApplicationSets,DimensionsandProperties BPC310

Figure 27: Creating Dimensions (1 of 2)

To create a new dimension:

• Click “Add a new dimension”.

• Specifyyourdimensionnameandyourdimensiondescription.

Note: Dimensionnamesarenotcasesensitiveandwilldisplayyour

dimension in the case you typed, but dimension names must be

unique regardless of case.

• Choose your Dimension Type.

• Specifyyourreferencedimension(ifapplicable).

• EachdimensionbuiltwillwalkthroughaseriesofstepsviatheActionPane

inside the Admin Console.

IfyoumakeanymistakesyoumayclicktheBackbutton, orclickBackonthe

main Admin Console Action Pane.

Remember, clickingtheLefthandsidepanewillquittheactivityorstepinthe

process.

第 29 页 / 共 473 页

BPC310 Lesson: Dimensions, Properties & Hierarchies

Figure 28: Creating Dimensions (2 of 2)

Itisbesttohavesomeideaofthepropertiesrequiredwhencreatingdimensions.

However,theymayalwaysbeaddedlaterinthedesignprocess.

Figure 29: Delete Dimension

Onlydeleteadimensiononceyouhaveremoveditfromanyactiveapplication.

Onceitisdeleted,allassociatedinformationisremovedfromthedatabase.

第 30 页 / 共 473 页

Unit1: CreatingApplicationSets,DimensionsandProperties BPC310

Figure 30: Export Dimension

IncaseofSQLdimensiondataandExcelMemberfiledonotcorrespond,“Export

Diimension”isneededtomakesurethatthedifferentstoragetypescontainthe

same members.

Ifyouexecute“ExportDimension”thefilewillbestoredintheFilefolderserver

asfollows: \Webfolders\<AppSetName>\AdminApp.

Thefile'snamecreatedby“ExportDimension”willbe“DimensionName.xls”

or if the number of members is over 65,000 several dimension sheets

are created and the files name then will be “DimensionName_1.xls” and

“DimensionName_2.xls” and so on.

Figure 31: Dimension Properties

Definingtherightpropertiesinadimensionsupportvariousfunctionsfromthe

usersinterfaceandmakereportingmucheasier.

第 31 页 / 共 473 页

BPC310 Lesson: Dimensions, Properties & Hierarchies

Inaddition,propertiesareoftencriticalcomponentsusedtoevaluateexpressions

in advanced script logic and business rules.

Remember,thevalueyouplaceinamemberspropertymaybeusedinanExcel

report.

Figure 32: Maintaining Properties

Dimension Required Property

Entity(E) Currency

Account(A) Account Type (you can only use the 4 delivered member

values) INC, EXP, AST, LEQ

Rate Type (avg, end of month ex)

Scaling

Category(C) Year, used in rporting

Time (T) Level – level in a hierarchy

Period

TimeID

Year

All Dimensions require: ID, Description, Newid (used to swap in a different

member id)

第 32 页 / 共 473 页

Unit1: CreatingApplicationSets,DimensionsandProperties BPC310

Figure 33: Maintaining Dimension Members

Foraquickwaytocreateadimension,choosethecopyoption.

Tochangeadimensionnameordescription,choosemodify. (Youcannotchange

the dim type of an existing dimension.)

Processingupdatesthedatabaseandthemembersheet.

Figure 34: Maintaining Dimension Members

Memberidscanhaveupto20characters. IDscannothavespacesoranyspecial

charactersexcept. and_. IDsmustbeuniqueperdimension.

Descriptions are 50 characters and can have special characters and spaces.

However, they cannot contain double quotes.

第 33 页 / 共 473 页

BPC310 Lesson: Dimensions, Properties & Hierarchies

You can rename members using the NEWID property. NEWID is a required

property in all dimensions.

NotethatifyoutypethenewnameinplaceoftheexistingnameintheIDcolumn,

youwillreceiveerrors. YoumustusetheNEWIDcolumn.

Figure35: Nomemberlimitationfordimensions

From7.0MonitspossibletomaintainseveraltabcardsintheMemberSheet.

So the former limitation of 65536 lines which was the maximal number of

members of a dimension no longer exists.

Justdistributethememberstoseveralworksheetswithinonemembersheetfile.

Stick to the naming convention for the worksheets: Members_1; Members_2

and so on.

Figure 36: Member Sheets

第 34 页 / 共 473 页

Unit1: CreatingApplicationSets,DimensionsandProperties BPC310

CompoundingisnothandledbyBPC.(Forexample,usesystemlogictotreattwo

field like city and state as a composite key.)

Youcaneithercreatemasterdataeitherbycopy&pasteexistingmasterdatainto

membersheets. HerethedataalreadyexistsinanexternalExcelFile. Oryou

directlyfillinyourmasterdataintheMembersheets.

Figure 37: Modeling Hierarchies

Itisnaturaltohavehierarchiesfordimensionssuchasentityandtimewherethe

needforrollupsiscommon. Hierarchiesalsoallowtheuseofmultipleviewsfrom

onedimension. Forexampletheentity(suchasStore)dimensioncanbeusedto

view data by company code, plant, or region.

第 35 页 / 共 473 页

BPC310 Lesson: Dimensions, Properties & Hierarchies

Figure 38: Multiple Hierarchies

Figure39: TimeDimensionandmultipleHierarchiesonTime

TheTimeDimensiondefinesthetimeperiodsforyourapplicationandhowthey

aggregate.

Eachdimensionoftype“T”isatimedimension.

Eachapplicationmusthaveexactlyonetimedimension.

TheTimeDimensioncontainstheperiodsforwhichyouwanttostoredata.

New time level as “Half Year” can be defined.

Hierarchiesonthetimedimensiondefinewhosystemaggregatesontime.

第 36 页 / 共 473 页

Unit1: CreatingApplicationSets,DimensionsandProperties BPC310

For a given Time dimension, you can create an unlimited number of Time

hierarchies with different LEVELS.

Note: Werecommendthatyoucreatenomorethanthreetimehierarchies

for a dimension.

• TheTimehierarchiescanhavedifferentstartingpoints,configuredusingthe

ISBEGINNING property (for instance, you may want one hierarchy that

followsacalendaryearandanotheronethatrepresentsthefiscalyear).

• Ifyouareusingmultipletimehierarchies,specifythetimehierarchytobe

usedinthisapplicationintheYTDInputTimeHirfield(H1isthedefault).

Figure 40: Processing Dimensions

Processingadimensionwillexecutethefollowingsteps:

• validate hierarchies

• validate dimension member formulas

Toprocessadimension,clickon“DimensionLibrary”ontheleftoftheAdmin

Console. Afteryouaddanewdimensionormakechangestoadimension,you

must process it. Processing occurs automatically after you create or modify a

dimension,soyouonlyneedtoperformthisprocedurewhenyouneedtomanually

process dimensions.

Modifying the member table requires that you manually process dimensions.

Whenyouprocessanewdimension,thesystemconstructsamapofthedimension

in Analysis Services. This sets up the entire hierarchy, so that the dimension

is easy to find upon querying the application. In addition, processing a new

dimensionsetsupamembertablewithsomedefaultproperties.

第 37 页 / 共 473 页

BPC310 Lesson: Dimensions, Properties & Hierarchies

Whenyouprocessanexistingdimension, thesystemstoresthechangesinthe

database. Certainchangestoadimensionforcesthesystemtoprocesstheentire

application. Youcanscheduletheprocessingofdimensions

Lab 2 – Updating the Account Dimension

(Part of the last unit)

Lab 3 – Creating a Product Dimension

(Part of the last unit)

Lab 4 – Process the Time Dimension

(Part of the last unit)

Lab 5 – Updating the Category Dimension

(Part of the last unit)

Lab 6 – Updating the InputCurrency Dimension

(Part of the last unit)

Lab 7 – Updating the Entity Dimension and Creating

a Hierarchy

(Part of the last unit)

Lab 8 – Updating the IntCo Dimension

(Part of the last unit)

第 38 页 / 共 473 页

Unit1: CreatingApplicationSets,DimensionsandProperties BPC310

Lesson Summary

You should now be able to:

• UnderstandhowtomaintainDimensions,propertiesandhierarchies

第 39 页 / 共 473 页

BPC310 Unit Summary

Unit Summary

You should now be able to:

• understand the advantages of BPC, the terminology and how to maintain

Application Sets.

• UnderstandhowtomaintainDimensions,propertiesandhierarchies

第 40 页 / 共 473 页

UnitSummary BPC310

第 41 页 / 共 473 页

第 42 页 / 共 473 页

第 43 页 / 共 473 页

Unit 2

Creating Applications, Introduction

to Logic and Loading of Transaction

Data

Unit Overview

Unit Objectives

After completing this unit, you will be able to:

• Understandhowtocreate,modelandoptimizeApplications. Youwillalso

haveanideaabouthowtosecureadimension.

• UnderstandthevarioustypesofBPClogicandwhenyouusethem.

• Understand your options for loading transaction data into BPC, the

transformationmethodology, anderrorhandling.

Unit Contents

Lesson: Creating Applications .................................................34

Lesson: Introduction to Logic...................................................46

Lesson: Loading of Transaction Data.........................................61

第 44 页 / 共 473 页

Unit2: CreatingApplications,IntroductiontoLogicandLoadingofTransaction

Data BPC310

Lesson: Creating Applications

Lesson Overview

Lesson Objectives

Aftercompletingthislesson, youwillbeableto:

• Understandhowtocreate,modelandoptimizeApplications. Youwillalso

haveanideaabouthowtosecureadimension.

Business Example

Figure 41: Creating a New Application

When you Copy an application, the transaction data from the source is copied

to the new application.

Business requirements will drive the need to create applications. Generally

speaking these are homogeneous data sets.

HR planning would call for a separate application vs. Cost Center planning

because the fields are so vastly different.

BusinessRulesareusedinlegalconsolidations.

第 45 页 / 共 473 页

BPC310 Lesson: Creating Applications

Figure 42: Creating a New Application via Add

Bycheckingoffthecurrencyconversionrules,thesystemwillcreatebusinessrule

tables to perform that function.

Financeapplicationsmustreferencearateapplication. Onerateapplicationcanbe

referenced by multiple other applications.

Consolidationapplicationsmustreferencearateapplicationandanownership

application.

Figure43: AssigningDimensionstoApplications

第 46 页 / 共 473 页

Unit2: CreatingApplications,IntroductiontoLogicandLoadingofTransaction

Data BPC310

Thisslidecontainsalistofoptionsavailablewhenanapplicationisbeingcreated.

Duringthecopyprocess,the“Dimensions”checkboxcanbede-selectedwhich

allowsdifferentdimensionstobeaddedtothenewapplication. Dimensionscould

also be added/removed later as well.

Adimensioncanalsobeflaggedasa“Secured”dimensionduringthisprocess.

Note: Note on securing dimensions:

Ifyoucanwritetoacategory,youcancertainlyreadittoo.

Ifyoucan'treadanentity,youcertainlycan'twritetoit.

So, eventhoughweonlychosetocontrolreadaccessbyentity, ifyour

rights are to only read EntityX then the ability to write to EntityX is

inherited for the category specified.

Atleastonedimensionmustbedesignatedassecureortheapplication

cannot be used.

Figure 44: Providing Access

Note: ThissettingisshownabovefortheSalesApplicationonly.

第 47 页 / 共 473 页

BPC310 Lesson: Creating Applications

Figure 45: Application Parameters

If a parameter does not appear in the list, you can add it in the New row and

update it.

Figure 46: Admin Client – Application Options

Whenyouselectanapplication, theActionPanewilldisplayonlytherelevant

actions for application maintenance.

Modifywillallowyoutoaddorremovethedimensionsforanapplicationand

change the dimension security options. Although it would not be needed very

oftenitwouldalsoallowyoutochangetheapplicationtype.

第 48 页 / 共 473 页

Unit2: CreatingApplications,IntroductiontoLogicandLoadingofTransaction

Data BPC310

Figure 47: Modifying an Application

Changingtheapplicationtypewouldberareandifdataexists,notrecommended.

ReassignSQLIndexdropsandre-buildsthefacttableindex. ProcessApplication

modifiesthefacttable,createsstoredprocedures,updatestheOLAPdatabase.

Thesystemautomaticallydetectssituationswhentheindexingandprocessing

application is necessary.

Todeleteadimensionfromanapplication, itisnecessarytofirstdeleteallthe

dependencies of that dimension from the application such as work status for

example. Duplicatedimensiontypesarenotallowedinoneapplicationunlessthe

type is User Defined.

Figure 48: Application Types (1 of 2)

第 49 页 / 共 473 页

BPC310 Lesson: Creating Applications

Whencreatinganewapplication,youmustchooseanapplicationtype,whichtells

thesystemwhichpropertiestoassociatewiththeapplication.

Forexample,FinancialAppsarereferencedtoRateApps.

Non-reportingappscanbechangedtoreportingapps.

Generic apps can be changed to Finance apps.

Financeappscanbechangedtoconsolidationsapps.

ConsolidationsappscanbechangedtoFinanceapps.

Figure 49: Application Types (2 of 2)

You can report on non-reporting application data, but you cannot assign work

status codes to the data. In addition, you cannot define business rules to these

application types. All Applications require the four dimension types: Entity,

Account, time and Category.

第 50 页 / 共 473 页

Unit2: CreatingApplications,IntroductiontoLogicandLoadingofTransaction

Data BPC310

Figure50: ReferencingApplications&BusinessRules

Youcanhaveinterdependencybetweenapplications.

It is also possible to define Business Rules which can be applied to certain

Financial and Consolidations applications.

Figure 51: Data Storage Types

WhentheWBtablegrowsto50,000ormorerecords,theruleofthumbistorun

optimizationtoclearitout. Theneedcanvarydependingonthecharacteristics

ofyourhardwareenvironmentandyourapplication. Youcanalsosetthesystem

toremindyoutooptimizetheapplicationwhenthesystemdatabasegrowstoa

certain size.

第 51 页 / 共 473 页

BPC310 Lesson: Creating Applications

Figure 52: Optimization Options

To optimize an application

1. From the Admin Console, select Application, and then select any

application.

2. From the Manage Applications action pane, select Select Optimize

application.

3. Selectoneormoreapplicationstooptimize.

4. Select Lite, Incremental, or Full Optimize. See the descriptions above

for more information.

TheCompressDatabaseoptionsumsmultipleentriesforthesamecurrent

viewintooneentrysothatdatastoragespaceisminimized.

5. Click Optimize Applications.

(Dependingonthesizeofyourapplicationsandtheoptionsselected, this

process can take a long time.)

第 52 页 / 共 473 页

Unit2: CreatingApplications,IntroductiontoLogicandLoadingofTransaction

Data BPC310

Figure 53: Optimization

YoucanhaveBPCremindyoutooptimizeyourapplicationswhenyoulogon

totheAdminConsole. Thewarningdisplayswhenthereal-timestorageforan

applicationgrowstoacertainnumberofrecordsspecifiedbyyou. Youmusthave

systemadministratoraccesstosetuptheoptimizationreminder.

To set up an optimization reminder

1. FromtheBPCAdministrationactionpane,selectSetAppsetparameters.

(If you do not see the Set Appset Parameters link, then you do not have

the proper task access rights.)

2. IntheWBRECORDCNTfield,enterthenumberofrecordsthewrite-back

tablewillgrowtobeforethewarningmessageisdisplayed.

3. Click the Update link.

第 53 页 / 共 473 页

BPC310 Lesson: Creating Applications

Figure54: OptimizationApplications–CompressDatabase

Thesystemwritesdeltarecordstothefacttablestoreachtheendresulttheuser

sees in reports and input templates.

Figure55: OptimizationApplications–IndexDefragmentation

WiththehelpofIndexDefragmentationyoucanupdateallindicesandstatistics

to receive a faster access to the data.

IndexDefragmentationhasaneffectontheFacttables.

Ifyouareusingthisfunctionalityitcantakealotoftimeifyourfacttableisfull.

第 54 页 / 共 473 页

Unit2: CreatingApplications,IntroductiontoLogicandLoadingofTransaction

Data BPC310

Lab 9 – Creating a New Application

(part of the last unit)

Lab 10 – Grant Access to the Sales Application and to

all Tasks and Allow Loading of transaction data for

certain file types

(part of the last unit)

第 55 页 / 共 473 页

BPC310 Lesson: Creating Applications

Lesson Summary

You should now be able to:

• Understandhowtocreate,modelandoptimizeApplications. Youwillalso

haveanideaabouthowtosecureadimension.

第 56 页 / 共 473 页

Unit2: CreatingApplications,IntroductiontoLogicandLoadingofTransaction

Data BPC310

Lesson: Introduction to Logic

Lesson Overview

Lesson Objectives

Aftercompletingthislesson, youwillbeableto:

• UnderstandthevarioustypesofBPClogicandwhenyouusethem.

Business Example

Figure 56: Types of Logic

第 57 页 / 共 473 页

BPC310 Lesson: Introduction to Logic

WorksheetBasedLogicexistsinworksheetsonly.

• Dimensionmemberformulas(usesparingly)giveyoutheabilitytodefine

verypowerfulformulasforcalculatingAccountdimensionmembers.

• DimensionmemberformulasaredefinedattheApplicationSetlevel,thus

theyarevalidacrossallapplicationswhichusethedimension.

• WithinthedefinitionofadimensionusingMicrosoftMDXlanguage

• Scriptlogicisdefinedwithineachapplicationandisusedtocalculatedata.

• A script using a proprietary language or MDX for base level data in the

application.

• Calculationscancrossapplicationswithinoneapplicationset.

• RulesBased(tabledriven)LogicBusinessrulesallowyoutocustomizelarge

datamanipulationtasks,suchasbulkdataimportswithcurrencytranslations,

aswellassmallertasks,suchassubmittinginputdatatothedatabase. BPC's

businessrulessupportbothmanagementandlegalconsolidationreporting.

• Usingarulesbasedengineforspecificpre-definedbusinessrequirements

• Legal consolidation

• Currency

• Elimination

• Rules not specific to a single member ID

• Calculations will cross applications.

Figure 57: Worksheet Logic

第 58 页 / 共 473 页

Unit2: CreatingApplications,IntroductiontoLogicandLoadingofTransaction

Data BPC310

To access BPC functions, select the fx function > select the category BPC

Functions. Ofcourse,youcanaddyourowncalculationsandmacrosandthey

will be saved with the workbooks.

Figure58: OverviewofDimensionMemberFormulas

DimensionLogicwillhaveanegativeimpactonretrievaltimeswhensystemisin

use by multiple users!

Dontgetfooledbythedevelopmentenvironmentperformance.

Figure59: PrerequisitetoUsingDimensionMemberFormulas

WesuggesttheFormulalengthbedefinedas255charactersorgreater.

第 59 页 / 共 473 页

BPC310 Lesson: Introduction to Logic

Figure60: MaintainingDimensionMemberFormulas

YouassigndimensionformulasintheFormulacolumnofthedimensionmember

sheet.

Theformulascaneitherbeself-createdortakenfromalibrary.

Growth(%ACCOUNT%)–comparescreenshot–isalibrarydimensionformula.

It calculates account growth rate. This result is used in sales growth, expense

growth, and other functions.

Librarydimensionformulasareexplainedlater.

Figure61: SyntaxofDimensionMemberFormulas

Thesyntaxfordimensionmemberformulasrequiresasquarebracketaroundthe

dimensionandthememberandseparatedbyaperiod. Theonlyexceptioniswith

theaccountdimension,whereonlythedimensionmemberisneeded.

Standardarithmeticfunctionsareavailable,suchasaddition(+),subtraction(-),

multiplication(+)anddivision(/),asaretheMDXkeywordssupportedbySAP

BPC.

第 60 页 / 共 473 页

Unit2: CreatingApplications,IntroductiontoLogicandLoadingofTransaction

Data BPC310

Figure62: SolveOrderandFormulaCollision1/2

Solve Order is similar to some reporting systems “Formula Collision” setting

whenthereareformulasinboththerowsandcolumnsofareport.

Solve Order determines the order in which dimensions, members, calculated

members, custom rollups, and calculated cells are evaluated, and the order in

which they are calculated.

Zero is the highest priority.

Figure63: SolveOrderandFormulaCollision2/2

第 61 页 / 共 473 页

BPC310 Lesson: Introduction to Logic

Theupperslideshowstheeffectsofsolve_orderiftheorderisconvertedcompared

to the example of the last slide.

Figure 64: The Library File

You can type MDX syntax expressions directly into the Formula cell for each

member,oryoucanreferenceMDXfunctionsfromalibraryfile. Alibraryfileis

usedtostoremultipleformulasthatarereferencedbydimensionformulas. This

makesmaintenanceofformulasusedinmultipledimensionseasierbecausethey

are stored in one file.

BPC is shipped with many useful MDX functions that help standardize your

calculated members.