文本mcs用戶培訓(xùn)

CourseObjectivesCourseContentThiscoursewillenableyouUnderstandthearchitectureofSAPBWsystemandthebasicfunctionalities.Beabletoinstallfrontendsoftware,setupreportingexecutionenvironment.Understandtheprocessofsupportandsubmittingnewrequirements.Unit1 SAPBWOverviewUnit2 SetupEnvironmentUnit3 AccessBWSystemUnit4 WorkwithReport

Unit SubmitNewYouuseBWreportstoanalyzedailysales.YourmainfocusismonitoringsalesYousetupreportingsystemenvironment,andexecuteBusinessExplorertosummarizethedailysales.Youwanttoanalyzethedatawithdifferentdimension,andfordifferentkeyfigures.TheresultwouldbesummarizedbyspecifiedYouhavenewrequirements,andwantthemtobeimplementedinBWsystem.Unit1 SAPBWOverviewUnit2 SetupEnvironmentUnit3 AccessBWSystemUnit4 WorkwithReport

Unit SubmitNewBusinessAttheconclusionofthisunit,youwillbeableUnderstandthearchitectureofSAPBWsystemandthebasicfunctionalitiesofBWreporting.SAPBI–TheSolutionataoftheentireenterpriseregardlessofdatasourcesofaccessmethods

Dataacquisition,datawarehousing,OLAP,planningframework,BItools,dashboardsandanalyticalapplications;withpre-configuredcontentusingbest-practicemodels.SAPBusinessIntelligenceisanenterprise-class,complete,openandintegratedsolutionthatOpen,welldocumentedAPIsandinterfacesalongwithfullfunctionalitytointegratestructuredandheterogeneousdata

Convertdataintoinformation,andensureinformationisdeliveredattherighttimetotherightpersonintherightformattosupportbusinessdecisionmaking.

ScalableandreliableBIsolutionthatistightlyintegratedwithSAPNetweaver,sourcetransactionalsystemsandSAPBISAPBIKey Business

BIBIBI

CommonRead/CommonRead/WriteData

Drill-Down,Drill-Through,Drill-OpenInterfaceOpenInterfaceandWebUSERWhatSliceandGalleryofready-to-/Table,AlertData

ContextData BI BIDataWarehousingBIPlatformBIDataDataItsupportsthecompleteprocessfromdataload,transformation,dataintegration,consolidationandcleansingtodataprovisionforanalysisandinterpretationofconsistentinformation.Includesthefollowingareas:Extraction,TransformationandOpenforanyFlexiblesetofETLIntegrationonapplicationOpentothird-partySupportofopen…togetacompleteviewofyourTheTheinformationmodelofSAPIntegratedflowofRichtransformationFlexibleandnon-redundantdataDataAgingStrategies:ADK-basedarchivingandnear-linestoragewith…tomodeltheOperationalDataStoreandDataWarehouseDataNonHistoricalBuiltwithODS

OperationalDataOperationalNearReal-Time/BuiltwithODS

MultidimensionalMultidimensionalAggregatedBuiltwith...toprovidetherightinformationforallSAP‘sDataAquisitionBWServiceAPIfor SAPLegacy

Non

BWBWLoad

TransformationwithinBWdataConditionDateCurrencyBWProcessAutomatingtheBWGraphicalmodellingandmonitoringOpennessforallkindsofprocessesOpenHubService-ControlleddistributionofconsistentdataTarget:fileorDBCentralSelectfiltercriteriaandFullordeltaWarehouseCentralandcompleteMetadatarepository:businessandtechnicalmetadataOpenHubService:DatafromODS-ObjectandInfoCubecanbedistributed;full&delta,monitoring&schedulingTransparencyacrossallobjectsAutomationofwarehousemanagement…tostore,update,maintainandaggregateinformationaccordingtoyourneedsBIBIServesasthetechnologicalinfrastructuretosupportinformationaccessandcomprehensiveanalytics.Itincludesthefollowingareas:OLAPBusinessCreationofcomplexformulas,downtocelllevelUsageofconditionsandexceptionsinMulti-currencyFlexiblehierarchyNon-cumulativekeyfigurestoanalyzedatafrominventorymanagementEliminationofinternalbusinessMarketshareSlowmoving..

CentraldisplayofGraphicalHTMLDownloadXMLMetadataData

BehaviorDecisionAssociationValueCustomerLifetimeValue(CLV)RecencyFrequencyMonetaryValue(RFM)...todetectstructuresandAnalysisProcessData(availablethroughallSAPBWstoragemedia)canbeexploredwithinamultilevelprocess,applyingadvancedanalyticalmethodsinordertogainnewinsightsfromthesedata.TheanalyticalresultsarepersistedagainwithinSAPBW.…FeatureInteractivemodeling(drag&drop)workbenchforanalysisInfrastructuretolinkupprocesselements,beingsources(selectionofdata),targets(deploymentofresults),pre-processing(transformation)andvisualizationtoolsaswellasdataanalysismethods.AnalysisofdataateverystepoftheanalysismySAPBI–Planning&Simulation:BW-BusinessPlanning&SimulationinSAPPlanning&SimulationResearch/TargetBenefitsofofferingBW-BPSwithSAPBWNoinstallationofSAPSEMAdd-OnnecessaryforusageofplanningOnesoftwareinstallationOnesupportpackageOneprojectbudgetforplanningandBIItprovidesacomprehensivesetoftoolssuchasquery,reportingandmulti-dimensional(OLAP)analysestosupportcollaborativedecision-makingforanalysts,executivesandinformationconsumer.Itincludesthefollowingareas:mySAPBI-ForAllUserAuthorsand...needadvancedanalysisfunctionalityandad-hocdataexplorationcapabilities...requirepersonalizedinformationincontextviaanintuitiveuserinterface...wantpredefinedanalysispathsandtheoptionofin-depthanalysisofsummarydata....needasnapshotofaparticulardatasettoperformtheiroperationaltasks...donotinteractextensivelywiththemySAPBIallowsUserstoEasilyaccessandexploreAnalyzethatLeadstoimprovedandLeadstoimprovedandinformeddecisionsatallOptimizeorganizationandbusinessEnablecollaborationontrendsandCapitalizeonmarketandbusinessManagebusinessandstrategytowardsEnsureindividualOptimizeinteractionswithcustomersandDrivesuccesswithinmySAPSupportforbusinessdecisionsatallOperational,tacticalorReady-to-starttemplateswithpredefinedFromstatic,managedreportstohighlyinteractiveanalysisapplicationsDesktoporweb-Forquerydesign,reportingandWebapplicationFastdeploymentofpersonalizedIntegrationintotheEnterpriseRoleandbusinessprocessspecificUserAccess:anytime,AnalyzeinformationwithinawebOnanydevice(PCorBusinessExplorer:Query,Analysis&BExQuery,Reporting&QuickandeasydesignofinteractivequeriesforanalysisandreportingAnalysis&ReportingviaWeborembeddedintoMSExcelOnlyFilterandColumnSectionintabularmodeOLTP/ExternalDataOneDesignTool-OLTP/ExternalDataAunifiedviewfromanintegrateddataSummarizedtolineODSBISuiteMultipleDataFlexibilityinODSBISuiteMultipleDataInteractiveAnalyzedifferentaspectsoftheMulti-dimensionalGenericnavigationandinteraction(sliceanddice,drill-down,drill-thru,pivoting,...)HierarchyGlobal,enterprise-wideMulti-language,multi-IntelligentAlerting(traffic

Web-based(PCorWindows-basedviaBusinessExplorerAnalyzerOLAPanalysisinMSIntegrationpointforqueryandwebapplicationdesignLeveragenativeExcelfeatures(i.e.officeintegration)Tightintegrationofweb-andMSExcel-basedanalysisBexReportWebApplicationScheduledorimmediateWebTemplates,ScheduledorimmediateWebTemplates,ExcelExcelWebforPDAs)IntegrationwithShareandanalyzebusinessinformationAnalyticsinPersonalizedinformationanddecisionsupportforallUnit1 SAPBWOverviewUnit2 SetupEnvironmentUnit3 AccessBWSystemUnit4 WorkwithReport

Unit SubmitNewBusinessSetupReportingAttheconclusionofthisunit,youwillbeableGettoknowtheminimumsystemrequirementsforexecutingBWreport.Befamiliarwithinstallationstepsforsettingupsystemenvironment.BusinessYouaregoingtoaccessBWsystemandexecutingrequiredsalesreportwithBWBusinessExplorer.Youhavealreadybeenguaranteedtheauthorizationforexecutingthereport.BWSystemProvideECCECCFI/CO,SAP46CTMS,Plant,TMS,Plant,ExternalFile,

SAPBWDOA,etc

DataCenterDatabaseTableBWReportAccessReportUserReportUserReportReportUser

ReportUser

InternalOtherSystem:InternalLegacyBWisacentralinstanceinLenovosystemlandscape,AllreportUsersaccessthesameBWsystem.BWcontrolscomplicatedaccessmechanism,inaccordancewithERP,CRM,Portal.TwoAccessSupportfullreportanalysisSupportallfunctionalitiesofMicrosoftExcelInterfaceisfamiliartoend-NeedsspecialfrontendSupportInternetNoadditionalsoftwareisOnlypartofanalysisfunctionalitiesavailableFrontEndHardwareFreeHDNote:SAPGUInormallyuses146MBmemoryinWindowsXP,Whiletheoperatingsystemuses137MB,so283MBmemorywillbeusedwhenSAPGUIisexecuted.Whichmeans256MBisacceptable,buttheperformancewillbeaffected.FrontEndBasicSoftwareWIN2Kor.NETEnvironmentOFFICE2002(xp)orSAPGUIwithBusinessExplorerAdditionalSupportPackageSAPnotes:

NetFrameworkversion1.1istheprerequisiteofBusinessExplorer(SAPNW2004s).ItcanbefreelydownloadedfromMicrosoftWebsite.FirefoxisnotInstallationFileAlltheinstallationfilesareavailableviaPublicFolder: 上海廠：\\shcshare\聯(lián)想共享軟件\業(yè)務(wù)專用軟件\BW上海分部：\\shshare\聯(lián)想共享軟件\業(yè)務(wù)專用軟件\BW西北分區(qū)：\\0\應(yīng)用軟件\業(yè)務(wù)專用\bwInstallationStep:1–Install.NETHardwarerequirementsareWindows2KorMicrosoftOfficeExecutefileInstallationStep:2–InstallLanguageExecutefileInstallationStep3–Install.NETInstallationStep4–InstallSAPInstallSAPGUIbyexecutingUpdateUpdateifSAPGUIalreadySelectBI-relatedInstallationStep5–InstallFrontendInstallationStep-Execute1_DOTNETFX.EXEandrestart(BWquerydesignerwillusethiscomponent)Execute2_LANGPACK.exeforlanguagepackageExecute3_NDP1.1sp1-KB867460-X86andrestartinstallingSAPGUI,selectBI-relatedcomponentsExecuteBW700SP11_1100-10001615.EXEforBWfrontendStartMenuforBusinessPostInstallation–EnableMacromustbeenabledinMSSetupSAPLogon–tobeBGPmustbedefinedinSAPMandatoryIPAddressforApplicationServerSystemIdentificationUninstallSAPTouninstallSAPGUI,accesscontrolYoucanalsouninstall.NetFrameworkhereYoucanexecuteBWreportviaBexandLocalPCmusthavesufficienthardwareconfigurationtoexecuteBWreportAdditionalconfigurationstoMSExcelandSAPExercise:SetupsystemUnit1 SAPBWOverviewUnit2 SetupEnvironmentUnit3 AccessBWSystemUnit4 WorkwithReport

Unit SubmitNewBusinessAttheconclusionofthisunit,youwillbeableGettoknowhowtoaccessauthorizedBWreportviaBexMacroisenabledinMSExcelProcedureofMacroisenabledinMSExcelYoumustlogintoBWsystemtoexecutereportOnlyauthorizedreportsarevisible,theyaregroupbymenuAuthorizationandmenuaremaintainedinBWsystemOpenOpenAccessthemenuby:Start=>ProgramWhentheAnalyzerisexecuted,youcanenterMSExcelenvironment.AndBWtoolbarIfBWtoolbarisnotavailable,firstcheckwhetherMacroisenabled.Orit’stheproblemofsysteminstallation,forthesecondcase,uninstallthesystemandreinstallChoosemenu‘Open‘OpenWorkbook’opensworkbookthathaspredefinedreportformatandselectioncriteria,e.g.customizedquery.Whenyouopenaquery,youarepromptedtologonintoBWYoucanusethesystemyoudefinedinSAPlogon.Logondialogueonlypopsupifyouarenotloggedon.Youdon’thavetodologonifyouareconnectedwithBWsystem.ClickTips:Select‘UseselectedSystemasDefault’,thesystemwillautomaticallyusethesystemasdefaultnexttime,soyoudon’thavetoselectsystemeverytime.Asaresult,thisdialoguewon’tappearanymore.UserZH=EN=ClickPleaseconsultBWsystemadministratorifyoudon’tknowthelogonInformation,forexample,clientnumber.It’spossibletochangepassword,selectanothersystemwithinthisReconnectto

Youcanuse‘SystemInformation’buttontodisconnectandconnectBWAlltheauthorizedYoucandoubleclickacertainmenuandfindtherightreporttobeToexecuteadditionalreport,youmustsubmitrequesttoapplynewEnterselectioncriteriaintheselectionscreenClick‘OK’toexecutethereportSelectfromalistDisplayattributesPersonalizationGettoknowtheprocedureofexecutingBWExercise:ExecuteanauthorizedUnit1 SAPBWOverviewUnit2 SetupEnvironmentUnit3 AccessBWSystemUnit4 WorkwithReport

Unit SubmitNewBusinessAttheconclusionofthisunit,youwillbeableSummarizethemainfunctionalitiesforreportBeabletousetheanalysisfunctionalitiesinBextoimprovereportanalysisperformanceBExAnalyzerBExAnalyzerisananalytical,reporting,anddesigntoolembeddedinMicrosoftExcelto:AccessInfoProviderdata,Query,QueryViewandAnalyzethedatabynavigatingReportLayoutDisplayAttributeQueryPropertyOpenBExAnalyzerBW

Pressrightmousebuttonwithineachareawillcallupdifferentcontextmenu–differentfunctionalitymatrix!!!BWGlobalApplicationHelp

Thistoolbarisusedforcreatingworkbookwithadvancedtechnique,theworkbookenablescontrolsthatcanprovidefriendlyuserNavigationYoucanaccessallbasicfunctionalitiesinthispanewithrightmousebuttonSet/RemoveSet/RemoveSetpropertiesfordimensionorMove/Swapcolumn/rowReportMainBack(toStart)-RestoreSet/RemoveFilterSet/RemoveDrilldownExchangecolumn/rowSwapcolumn/rowSortbykeyortextSetattributesfordimensionorCallCallAnalyzerFunctionalitiesviarightmousebuttonFilterI–SelectionThevaluesareusedtofilterreportTwoaccessVia‘OpenVia‘ChangeVariableValue’buttoninBWValueFilterII–ViaValueCallcontextmenuonthecharacteristicyouwanttosetthefilterFilterIII–ReportCallcontextmenuonthecharacteristicyouwanttosetthefilter

KeepFilter->Usethecurrentvalueas->SameasNavigationFiltercanberemovedwithmenuitem‘RemoveNavigationReportYoucanalsosortthereportbykeyWhenthereportisexecuted,onlyafewofdimensionisdisplayed,whileothersarehidden.Drilldowncanshowadditionalcharacteristictothereportsothatyoucanana