BPC311_EN_Col91_FV_Part_A4 (第1页)

第 1 页 / 共 237 页

BPC311

SAP BusinessObjects Planning

and Consolidation: Application

Configuration

SAP CPM

Date

Training Center

Instructors

Education Website

Participant Handbook

Course Version: 91

CourseDuration:5Days

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

第 2 页 / 共 237 页

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.

g200942735955

第 3 页 / 共 237 页

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.

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

AboutThisHandbook BPC310

Icons in Body Text

The following iconsareused in thishandbook.

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

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

Loading of Transaction Data ........................................60

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

Security................................................................144

Work Status...........................................................156

Business Process Flows............................................165

Audit...................................................................178

Unit 5: Miscellaneous..................................................191

Miscellaneous ........................................................192

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

Case Study – optional...............................................204

第 6 页 / 共 237 页

Contents BPC310

第 7 页 / 共 237 页

Course Overview

Target Audience

Thiscourseisintendedforthefollowing audiences:

• WhoisresponsibleforapplicationdevelopmentandadministrationofSAP

Business Planning and Consolidation.

• All thosewhowant toget familiar with BPC.

Course Prerequisites

Required Knowledge

• Good knowledge in Microsoft Office.

Recommended Knowledge

• Understandingofbasicfinancialaccountingprinciples.

Course Goals

This course will prepare you to:

• [Enter a course goal.]

Course Objectives

After completingthiscourse, youwillbeable to:

• [Enter a course objective.]

• [Enter acourseobjectiveor deleteif not used.]

vii

第 8 页 / 共 237 页

CourseOverview BPC310

viii

第 9 页 / 共 237 页

Unit 1

Creating Application Sets, Dimensions

and Properties

Unit Overview

Unit Objectives

After completing thisunit, you will beableto:

• understand theadvantages of BPC, the terminology and howto maintain

Application Sets.

• UnderstandhowtomaintainDimensions,propertiesandhierarchies

Unit Contents

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

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

第 10 页 / 共 237 页

Unit1: CreatingApplicationSets,DimensionsandProperties BPC310

Lesson: Getting Started & Terminology

Lesson Overview

Lesson Objectives

After completingthislesson, you will beable to:

• understand theadvantagesof BPC,the terminology and howto 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-packagedprocessflowsfor common

business processes, aligned to structured and unstructured data and easily

modifiableviaself-service,enableallstakeholderstoparticipateinthevaluechain

and follow the agreed upon process.

第 11 页 / 共 237 页

BPC310 Lesson: Getting Started & Terminology

Intelligentactionpanes–Actionpaneswithdiscussionthreadsandunstructured

dataimproveproductivitybyhelpingyourusersunderstandwhatactionstotake,

whenandhowtoact,andwhytheactionsarenecessary.

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

helps track planstatusandprovides stakeholderswith immediate accesstothe

plan.

Financial management –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

solutionsfor governance, risk, and compliance to reduce the risk of fraud and

errorsand create afully-documented audit trail.

Figure 2: Business Process Flows- Budgeting Example

第 12 页 / 共 237 页

Unit1: CreatingApplicationSets,DimensionsandProperties BPC310

OneofthebiggestadvantagesofBPCistheBusinessProcessFlow(BPF).The

graphicaboveshowsatypical exampleof aBPF.

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

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-server environment, withaWeb server, Applicationserver

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

DB server.

Thedifferentservertypescanbeinstalledonupto7differentmachines.

第 14 页 / 共 237 页

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.

Figure 7: 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 页 / 共 237 页

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

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)

The limit of 20dimensions isnot a hardlimit but rather apractical one. More

than20dimensionsareallowedbutonlywithsignificantperformancehitswhich

always depend on the situation.

Note: Thescreenshot aboveisintendedtoshowthedatacapturedfor

an application.

Figure 11: Terminology: Applications

Thisslideliststhedimensiontypesthatarerequiredineveryreportingapplication

andthedimensiontypethatisrequiredineachapplicationset.

第 17 页 / 共 237 页

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

Unit1: CreatingApplicationSets,DimensionsandProperties BPC310

Administrator Roles

• Therearedifferenttypesof administratorsinSAPBusinessPlanningand

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

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

• Createand maintain business process flows

• Create and maintain business rules.

Figure 15: BPC Login

TheConnection Wizard isanimportant tool tologto different applicationsets

and to set the default set.

ThefollowingslidegivesmoredetailstotheConnectionWizard.

第 20 页 / 共 237 页

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

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.

