SAP BI BEx Query Designer
This course teaches you how to use the BEx Query Designer for SAP's Business Information (aka Business Warehouse) system. This course is a basic requirement for anyone working with queries or creating reports in BI.Audience
- Consultants
- End users
- IT/Business analysts
- Project team members
Prerequisites
Critical Prerequisites
- SAP BI BEx Analyzer (BI101)
- Basic SAP Skills (SAP101)
- Basic SAP Reporting Skills (SAP110)
- Intermediate SAP Reporting Skills (SAP115)
- A general understanding of SAP terms
- Intermediate SAP Skills (SAP102)
Course Content:
- Introduction to BEx Query Designer
- Infoproviders
- Query-level restrictions
- Using existing variables
- Rows, columns and free characteristics
- Custom formulas
- Exceptions
- Conditions
- Selection-level restrictions
- Variable selections and text variables
- Multiple structures and nested selections
- Building hierarchies
- Hierarchies in BEx Query Designer
EmoticonEmoticon