SAP BW/BI - Business Content Scenario's

FI

AR

Info Cubes Accounts Receivable: Line Items (technical name 0FIAR_C03) Accounts Receivable: Payment History (technical name 0FIAR_C05) Accounts Receivable: Transaction Data (technical name 0FIAR_C02) Key Points Analysis of accounts receivable line items Analysis of the payment history (payment volume and days in arrears) of customers per company code and fiscal year period Analysis of all accounts receivable data (transaction figures)

AP

InfoCubes Accounts Payable: Line Items (technical name 0FIAP_C03) Accounts Payable: Transaction Data (technical name 0FIAP_C02) Key Points Analysis of accounts payable line items Analysis of the payment history (payment volume and days in arrears) of customers per company code and fiscal year period Analysis of all accounts payable data (transaction figures)

GL

InfoCubes General Ledger: Transaction Figures (technical name 0FIGL_C01) General Ledger: Financial Statements (technical name: 0FIGL_VC1) Key Points Analysis of all the transaction data from the general ledger that were loaded from the integrated source system(s) It is possible to explain the cumulative balance of a G/L account or a higher financial statement item in detail. The period view shows the allocation of the balance to the individual posting periods.

 

SALES

Sales Analysis

InfoCubes Quotations / Orders (technical name 0SD_C05) Delivery Service (technical name: 0SD_C04) Sales Overview (technical name: 0SD_C03) Key Points Analysis of all transaction data from sales orders, deliveries and billing documents/invoices Analysis of deliveries from R/3 such as:  - Quantities delivered too early  - Quantities delivered too late  - Correctly delivered quantities You can also track average delivery processing times, such as time elapsed between the material availability date and the date on which the goods arrive at the customer. Analysis of general figures for quotations including:  - Number of quotations created  - Net and gross values of the quotations  - Number of quotations rejected You can also calculate the success rate of quotations by comparing quotation and order quantities. Information about the quotation success rate includes:  - Comparisons with order probability  - Orders that result from quotationsNote: Although you can see whether the order resulted from a quotation, you cannot see whether a quotation led to an order.

Cross-Functional Analysis: Financial and Sales Data

The scenario Cross-Functional Analysis: Financial and Sales Data describes all the necessary activities to build up a report that analyzes data from financial accounting and sales and distribution. With the detailed description easy enhancement of the report according to individual customer requirements is possible, for example: include more or other characteristics, other key figures, break down in other intervals, and so on. Function List The following functions are provided to support the Cross-Functional Analysis: Financial and Sales Data scenario: Connecting SAP BW to SAP R/3 General settings for BW-Integration Modeling of the data structure for cross-functional analysis SD-FI in BW Building up a web report for analyzing financials and sales data Key Points Analyzing financials key figures Drilling down key figures from sales to the level of the following characteristics: Sales Organization, Distribution Channel, Division, Sold-to Party, Bill-to Party, Billing Document Number, Sales Group, Sales Employee, Sales District., Sales Office Analyzing the structure of receivables Revenue for the current year broken down by due date for net payment in intervals: already paid items, total balance of open items, already overdue items, intervals 16 - 30 days, 31 - 45 days, 46 - 60 days, 61 - 90 days, 91 -120 days, > 120 days

Booking Billing Backlog Analysis

Function List The following functions are provided to support the Booking Billing Backlog Analysis scenario: Connecting SAP source system to SAP BW Customizing of extractors in SAP source system Creation of an infocube for sales and distribution Booking Billing Backlog Analysis on document level Enhancing existing Business Content Objects Using Business Content objects as template Modelling of complete data flow Creation of a report (query) for Booking Billing Backlog Analysis Key Points Combination of various information from different sales documents for a complete overview on open sales orders and deliveries Analyzing values and quantities backlog in sales orders and deliveries with goods issues posted Drill down of analysis to the level of single sales order items, materials, customers, shipping points as well as sales organisation, distribution channel and division

CRM

Lead Analysis

