摘要:Business Intelligence (BI) deals with increasing the competitive advantage of a business, by intelligent use of available data for decision making and synthesizing useful knowledge from collections of data. Microsoft Excel is one of the most commonly used BI tools and it is ubiquitous as well as well understood. Excel PivotTables enables access and analyze SAP NetWeaver BI data. SAP BI 7.0 release introduced a new dimension tool, called Cell Based Reporting (CBR), for developing workbooks using Excel. This feature facilitates seamless integration of Excel with BI and produces a dynamic view of the reports for the desired selection parameters to the user. In this we study the CBR features of SAP BI and focus on development of CBR based financial analysis reports for the business. This study shows that CBR based reporting guarantees the increase in performance of reports by integration of Excel with SAP BI.
关键词:Custom Reporting ; Excel ; SAP NW 4s ; Cell Based Reporting ; SAP BI 7.0.