Figure 19: Creating a New Application Set (1 of 2)

第 22 页 / 共 237 页

Unit1: CreatingApplicationSets,DimensionsandProperties BPC310

Figure 20: Creating a New Application Set(2 of 2)

WhenanAppSet iscopied, Databaserecords, BPFs, Content Librarypostings,

Live Reports and Journalscan 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 页 / 共 237 页

BPC310 Lesson: Getting Started & Terminology

Figure 22: AppSet Offline - Excel

Thisslidecontainsinformationabouttheimplicationofanapplicationsetbeing

offline for other modules.

Onceloggedon,ApplicationAdministratorscanstillgetdata,buttheyshouldbe

verycarefulastheAppSetistypicallyofflineforareason.

Additionally, datamanager packagescan still beexecuted when theAppSet is

offlineifAdministratorsentertheAppSetafterreceivingtheabovewarning.

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

continue, sothiswarningshouldbetakenseriously.

Figure 23: Set Template Version

第 24 页 / 共 237 页

Unit1: CreatingApplicationSets,DimensionsandProperties BPC310

Thetemplateversionnumberisusedtokeepthedynamictemplatesandschedules

in sync between the server and BPC Excel.

第 25 页 / 共 237 页

BPC310 Lesson: Getting Started & Terminology

Lesson Summary

You should now be able to:

• understand theadvantages of BPC, the terminology and howto maintain

Application Sets.

第 26 页 / 共 237 页

Unit1: CreatingApplicationSets,DimensionsandProperties BPC310

Lesson: Dimensions, Properties & Hierarchies

Lesson Overview

Lesson Objectives

After completingthislesson, you will beable to:

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

Consider importantpropertiesorattributestobeassociatedwiththedimension

members.

Comeupwithamodelpriortothehands-ondesignprocess.

第 27 页 / 共 237 页

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?

Ifyouselectthedimensionsfolder,youwillseeaverygoodlistingoftheallthe

dimension types and their other meta data.

第 28 页 / 共 237 页

Unit1: CreatingApplicationSets,DimensionsandProperties BPC310

Figure 27: Creating Dimensions (1 of 2)

To create a new dimension:

• Click “Add a new dimension”.

• Specify your dimension name and your dimension description. Note:

Dimensionnamesarenotcasesensitiveandwilldisplayyourdimensionin

thecaseyoutyped,butdimensionnamesmustbeuniqueregardlessofcase.

• Choose your Dimension Type.

• Specifyyour referencedimension(if applicable).

• EachdimensionbuiltwillwalkthroughaseriesofstepsviatheActionPane

inside the Admin Console.

Ifyou makeany mistakesyoumayclick theBack button, or clickBackonthe

main Admin Console Action Pane.

Remember, clickingtheLefthandsidepanewillquit theactivityorstepinthe

process.

第 29 页 / 共 237 页

BPC310 Lesson: Dimensions, Properties & Hierarchies

Figure 28: Creating Dimensions (2 of 2)

Itisbesttohavesomeideaofthepropertiesrequiredwhencreatingdimensions.

However,theymayalwaysbeaddedlaterinthedesignprocess.

Figure 29: Delete Dimension

Onlydeleteadimensiononceyouhaveremoveditfromanyactiveapplication.

Onceitisdeleted,allassociatedinformationisremovedfromthedatabase.

第 30 页 / 共 237 页

Unit1: CreatingApplicationSets,DimensionsandProperties BPC310

Figure 30: Export Dimension

IncaseofSQLdimensiondataandExcelMemberfiledonotcorrespond,“Export

Diimension”isneededtomakesurethatthedifferentstoragetypescontainthe

same members.

Ifyouexecute“ExportDimension”thefilewillbestoredintheFilefolderserver

asfollows: \Webfolders\<AppSet Name>\AdminApp.

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

or if the 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

usersinterface and make reporting mucheasier.

第 31 页 / 共 237 页

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

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

BPC310 Lesson: Dimensions, Properties & Hierarchies

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

property in all dimensions.

NotethatifyoutypethenewnameinplaceoftheexistingnameintheIDcolumn,

you will receive

errors. You must use the NEW ID column.

Figure 35: No member limitation for dimensions

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.

第 34 页 / 共 237 页

Unit1: CreatingApplicationSets,DimensionsandProperties BPC310

Figure 36: Member Sheets

CompoundingisnothandledbyBPC.(Forexample,usesystemlogictotreattwo

field like city and state asa composite key.)