The scenario CRM Lead Analysis enables you to analyze the Marketing Lead Analysis data from SAP CRM in SAP Business Information Warehouse. InfoCubes The analysis is carried out with the queries of the InfoCube 0MKTG_C01 CRM - Lead Management (SAP BW Business Content). Key Points This InfoCube enables you to execute the following standard queries available in SAP BW: Channel Analysis Efficiency Reporting Historical Evaluation Lost Leads Channel Management: Top-n Lost Leads (Current Year)

 

Activities Analysis

InfoCubes The analysis is carried out with the queries of the InfoCube 0CSAL_C01 - Activities (SAP BW Business Content). Key Points The InfoCube for activities in CRM provides the data basis for evaluating business activities undertaken by your employees. It delivers data for queries such as: Intensity of customer care Activity/passivity analysis Success/failure analysis The Scenario Installation Guide CRM Activities Analysis also gives the procedure for creating a sample query Activities_MSA_Employee and further activities for uploading the query and it's workbook from SAP BW to SAP CRM middleware. After synchronization, the activity analysis for a the sales employee can be carried out in the mobile sales client.

Opportunities Analysis

InfoCubes The analysis is carried out in the queries of the InfoCube Opportunities - 0CRM_C04 (SAP BW Business Content). Key Points This InfoCube enables you to execute the following standard queries available in SAP BW: Channel Management Sales Forecast Win/Loss Analysis for Opportunities Sales Volume Forecast Pipeline Analysis per Phase

Sales Order Complaints Analysis

InfoCubes The analysis is carried out in the queries of the InfoCube 0CSAL_C09 - Complaints (SAP BW Business Content). Key Points This InfoCube enables you to execute the following standard queries available in SAP BW: Actual Value Purchase Orders Number of Procurement Transactions Procurement Values per Buyer in Quarterly Overview Procurement Values per Vendor

 

Service Quality Analysis

The Scenario CRM Service Quality Analysis describes the all the required activities to analyze the item data for service orders and confirmations for which related complaints exist from SAP CRM in SAP Business Information Warehouse. InfoCube 0CSRVMC04 - CRM Service - Orders and Confirmations with Complaints Key Points This InfoCube enables you to execute the following standard queries available in SAP BW: Complaints Analysis Delayed Services/Services on Schedule Delayed Services/Order Value

SCM

Purchasing

InfoCubes Purchasing Data (technical name: 0PUR _C01) Vendor Evaluation (technical name: 0PUR_C02) Purchasing Groups (technical name: 0PUR_C04) Key Points Analysis of material groups, vendors, and materials. This data enables you to find answers to the following questions, for example:  - Which materials and how much of each material have been ordered from a certain vendor?  - How many PO items are there for a certain material group? Display of scores from the vendor evaluation facility within Purchasing. On the basis of this data, you can compare your vendors with each other and also check whether a certain vendor delivers a material punctually and in the desired quantity for example. Since the scores from the previous period are available in addition to the current score, you can also check whether your vendors' performance is improving or deteriorating. Analysis of the purchasing activities of your purchasing (buyer) groups. Data on effective order values, invoiced amounts, and number of deliveries is available to you for this purpose. Furthermore, you can obtain an overview of how many documents, document items, and (if applicable) document schedule lines have been created by the purchasing group.

 

Inventory Analysis

This scenario enables you to analyze stock data from SAP R/3 and to evaluate materials for which no movement has occurred. InfoCubes Material Movements (technical name 0IC_C03) Slow-Moving Items (technical name 0IC_MC01) Key Points Stock overview Valuated Stock Analysis Blocked Stock Analysis Slow Moving items Analysis

Demand Planning Analysis

The scenario Demand Planning Analysis in SAP Business Information Warehouse enables you to support the demand planning analysis process in a company. It helps to make the planned / actual sales data comparison. Info Cubes The Analysis is carried out in the Plan / Actual Comparison Demand Planning query created from the Supply Chain Planning MultiCube (SCP_MC). Key Points Plan/Actual Data Comparison Predefined Query Web Reporting for this plan/actual data comparison  For further information please refer to the Demand Planning Analysis Scenario Installation Guide.

