✒️SAP BI / BW BO BEx Analyzer
SAP BI / BW BO BEx Analyzer
BEx Analyzer is an analytical, reporting and design tool embedded in Microsoft Excel. In BEx Analyzer, you can analyze and plan with selected InfoProvider data using the context menu or drag and drop to navigate in queries created in BEx Query Designer.
You can design the interfaces for your queries by inserting design items (controls) such as analysis grids, dropdown boxes and buttons into your Excel workbook. This allows you to transform your workbook into a query application.
FeaturesBEx Analyzer’s functionality is divided into two modes, each with a dedicated toolbar and menu path:
%u25CF Analysis mode – for executing OLAP analyses on queries
%u25CF Design mode – for designing the interface for query applications
Analysis ModeWorking in analysis mode, you can accomplish the following types of tasks:
%u25CF Launch BEx Query Designer in order to define queries
%u25CF Analyze selected InfoProvider data by navigating interactively within these queries
%u25CF Navigate and analyze using the context menu or drag and drop
%u25CF Use OLAP functions like filtering, drilling and sorting
%u25CF Use planning functions
%u25CF Precalculate and distribute workbooks with BEx Broadcaster
%u25CF For advanced programming capabilities, embed your own customized VBA programs (Visual Basic for Applications)
%u25CF Save workbooks in your favorites or in your role on the server, or locally on your computer
You can access analysis mode from either the dedicated analysis toolbar or from the menu in BEx Analyzer.
See also:
Analysis Mode
Design ModeWorking in design mode, you can accomplish the following types of tasks:
%u25CF Design the interface for your queries by embedding design items such as the analysis grid, dropdown boxes, radio button groups, and buttons into your Microsoft Excel workbook
%u25CF Customize your workbook with Excel’s formatting and chart functionality
You can access design mode from either the dedicated design toolbar or the menu in BEx Analyzer.
 
 
 
Sobre el autor
Publicación académica de Juan Manuel Cardozo Pulido, en su ámbito de estudios para la Carrera Consultor en SAP BI / BW BO.
Juan Manuel Cardozo Pulido
Profesión: Ingeniero Electronico - Colombia - Legajo: JB99Q
✒️Autor de: 9 Publicaciones Académicas
🎓Egresado del módulo:
Certificación Académica de Juan Cardozo