Youcaneithercreatemasterdataeitherbycopy&pasteexistingmasterdatainto

member sheets. Here the data alreadyexistsin an external Excel File. Or you

directlyfillinyour masterdataintheMembersheets.

Figure 37: Modeling Hierarchies

Itisnaturaltohavehierarchiesfordimensionssuchasentityandtimewherethe

needforrollupsiscommon. Hierarchiesalsoallowtheuseofmultipleviewsfrom

onedimension. Forexampletheentity(suchasStore)dimensioncanbeusedto

viewdata by company code, plant, or region.

第 35 页 / 共 237 页

BPC310 Lesson: Dimensions, Properties & Hierarchies

Figure 38: Multiple Hierarchies

Figure39: TimeDimensionandmultipleHierarchies on Time

TheTimeDimensiondefinesthetimeperiodsforyourapplicationandhowthey

aggregate.

Each dimension of type“T”isa timedimension.

Eachapplicationmusthaveexactlyonetimedimension.

TheTimeDimensioncontainstheperiodsforwhichyouwanttostoredata.

New timelevel as “Half Year” can be defined.

Hierarchiesonthetimedimensiondefinewhosystemaggregatesontime.

第 36 页 / 共 237 页

Unit1: CreatingApplicationSets,DimensionsandProperties BPC310

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

hierarchies with different LEVELS.

Note: We recommend that you create no more than three time hierarchies for

a dimension.

• TheTimehierarchiescanhavedifferentstartingpoints, configuredusing

theISBEGINNINGproperty(forinstance,youmaywantonehierarchythat

followsacalendaryearandanotheronethatrepresentsthefiscalyear).

• Ifyouareusingmultipletimehierarchies,specifythetimehierarchytobe

usedinthisapplicationintheYTDInputTimeHirfield(H1isthedefault).

Figure 40: Processing Dimensions

Processingadimensionwillexecutethefollowingsteps:

• validate hierarchies

• validate dimension member formulas

Toprocessadimension,clickon“DimensionLibrary”ontheleftoftheAdmin

Console. Afteryouaddanewdimensionor makechangestoadimension, 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 页 / 共 237 页

BPC310 Lesson: Dimensions, Properties & Hierarchies

Whenyou processanexisting dimension, thesystemstoresthechanges inthe

database. Certainchangestoadimensionforcesthesystemtoprocesstheentire

application. Youcanscheduletheprocessingofdimensions

第 38 页 / 共 237 页

Unit1: CreatingApplicationSets,DimensionsandProperties BPC310

Lesson Summary

You should now be able to:

• UnderstandhowtomaintainDimensions,propertiesandhierarchies

Related Information

•

第 39 页 / 共 237 页

BPC310 Unit Summary

Unit Summary

You should now be able to:

• understand theadvantages of BPC, the terminology and howto maintain

Application Sets.

• UnderstandhowtomaintainDimensions,propertiesandhierarchies

第 40 页 / 共 237 页

UnitSummary BPC310

第 41 页 / 共 237 页

第 42 页 / 共 237 页

第 43 页 / 共 237 页

Unit 2

Creating Applications, Introduction

to Logic and Loading of Transaction

Data

Unit Overview

Unit Objectives

After completing thisunit, you will beableto:

• Understandhowtocreate,modelandoptimizeApplications. Youwillalso

have anidea about howto secure adimension.

• UnderstandthevarioustypesofBPClogicandwhenyouusethem.

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

transformation methodology, anderror handling.

Unit Contents

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

Lesson: Introduction to Logic...................................................45

Lesson: Loading of Transaction Data.........................................60

第 44 页 / 共 237 页

Unit2: CreatingApplications,IntroductiontoLogicandLoadingofTransaction

Data BPC310

Lesson: Creating Applications

Lesson Overview

Lesson Objectives

After completingthislesson, you will beable to:

• Understandhowtocreate,modelandoptimizeApplications. Youwillalso

haveanideaabout howtosecurea dimension.

Business Example

Figure 41: Creating a New Application

When you Copyan application, the transaction data from the sourceis copied

to the new application.

Business requirements will drive the need to create applications. Generally

speakingthesearehomogeneousdatasets. HRplanningwouldcallforaseparate

applicationvs. CostCenterplanningbecausethefieldsaresovastlydifferent.

BusinessRulesareused in legal consolidations.

第 45 页 / 共 237 页

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.

Consolidationapplicationsmust reference arateapplication andanownership

application.

Figure 43: Assigning Dimensions to Applications

