In this tip, I will demonstrate how to present reports on SQL report server on SharePoint page and explore the possibility of using Business Scorecard Manager to present KPIs based on analysis cubes.
In this tip, I will demonstrate how to extract SAP data via .NET Provider for mySAP into SQL 2005 database and then use SQL2005 business intelligence — analysis service to create cubes and then use reporting service to create report model and finally create reports using report builder and present on reporting service web page.
This tip demonstrates how to use SQL 2005 report server to access SAP existing tables via .NET Provider. The .NET Provider implements the ADO .NET classes such as DbConnection and DbCommand. It uses librfc32.dll to communicate with SAP to get data from SAP. The demo shows you do not need write any codes but just some sql statements to access SAP tables and then present them on SQL report web sites. You can image if your SAP have a quite amount of tables developed in ABAP. Then just a few steps takes you quickly transfer the tables to become a web-enabled presentation. You can get rid of the SAP GUI limitation.
SQL 2005 is a Microsoft latest product. It provides a new way to access SAP data via new feature pack of.NET Provider for mySAP. The reports on SQL 2005 report server can be easily to display on another Microsoft product, SharePoint Portal Server or Windows SharePoint sites. And what’s more, after SAP data is extracted into SQL 2005 database, we can do more business intelligence work and then present drill through web tables on report server web sites / SharePoint pages, even to use analysis service result to build company KPIs and lastly use Microsoft Business Scorecard Manager 2005 to present KPIs in a visible way on SharePoint Pages.
In this tip, I will introduce how to implement the two SharePoint web parts after getting the SAP data via SAP proxy as last tip. I will only high light some key points. More SharePoint development knowledge please check Microsoft web site. There are two web parts. In the first web part, "Customer List" provider web part, It can return a customer list when users enter some search string in a text box. Then if users choose a customer from a dropdown list. Then it passes the Customer Number to the second web part, "Sales Orders/Items" web part. The second web part shows all sales items for a chosen customer. The first web part demonstrates how to get customer list via invoking RFC_Customer_Get function while the second web part demos about how to get sales items info via invoking a BAPI function called BAPI_SALESORDER_GETLIST.
Recent Research