Creating and administrating workbooks

You can insert SAP BEx Queries, query views and SAP Netweaver BW InfoProvider as data sources into a workbook. These data sources are stored in a SAP NetWeaver BW system. You can add multiple crosstabs to a worksheet or workbook. The crosstabs can contain data from the same data source or from different sources. You can also use data sources that are stored in different systems in one workbook.

To add a crosstab with data to a workbook, you select a data source in a SAP NetWeaver BW system. You need the appropriate authorizations for the platform you want to use (SAP NetWeaver BW or SAP BusinessObjects Business Intelligence), and the relevant SAP NetWeaver BW systems to insert a data source into a workbook. For more information, contact your IT administrator.

You can insert a data source into a standard workbook or default workbook. If you use a default workbook, styles, formatting and the workbook settings that you defined in the default workbook are used when you open a data source.

You can also insert data sources with local data into a workbook. To be analyzed, the local data is uploaded to a BW workspace.

You can save new workbooks either on the SAP BusinessObjects business intelligence platform or on the SAP NetWeaver platform. Stored workbooks can be opened from both platforms. They can also be renamed or deleted on the platforms.

You can also convert workbooks created with the SAP BEx Analyzer 3.5 and SAP BEx Analyzer 7.0 to an Analysis workbook.