第 46 页 / 共 237 页

Unit2: CreatingApplications,IntroductiontoLogicandLoadingofTransaction

Data BPC310

Thisslidecontainsalistofoptionsavailablewhenanapplicationisbeingcreated.

Duringthecopyprocess,the“Dimensions”checkboxcanbede-selectedwhich

allowsdifferentdimensionstobeaddedtothenewapplication. Dimensionscould

also be added/removed later as well.

Adimensioncanalsobeflaggedasa“Secured”dimensionduringthisprocess.

Noteonsecuringdimensions: Ifyoucanwritetoacategory,youcancertainlyread

ittoo. Ifyoucan'treadanentity,youcertainlycan'twritetoit. So,eventhoughwe

onlychosetocontrolreadaccessbyentity,ifyourrightsaretoonlyreadEntityX

thentheabilitytowritetoEntityXisinheritedforthecategoryspecified. Atleast

onedimensionmustbedesignatedassecureortheapplicationcannotbeused.

Figure 44: Providing Access

NotethatthissettingisshownabovefortheSalesApplicationonly.

Figure 45: Application Parameters

第 47 页 / 共 237 页

BPC310 Lesson: Creating Applications

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

Whenyou select an application, theActionPanewill displayonlytherelevant

actions for application maintenance.

Modifywillallowyou toaddor removethedimensionsfor an applicationand

change thedimension security options. Although it would not be needed very

oftenitwouldalsoallowyoutochangetheapplicationtype.

Figure 47: Modifying an Application

第 48 页 / 共 237 页

Unit2: CreatingApplications,IntroductiontoLogicandLoadingofTransaction

Data BPC310

Changingtheapplicationtypewouldberareandifdataexists,notrecommended.

ReassignSQLIndexdropsandre-buildsthefacttableindex. ProcessApplication

modifiesthefacttable,createsstoredprocedures,updatestheOLAPdatabase.

The system automatically detectssituationswhen the indexingand processing

applicationisnecessary. Todeleteadimensionfromanapplication,itisnecessary

to first deleteallthedependenciesof that dimensionfrom theapplication such

as work status for example. Duplicate dimension types arent allowed in one

application unless the type is User Defined

Figure 48: Application Types (1 of 2)

Whencreatinganewapplication,youmustchooseanapplicationtype,whichtells

thesystemwhichpropertiestoassociatewiththeapplication.

Forexample,FinancialAppsarereferencedtoRateApps.

Non-reportingappscanbechangedtoreportingapps.

Generic appscan bechanged toFinance apps.

Financeappscanbechangedtoconsolidationsapps.

ConsolidationsappscanbechangedtoFinanceapps.

第 49 页 / 共 237 页

BPC310 Lesson: Creating Applications

Figure 49: Application Types (2 of 2)

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

status codesto the data. In addition, you cannot define businessrules to these

application types. Reporting applications require the four dimension-types:

Entity,Account,Time,andCategorybutnon-reportingtypesdonot.

Figure 50: Referencing Applications& Business Rules

Youcan haveinterdependencybetween applications.

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

Financial and Consolidations applications.

第 50 页 / 共 237 页

Unit2: CreatingApplications,IntroductiontoLogicandLoadingofTransaction

Data BPC310

Figure 51: Data Storage Types

WhentheWBtablegrowsto50,000ormorerecords,theruleofthumbistorun

optimizationtoclearitout. Theneedcanvarydependingonthecharacteristics

ofyourhardwareenvironmentandyourapplication. Youcanalsosetthesystem

toremindyoutooptimizetheapplicationwhenthesystemdatabasegrowstoa

certain size.

Figure 52: Optimization Options

To optimize an application

1. FromtheAdminConsole,selectApplication,andthenselectanyapplication.

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

application.

3. Select oneor more applicationsto optimize.

第 51 页 / 共 237 页

BPC310 Lesson: Creating Applications

4. Select Lite, Incremental, or Full Optimize. Seethedescriptionsabovefor

more information.

TheCompressDatabaseoptionsumsmultipleentriesforthesamecurrentview

into one entry

so that data storage space is minimized.

5. Click OptimizeApplications. (Dependingon the size of your applications

and the options

selected, this process can take a long time.)

Figure 53: Optimization

YoucanhaveBPCremind you tooptimize your applicationswhenyoulogon

totheAdminConsole. Thewarningdisplayswhenthereal-timestorageforan

applicationgrowstoacertainnumberofrecordsspecifiedbyyou. Youmusthave

