To upload Sales Order data from SAP R/3 to BI using generic DataSources
Integrating SAP data (R/3 or BW Data) with the BO-Xcelsius (Business Objects) using BSP

1. SAP BSP + BO-Xcelsius (Excel XML Maps Connection)
2. SAP BSP + BO-Xcelsius (web Service Connection)
3. SAP BSP + BO-Xcelsius (XML Data Connection)

Integrating BO-Xcelsius (SWF) file with BO-Crystal Reports

Download the BIW - Samples (515)

When the data source is not readily available in the Business content. Even if the Business content data source is available and it is already being used up and if we want to simulate the same kind of extractor, we can go for generic extraction.

The T-code for creating Generic Extraction is RSO2.

We can create 3 types of data sources using generic extraction

1. Transaction data
2. Master data attribute
3. Text

We can generate generic datasource using the following

1. Table
2. View
3. Function module
4. Infoset Query

Download the Document with Screen Shots (2037) on working with Generic Extractions in BI.

SAP BI Overview contains overview about:

1. Difference between OLAP and OLTP
2. Layout/steps in SAP BW
3. ER-Model (Entity Relationship model)
4. Designing DB
   1. Object Oriented
   2. Normalization
5. DB concepts in OLTP
   1. Star Schema (traditional schema)
   2. Extended Star Schema (BW schema)
   3. Snow Flake scheme
   4. Hybrid schema
6. Information about the first screen for BW

Download the document on SAP Business Intelligence overview (1808)

SAP Business Information Warehouse (SAP BW) is based on the SAP Web Application Server (SAP WAS). Therefore also consult the security information for SAP WAS. This guide only describes additional or anomalous security information. SAP BW can be implemented together with other SAP NetWeaver components. If, for example, you are implementing integration with SAP Enterprise Portal, also consult the security information for these components. BI Content 3.5.1 Add-On is delivered in parallel to SAP BW 3.5. This contains reporting scenarios and pre-defined role and task-related information models that are based on consistent metadata.

SAP BW serves to integrate, transform, and consolidate data from all areas of an enterprise in order to provide this for analysis and interpretation. This includes confidential corporate data, for example, personal data from Personnel Administration. Decisions are made in all enterprise areas and target-oriented actions are determined on the basis of this data. For this reason, security when accessing data and the ability to guarantee data integrity is of great importance in SAP BW.
The following examples show the dangers to which SAP BW can be exposed:

• Attacks from the Internet or Intranet when using BEx Web functionality and Web Services
• Infringement of data protection guidelines through unauthorized access to personal data

View/download the PDF document on SAP BIW Security.

Create SID for 0SalesEmply
Data Flow for ODS
Delete bad request from data target and reran request
Errors to be turned to green
Historical DataLoad (Flat Files)
How to  activate and fill aggregates
How to  change the owner of a job
Continue Reading …