SAP BI BW Classroom Training and Certification Classes

• Data Warehouse: Integrating, collecting and managing entire companys data
• Analyzing and Planning: Using the data stored in data warehouse
• Reporting: BI provides the tools for reporting in web-browser, excel etc.
• Broad cast publishing:  To send the information to the employees using email, fax etc.
• Performance: Performance of the company
• Security: Securing the access like using SAP logon tickets from portal

Data integrity is the process to eliminate duplicate entries in the database.

Table partition helps to manage the large amount of data which improves the efficiency of the application.

Database partitioning and Logical partitioning

In BW/BI, data flows from a transactional system to the analytical system. On the transactional system, data service replicates on BW side and gets attached to info-source and update rule.

‘Operational Data Store’ or ‘ODS’ is used for detailed storage of data. It is a BW architectural component that appears between PSA (Persistent Staging Area) and infocubes, it allows BEX (Business Explorer) reporting. It is primarily used for detail reporting

‘Infocube’ is structured as the star schema and it is a data storage area.

Info cubes contain two tables, E table and F (fact table).

Extractor is defined as extracting data from the system program. The different types of extractors are:

• Application Specific:  BW content FI, HR, CO, SAP CRM, LO cockpit
• Customer-Generated Extractors:  LIS, FI-SL, CO-PA
• Cross Application (Generic Extractors): DB View, Infoset, Function Module

There are 4 types – CHAR, NUMC, DATS and TIMS

• LISTCUBE: List viewer for InfoCubes
• LISTSCHEMA: Show InfoCube schema
• RSDCUBE, RSDCUBED, RSDCUBEM: Start InfoCube editing

The maximum number of key figures is 233 and characteristics are 248.

Data target administration task includes

• Delete Index
• Generate Index
• Construct database statistics
• Complete deletion of data target
• Compression of the info-cube etc.