data warehouse sap bex bex analyzer0

《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