APO Resource and Operation Data Analysis

The scenario APO Resource and Operation Data Analysis enables you to analyze the operations, resource capacity and schedule situation data of  the Production Planning / Detailed Planning area of SAP APO in SAP Business Information Warehouse. Info Cubes The analysis is carried out in the Resource/Operation Data query created on the InfoCube APO Resource and Operation Data (technical name: 0APO_C01). Key Points The Resource and Operation Data InfoCube is provided with the following standard queries for analysis: Operation Quantities, Plan Version Scrap Resource/operation Data (The procedure to create this query is provided in the Building Block Configuration Guide) Resource: Capacity/Requirements of a Planning Version Resource: Capacity/Requirements of Several Planning Versions Resource: Req. Setup/Processing of Several Planning Version Vendor handling / Customer Handling· Resource: Required Set Up/Processing of a Planning Version For further information refer to the Scenario: APO Resource and Operation Data Analysis Installation Guide.

SUPPLIER RELATIONSHIP MANAGEMENT

SRM Analysis

The scenario SRM (Supplier Relationship Management) Analysis enables you to analyze local procurement data with regard to purchase orders, goods receipts, and invoice receipts on an aggregated level. In addition, the variances in the invoice value to order value can be analyzed. Info Cubes The analysis is carried out in the queries of the InfoCube 0BBP_C01- Global Spend (Point-to-Point Connection)(SAP BW Business Content).) Key Points This InfoCube enables you to execute the following standard queries available in SAP BW: Actual Value Purchase Orders Number of Procurement Transactions Procurement Values per Buyer in Quarterly Overview Procurement Values per Vendor

HR

Time Management – Time and Labor

This scenario enables you to analyze different time management data from SAP R/3. InfoCubes Time and Labor Data (Technical Name: 0PT_C01) Key Points Monthly View of Selected Time and Labor Data: This query is used to present selected time and labor data of one year broken down into months. Quarterly and annual summarizations can also be calculated by choosing the appropriate line characteristics. Selection areas available are personnel area and calendar year/month. Time and Labor in Units of Full-Time Equivalents (FTE): This query is used to compare planned time, productive time, and overtime of a year with the values of the previous year. The times are represented in units of full-time equivalents (FTE), in which the number of hours is based on the annual working time of a FTE. The default value of 2000 hours is stored as the annual working time of a FTE in the Business Information Warehouse. If the annual working time of a FTE is 2000 hours, then a planned time of 1,800 hours results in a value of 0.9 in units of FTE. Compare Overview of Time and Labor to Previous Year: This query is used to assign time and labor data from one year according to time types, and then based on the relation to planned time, compare time and labor from the previous year. Time and Labor Data with Debited Cost Information: This query is used to compare selected time and labor data from one year with times from the previous year. A hierarchy can be assigned as the only line characteristic to the cost center debited with the corresponding personnel costs.

 

Personnel Development – Qualifications

This scenario enables you to analyze employee qualification data from SAP R/3. InfoCubes Personnel Development - Qualifications (Technical Name: 0PAPD_C01) Key Points Annual Comparison of Qualifications per Employee: This query displays the number of employees with particular qualifications. The maximum number of employees is equal to the headcount of the enterprise.The evaluation is performed as an annual comparison (last month of previous year compared with current month; with absolute and percentage differences).The query enables you to evaluate how qualifications change over a given period. Qualifications per Employee by Organizational Unit: This query displays the number of employees with particular qualifications. The maximum number of employees is equal to the headcount of the enterprise.The evaluation is performed on the basis of organizational units for the last posted month of the current calendar year.The query enables you to evaluate the number and kind of qualifications in an organizational unit during a given period. Proficiency of a Qualification per Employee: This query displays the number of employees with particular qualifications. The maximum number of employees is equal to the headcount of the enterprise.The evaluation is performed according to proficiency per qualification for last posted month of the current calendar year.The query enables you to evaluate the proficiency of existing qualifications in your enterprise during a given period.

