Integrating Profile Generator and BEx Browser
In Chapter 5, we learned that BEx Browser is a workbook organizer. To display query results, we use the BEx Analyzer. With Profile Generator, BEx Browser can truly serve as an information center for organizing all kinds of information resources in one place. The following procedure shows how to access a Web site and run an R/3 transaction from BEx Browser.
Work Instructions
Step 1. Open the role R_RUN_QUERIES that was created in Section 6.1. Click the Menu tab.
SCREEN 6.43
Step 2. Click 
to create a new folder under Role menu.
SCREEN 6.44
Step 3. Enter a folder name, and then click 
to continue.
SCREEN 6.45
Step 4. Repeat Steps 2 and 3 to create two more folders. The names of the new folders are shown in Screen 6.46.
To add a Web address to a folder, select the Web Sites folder, and then click 
.
SCREEN 6.46
Step 5. Select the option Web address or file, and then click to continue.
SCREEN 6.47
Step 6. Enter your text and a Web address beginning with http://, and then click to continue.
SCREEN 6.48
Step 7. To define an R/3 transaction that we can launch from BEx Browser, select a folder, and then click 
to add the transaction code.
SCREEN 6.49
Note
To run the R/3 transaction, we need to provide an RFC (Remote Function Call) destination in the Target System field. This RFC destination defines the R/3 system as a trusting system. That is, the R/3 system trusts the BW system, and selected BW users can run certain transactions or programs in the R/3 system without providing passwords.
Step 8. Enter a transaction code, and then click 
.
SCREEN 6.50
Step 9. Besides transactions, we can include R/3 reports. To do so, select a folder, and then click 
.
SCREEN 6.51
Step 10. The pop-up window shows the type of reports we can include. In this example, we do not include any reports. Click 
to cancel the operation and go back to the previous screen.
SCREEN 6.52
Step 11. Click 
to update the user master data, and notice that all of the tab status lights are now green.
SCREEN 6.53
Result
Users with the R_RUN_QUERIES role can run the R/3 transaction SM50 and access the Web site www.awl.com.
Open BEx Browser and log on as U_EAST, then click folder Role demo: run queries in the left panel. You will see Screen 6.54.
SCREEN 6.54
Double-click the Work Process Overview icon. The BEx Browser opens an R/3 session. The session displays the result of transaction SM50 (Screen 6.55).
SCREEN 6.55
Double-click the awl.com icon, and BEx Browser opens the www.awl.com Web page using the default Web browser, Internet Explorer (Screen 6.56).
SCREEN 6.56
Part I. Guided Tours
Business Scenario and SAP BW
- Business Scenario and SAP BW
- Sales Analysis A Business Scenario
- Basic Concept of Data Warehousing
- BW An SAP Data Warehousing Solution
- Summary
Creating an InfoCube
- Creating an InfoCube
- Creating an InfoArea
- Creating InfoObject Catalogs
- Creating InfoObjects Characteristics
- Creating InfoObjects Key Figures
- Creating an InfoCube
- Summary
Loading Data into the InfoCube
- Loading Data into the InfoCube
- Creating a Source System
- Creating an Application Component
- Creating an InfoSource for Characteristic Data
- Creating InfoPackages to Load Characteristic Data
- Checking Loaded Characteristic Data
- Entering the Master Data, Text, and Hierarchy Manually
- Creating an InfoSource for Transaction Data
- Creating Update Rules for the InfoCube
- Create an InfoPackage to Load Transaction Data
- Summary
Checking Data Quality
- Checking Data Quality
- Checking InfoCube Contents
- Using BW Monitor
- Using the Persistent Staging Area (PSA)
- Summary
Creating Queries and Workbooks
- Creating Queries and Workbooks
- Creating a Query Using BEx Analyzer
- Organizing Workbooks Using BEx Browser
- Using a Variable to Access a Hierarchy Node Directly
- Summary
Managing User Authorization
- Managing User Authorization
- Creating an Authorization Profile Using Profile Generator
- Creating an Authorization Object to Control User Access to the InfoCube Data
- Integrating Profile Generator and BEx Browser
- Summary
Part II. Advanced Topics
InfoCube Design
- InfoCube Design
- BW Star Schema
- InfoCube Design Alternative I Time-Dependent Navigational Attributes
- InfoCube Design Alternative II-Dimension Characteristics
- InfoCube Design Alternative III Time-Dependent Entire Hierarchies
- Other InfoCube Design Techniques
- Summary
Aggregates and Multi-Cubes
Operational Data Store (ODS)
- Operational Data Store (ODS)
- Creating an ODS Object
- Preparing to Load Data into the ODS Object, Then into an InfoCube
- Loading Data into the ODS Object
- Loading Data into the InfoCube
- Using 0RECORDMODE for Delta Load
- Summary
Business Content
- Business Content
- Creating an R/3 Source System
- Transferring R/3 Global Settings
- Replicating R/3 DataSources
- Installing Business Content Objects and Loading R/3 Data
- Summary
Generic R/3 Data Extraction
- Generic R/3 Data Extraction
- Creating Views in R/3
- Creating DataSources in R/3 and Replicating Them to BW
- Creating a Characteristic in BW
- Loading Data from R/3 into BW
- Summary
Data Maintenance
Performance Tuning
- Performance Tuning
- BW Statistics
- System Administration Assistant
- Tuning Query Performance
- Tuning Load Performance
- Summary
Object Transport
Appendix A. BW Implementation Methodology
Object Transport
Appendix B. SAP Basis Overview
Object Transport
- Object Transport
- Section B.1. SAP Basis 3-Tier Architecture
- Section B.2. Dispatcher, Work Processes, and Services
- Section B.3. Memory Management
Appendix C. Glossary
Appendix D. Bibliography
EAN: N/A
Pages: 106
