Show TOC

Background documentationReporting with Interactive Excel Locate this document in the navigation structure

 

You can use Interactive Excel to evaluate the current data in an SAP system by creating user-defined reports. Interactive Excel allows you greater flexibility in the definition of reports than the database analysis lists in a Business Consolidation (SEM-BCS) or an Enterprise Controlling Consolidation (EC-CS) backend system. You can create and run reports on reported, standardized, and consolidated financial data in the SEM-BCS and EC-CS components.

Prerequisites

  • You have installed Microsoft Excel 2010 or later and SAP Interactive Excel, version 3.0.

  • You have set up a connection to an SAP ERP backend system on which Enterprise Controlling Consolidation (EC-CS) or Business Consolidation (SEM-BCS) is installed.

    For information about connection Interactive Excel to a database of an SAP system, see Interactive Database Connection.

  • The source database in the backend system for report data is accessed through your local area network. Therefore, you must have access to the appropriate database tables.

Features

Flexible Definition of Reports

Interactive Excel enables you to evaluate data in the report types of data matrices.

In a report, you evaluate financial data for various characteristics and combinations of characteristics. To simplify the definition of a report, you can use lists of proposals for the characteristics predefined in Interactive Excel by accessing master data and control parameters that exist in an SAP system. However, you can also define your own report or part of a report and apply any formatting that you require.

For more information, see Creation of a Data Matrix.

Microsoft Excel Formatting

Interactive Excel is an add-in program for the standard Microsoft Excel application provided in the form of a template. Therefore, one of the advantages of Interactive Excel is that it is based on a well-known spreadsheet program that offers a wide range of formatting functions.

For information about standard Microsoft Excel functions, see http://www.microsoft.com.

Import of Report Data

You can import current data from the consolidation backend system into a report for the purpose of evaluation. Data imported from the SAP system originates from the SEM-BCS totals InfoProvider in SAP NetWeaver Business Warehouse or a database table for totals in an EC-CS system.

For more information, seeInformation System (in EC-CS) and Reporting (in SEM-BCS).

Refresh of Report Data

A live link to the relevant database enables report data to be automatically refreshed after any changes in the report definition such as a change in the fiscal year. You can also trigger a refresh at any time to overwrite data in a report with the up-to-the-minute data from the database.

For more information, see Refresh of Report Data.

More Information