Travel Management – Travel Expenses

This scenario enables you to analyze travel expense data from SAP R/3. InfoCubes Travel Expenses: Totals and Receipts (Technical Name: 0FITV_C01) Key Points Overview of Travel Expenses: The Overview of travel expenses query can be used primarily as a control instrument for the costs incurred by business trips. It displays, by trip provision variant, the total costs of all the trips created, the miles/kilometers traveled and the trip duration in days.If you also include the user-defined characteristics Trip country and Settlement status, you can, for example, display the costs incurred for all trips to the USA created with the trip provision variant 01 (Germany) that have already been settled.You can also restrict the display to a specific time frame: Display by calendar year / Display by quarter If you select a filter value, only the data for the quarter or calendar year entered is displayed. To view the values of several quarters or years next to one another for comparison, use the appropriate time characteristic to expand the evaluation. Flight Bookings by Provider Hotel Bookings by Provider Car Rental Bookings by Provider

Copied from other source...

QUEUED DELTA

SMQ1: qRFC Monitor for the outbound queue, we use this transaction to monitor the status of the LUWs in the outbound queue and restart any hanging queues manually.

LBWQ: This is a transaction that does nothing but calling SMQ1 for queues ‘MCEX*’ skipping the selection screen.

RSA7: BW Delta Queue Monitor, we use this to see transferred data (delta) for a DataSource and a Target system.

LBWE: LO Data Extraction: Customizing Cockpit. Here we can activate/deactivate extraction, maintain extract structures and change update mode for each logistics application.

Enabling queued delta

We want to know how the qRFC Monitor for the outbound queue (SMQ1) and BW Delta Queue (RSA7) work for delta records. In this example we will use DataSource “2LIS_03_BF” (and 2LIS_03_UM). We assume that Init loads were already executed for the extractors and we are ready to go for delta loads in BW.

First, we set the relevant application’s Update mode to ‘Queued Delta’. See the below screen.

Go to LBWE and set Update Mode to ‘Queued Delta’:

Check outbound queue

If there are already posted or changed documents related to Inventory Controlling – Application 03, they will appear in the outbound queue LBWQ, as can be seen in the screenshot below.

If there are no posted/changed documents, you can post or change any, just to create an entry in LBWQ. This can be done in transaction MB1C for example. 

 Check BW Delta queue

Now check transaction RSA7 – BW Delta queue Monitor.

Here we can see number 2 under ‘Total’ in the delta queue: 

To see the entries select the DataSource and click on Display data entries Icon. 

Select Delta Update and execute. 

Nothing is shown here, despite there were 2 records under ‘Total’ in RSA7 initial screen. 

Now select ‘Delta repetition’ in the ‘Display data entries’ screen and execute: 

You can see 408 entries in Delta Repetition. 

Run the V3 update job

Now, run the V3 job from LBWE, to send the documents from the outbound queue to the delta queue. Don’t forget to set the job to run immediately. 

You can find the “New Job is Scheduled” on the status bar, so our V3 is started. 

Check if the job finished successfully

The job should end shortly. You can find its status in SM37, with job name “LIS-BW*”: 

See the job status, it is finished. 

Check outbound queue again

Now let’s go back to LBWQ and see the queue. Notice that we can’t find MCEX03, because after executing V3 job, all data records moved from Outbound queue to Delta queue, that is, from LBWQ to RSA7.

Check BW Delta queue again

In RSA7, we can see that the Total has increased from 2 to 3. Now display the entries for the extractor in question. 

In the update mode, select Delta update and execute:

Now we can see 99 records, where before it was 0: 

Come back and select Delta Repetition and execute. 

Here you can find totally 507 records. How? Earlier we have 408 records, now 99 records after V3 job, so totally 507 records. 

Now go to BI/BW System and execute DELTA Info Package for 2LIS_03_BF DataSource. 

You can see 99 records in PSA. See the below screen. 

Diagram with complete data flow

In the following diagram is the abstract of the whole data flow: