======================================================================================================================
BEx query fundamentals:
Topics:
• Introduction to Business Explorer
• Fundamental Components
• How to create a dashboard based off BEx query
• Useful Knowledge Base Articles
======================================================================================================================
Introduction to Business Explorer (BEx):
• Reporting tool used to work with data in the BW database.
• Provides an organized interface where a user can access and work with any type of document assigned to them in the Business Information Warehouse.
======================================================================================================================
Fundamental Components:
1. Key Figures
2. Dimensions
3. Characteristics
4. Free Characteristics
5. Attributes
6. Filters
======================================================================================================================
1: Key Figures
======================================================================================================================
2: Dimensions
======================================================================================================================
3: Characteristics
======================================================================================================================
4: Free Characteristics
======================================================================================================================
5: Attributes
For example, Anniversary Date and Ethnic Origin are attributes of the Employee Characteristic.
======================================================================================================================
6: Filters
======================================================================================================================
How to create a dashboard based off BEx query:
Refer to following document written by Tammy Powlas: http://scn.sap.com/docs/DOC-31012
======================================================================================================================
Useful Knowledge Base Articles:
1809653 - Dashboard Design 4.0 SP5 - Cannot Select Bex queries when creating new Dashboard if BICS connection language is different
than english
1711564 - Unable to connect to a BEx variable as a source prompt in Dashboard Design. The 1st variable is grayed out.
1769293 - BI4 : Dashboard Design BICS 'Connect to Spreadsheet' options are grayed out when setting key date prompt in BW and prompt at query level
1804169 - XLS 000009 error happens when refreshing Dashboards when it contains Bex query data source and it will return no data after refreshing
1789906 - Unable to manually enter or search a BICS based List of Values in Web Intelligence member selector by value
1767983 - Performance Issues with bex Hierarchy nodes in Dashboard Design
1837977 - How to promote a dashboard based on BEx query using Promotion Management
======================================================================================================================
Hope this helps and makes you clear with basics of BEx queries and using them with Dashboards.
Regards,
Tejas Tamhane
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
5 | |
5 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 | |
3 | |
3 |