The Fiorano SAP Reporting Solution

Use case 1

- Sales analysis report requires integration of SAP data with non-SAP data stored in a local file.

This use-case is the real solution running at a customer site in a production environment. In this use case, the sales-analysis report is generated by combining actual sales data from the SAP R/3 system and the budget plan stored locally in a csv file.

Report Format to be generated

Sales Region : Tokyo ◄ specified by requester (sales manager)

2005-12-01 to 2005-12-31◄ specified by requester (sales manager)

A : comes from SAP R/3
B : comes from locally stored file (csv)
C : comes from SAP R/3

1 Growth_MTD = (Quantity – Prev-Year-Qty) / Prev-Year-Qty * 100
2. Achievement = (Quantity – Budget-Qty) / Budget-Qty * 100

1.	Get request from the web via HTTP. The request specifies the region and time frame to be reported
2.	Retrieve data from SAP
	2.1. Retrieve current sales data using the Fiorano SAP Adapte
	2.2. Retrieve previous year data using the Fiorano SAP Adapter
	* These Adapters invoke stored ABAP programs via BAPI I/F
3.	Join the current and the previous data
4.	Unique sort by product
5.	Calculate Growth_MTD of the each product
6.	Read budget plan stored as local CSV file
7.	Convert the budget plan data to XML
8.	Unique sort by product
9.	Join the Growth_MTD calculated in step 5. and the budget data, calculating achievement
10.	Calculate the sub-totals of the budget data
11.	Transform into HTML format
12.	Send back the HTML

Click on the links below to learn more:

Use case 1:
- Sales analysis report requires integration of SAP data with non-SAP data stored in a local file.

Use case 2:
- Usage of third party report generation tool.

Use case 3:
- Real time monitoring of business data.

Back to Main Page - The Fiorano SAP Reporting Solution.