欢迎来到天天文库
浏览记录
ID:7283082
大小:1.32 MB
页数:33页
时间:2018-02-10
《data warehouse sap bex bex analyzer0》由会员上传分享,免费在线阅读,更多相关内容在工程资料-天天文库。
1、SAPBusinessIntelligenceModule1BExAnalyzer–Reporting&AnalysisVersion1Module1SAPBusinessExplorerComponents•TransformingDataintoInformationWebApplicationWebPortalsOLAPReportsOLAPReportsDesignerSAPBWBExQueryInfoProvidersDesignerExcelBasedBExAnalyzerOLAPReportsOLAPReportsOLAPReportsPage2Vers
2、ion1Module1SAPBExAnalyzer•SAPBExAnalyzerprovidesad-hocanalysisusinganExceladd-in•BExAnalyzerrunsqueries(report)createdwiththeBexQueryDesigner•BExAnalyzerprovidessliceanddicecapabilitieslike…SelectingVariableValuesBExAnalyzerSelectingDataFiltersViewingDatainaChartPage3Version1Module1SAPB
3、ExLogin•OpensinanExcelenvironmentandthenconnectstoSAPBWPage4Version1Module1SAPBExAnalyzerCapabilities•SAPBExAnalyzerfunctioningwithinExcelprovidestheabilityto…1.Executeaquery2.IdentifyauserandtheirroleintheBWsystem3.Confirmsauser’squeryrights(authorization)4.Providetheabilitytosearchfor
4、aqueryby•Userrole•InfoArea(applicationareasuchasFinance,Sales,etc)•History(recentlyused)•Technicalnameordescription5.PerformOLAPanalysisonquerieddataPage5Version1Module1OpeningaQueryPage6Version1Module1OpenQueryDialogQueriesmaybeaccessedby-Findtool(searchname/description)-History(recent
5、lyused)-Favorites-UserRoles-InfoAreasPage7Version1Module1QuerySearchbyNamePage8Version1Module1HistoricalQueryListPage9Version1Module1FavoriteQueriesPage10Version1Module1UserRolesPage11Version1Module1SearchbyInfoAreaPage12Version1Module1BExAnalyzerafterQueryExecutionDisplayaChartExcelWor
6、kbookFilterValuesRowsandColumnsPage13Version1Module1BExAnalysisToolbarFunctionsOpenQuerySaveWorkbookRefreshVariablesSwitchToolsGlobalSettingsBWConnectHelpPage14Version1Module1InformationAnalysisusingBExAnalyzer•InformationanalysisfunctionsperformingOLAPanalysis1.Filtering(slicinganddici
7、ng)•Applyonefiltertocreatea“slice”ofdata.Example:Revenueincountry“USA”only(Slicing)•Applyafilterinmorethanonedimension.Example:Revenueincountry“USA”onlyandinmaterialgroup“MountainBikes”only(Dicing)2.DrillDownandRollUp•Displaymoredetailedinformation(oppositeofroll-up).Example:Re
此文档下载收益归作者所有