This Section covers various interview questions related to SAP BW. Updated regularly..keep browsing

One of the hardest tasks in developing a reporting environment in R/3 is selecting one data access and analysis tool that satisfies end-user needs. The following are the major shortfalls of native SAP R/3 reporting:

A common feature among R/3 reporting systems is that they all collect data in special data tables. This is a preferred method for operational reporting due to real-time data acquisition from linked SAP modules. Several reporting systems derive data based on update rules.

External data can also be imported in the reporting information structures for consolidated information view.

• Quality Management Information System (QMIS)
• Retail Information System (RIS)
• Warehouse Management Information System (WMIS)
• Transportation Information System (TIS)

Under the LIS environment, several predefined database tables enable customers to quickly develop reports. The following describes how LIS reporting systems work.

SAP offers a collection of more than 2,000 powerful and flexible business reports in R/3. These reports are spread across all application modules. Navigating through several information systems to find specific reports is a huge challenge. SAP also provides several reporting tools in R/3 to build queries and reports against operational data.

Evolution of SAP Business Information Warehouse

A Quick Look at SAP R/3 Architecture and Technologies

Founded in 1972 in Mannheim, Germany, as Systemanalyse und Programmen-twicklung to produce and market standard software for integrated business solutions, today that company is known as SAP (Systems, Applications and Products in Data Processing), headquartered in Walldorf, Germany. SAP built packaged applications for mainframe computers, called SAP R/2. As the client/server technologies emerged in the early 1980s, SAP launched a major initiative to engineer powerful three-tiered integrated business applications under one framework. The SAP R/3 product is the outcome of that initiative.

Aggregate

An aggregate is a subset of an InfoCube. The objective when using aggregates is to reduce I/O volume. The BW OLAP processor selects an appropriate aggregate during a query run or a navigation step. If no appropriate aggregate exists, the BW OLAP processor retrieves data from the original InfoCube instead.

Aggregate rollup

Aggregate rollup is a procedure to update aggregates with new data loads.

Application component

Application components are used to organize InfoSources. They are similar to the InfoAreas used with InfoCubes. The maximum number of characters allowed for the technical name is 32.

Some list of popular CRM Vendors

• Microsoft Dynamics CRM 3.0
• SAP Business One CRM
• Onyx Software CRM
• Oracle/Siebel
• Amdocs
• Oncontact V
• Pivotal CRM
• Sage CRM Solutions
• e-Synergy
• Entellium CRM
• NetSuite CRM+

SAP Business One is an integrated enterprise resource planning (ERP) software that targets business software requirements of small and medium sized enterprises (SMEs) from SAP AG based at Walldorf, Germany.

Structure

SAP Business One contains 14 "core modules":