SAP BI

Data Warehouse is setup based on reporting requirements of business users. Hence, Reporting is a crucial functionality of any data warehousing solution. SAP BW provides easy to use graphical functionality named Business Explorer (BEx) to create and execute queries to retrieve data from InfoProviders e.g. InfoCubes, Operational Data Store etc.. Business Users can directly execute the pre-defined queries whenever they want to get the information available in business warehouse. We will see how to execute a already defined BEx query in this section. 1) Go to 'Start', select 'Business Explorer', select 'Analyzer' 2) Following bar will appear with Microsoft Excel 3) Open the query to be executed and press 'Refresh' button (3rd from left in the above bar) 4) Following window will appear with system to be connected, select the system (system details from the below screen are earsed) 5) Enter user id and password to connect to SAP system 6) Based on query defini

Source System is the system from where data is extracted and stored in data warehouse . Following are the steps to Define a Source System in SAP BW 1) Execute transaction RSA1 2) Select Source System as shown below and right click to create 3) Select Source System Type as shown below. In this example, we are creating a source system for a flat file. Using this, we can load a .csv file to an infocube Similarly, a SAP R/3 or SAP BW system can be defined as source system. Server id, system id, background user, clients are some of the information required to define SAP source system. 4) Enter a name and description for source system 5) Source system is created as shown

Operational Data Store (ODS) using SAP BW 3.5 ODS consists of 'Key fields' and 'Data fields'. Data fields can also contain characteristics e.g. customer, product etc.. ODS is not used for multi-dimensional analysis like Infocube . The data from ODS can be updated with delta update into a Infocube. The data in ODS is stored in a transparent table. There is no fact or dimensional table created for ODS. Following are the steps to create an ODS: 1) Execute transaction RSA1, select the InfoArea under which you would like to create ODS. Right click the InfoArea, select 'Create ODS Object' 2) Enter ODS Object 'Name' and 'Description', press 'Create' 3) Check the box against 'BEx Reporting' to enable ODS for BEx reporting, press 'InfoObject Catalog' button to get the InfoObjects which you would like to add to ODS 4) Select the characteristics (InfoObjects) which you would like to add as 'Key fields' or 'Data fields

Data Sources are extraction structure. Data Sources are used to extract data from various source system. In the below steps, we will see how to create a data source using a SAP table VBAK. 1) Execute transaction RSO2 2) Enter data source name to be created 3) Press Create 4) Enter description of the data source 5) Enter the name of table or view on which data source has to be created. Data Source can also be created using a View, Info set or a Function Module. 6) Save the data source 7) Execute RSO2 again and click Change 8) Select VBELN field as selection 9) Save the Data Source 11) To check whether data is getting extracted, execute transaction RSA3 12) Enter the name of data source as shown below and press 'Extraction' 13) An information message will appear stating no. of records fetched 14) Additional button 'Display list' will appear, press button 15) Select one of the data packet and double click to get records fetched 16) Data Source is ready to be used!