systemadministratoraccesstosetuptheoptimizationreminder.

To set up an optimization reminder

1. FromtheBPCAdministrationactionpane,selectSetAppsetparameters. (If

youdonotseetheSetAppsetParameterslink, thenyoudonothavetheproper

task access rights.)

2. IntheWBRECORDCNTfield, enterthenumberofrecordsthewrite-back

tablewillgrowtobeforethewarningmessageisdisplayed.

3. Click the Update link.

第 52 页 / 共 237 页

Unit2: CreatingApplications,IntroductiontoLogicandLoadingofTransaction

Data BPC310

Figure54: Optimization Applications -CompressDatabase

Thesystemwritesdeltarecordstothefacttablestoreachtheendresulttheuser

sees in reports and input templates.

Figure55: OptimizationApplications-IndexDefragmentation

WiththehelpofIndexDefragmentationyoucanupdateallindicesandstatistics

to receive a faster access to the data.

IndexDefragmentationhasaneffect ontheFacttables.

Ifyouareusingthisfunctionalityitcantakealotoftimeifyourfacttableisfull.

第 53 页 / 共 237 页

Unit2: CreatingApplications,IntroductiontoLogicandLoadingofTransaction

Data BPC310

第 54 页 / 共 237 页

Unit2: CreatingApplications,IntroductiontoLogicandLoadingofTransaction

Data BPC310

Lesson Summary

You should now be able to:

• Understandhowtocreate,modelandoptimizeApplications. Youwillalso

haveanideaabout howtosecurea dimension.

Related Information

• [Enter an optional eference using the URL or CrossReference tag to

additional information that learner may find useful. Examples include

websitesor whitepapers. Delete if not used.]

第 55 页 / 共 237 页

BPC310 Lesson: Introduction to Logic

Lesson: Introduction to Logic

Lesson Overview

Lesson Objectives

After completingthislesson, youwillbeable to:

• UnderstandthevarioustypesofBPClogicandwhenyouusethem.

Business Example

Figure 56: Types of Logic

第 56 页 / 共 237 页

Unit2: CreatingApplications,IntroductiontoLogicandLoadingofTransaction

Data BPC310

Worksheet Based Logicexistsinworksheetsonly.

• 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

第 57 页 / 共 237 页

BPC310 Lesson: Introduction to Logic

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

Functions.Ofcourse,youcanaddyourowncalculationsandmacrosandtheywill

be saved with the workbooks.

Figure 58: Overview of Dimension Member Formulas

DimensionLogicwillhaveanegativeimpactonretrievaltimeswhensystemisin

use by multiple users!

Dontgetfooledbythedevelopmentenvironmentperformance.

Figure59: PrerequisitetoUsingDimensionMemberFormulas

WesuggesttheFormulalengthbedefinedas255charactersorgreater.

第 58 页 / 共 237 页

Unit2: CreatingApplications,IntroductiontoLogicandLoadingofTransaction

Data BPC310

Figure 60: Maintaining Dimension Member Formulas

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.

Librarydimensionformulasareexplained later.

Figure 61: Syntax of Dimension MemberFormulas

Thesyntaxfordimensionmemberformulasrequiresasquarebracketaroundthe

dimensionandthememberandseparatedbyaperiod. Theonlyexceptioniswith

theaccountdimension,whereonlythedimensionmemberisneeded.

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

multiplication(+)anddivision(/),asaretheMDXkeywordssupportedbySAP

BPC.

第 59 页 / 共 237 页

BPC310 Lesson: Introduction to Logic

Figure 62: Solve Orderand Formula Collision 1/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.

Figure 63: Solve Orderand Formula Collision 2/2

第 60 页 / 共 237 页

Unit2: CreatingApplications,IntroductiontoLogicandLoadingofTransaction

Data BPC310

Theupperslideshowstheeffectsofsolve_orderiftheorderisconvertedcompared

to the example of the last slide.

Figure 64: The Library File

You can type MDX syntax expressions directly into the Formulacell 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.

第 61 页 / 共 237 页

BPC310 Lesson: Introduction to Logic

Figure 65: Assigning the Library File

YoucanincludelibraryfilesontheOptionssheetoftheaccountdimensionusing

the *syslib command.

ApShellincludesthesystemfunctionsinfileMdxlib.LGL.

Figure 66: Mdxlib.LGL Example

AmajorityoftheMDXfunctionsdefineindustry-standardfinancialratios.

You can use ratios to evaluate the performance of your business and identify

potential problems.