Show TOC

To save a workbookLocate this document in the navigation structure

Context

You can save a workbook on the business intelligence platform, on the SAP NetWeaver platform, in SAP Lumira Cloud or as a local file.

If you save a workbook to the BI platform 4.1, the workbook is saved as an Analysis Workbook object. If you save a workbook to the BI platform 4.0 or former releases, the workbook is saved as Microsoft Excel object.

The workbook is saved with the current navigation state and selected properties. The workbook properties are part of the Component tab in the design panel.

Procedure

  1. In Microsoft Excel 2010, choose Start of the navigation path File Next navigation step Analysis Next navigation step Save Workbook End of the navigation path.
    In Microsoft Excel 2007, press the Microsoft Office Button and choose Save Workbook.
    In Microsoft Excel 2003, choose Save Workbook in the Analysis Standard toolbar. If you want to save a workbook locally, choose Start of the navigation path File Next navigation step Save End of the navigation path.
    Note If all platforms are enabled in your Analysis installation, you will find three icons for saving a workbook, one for each platform.
  2. Log on to the selected platform and BW system.
  3. Select the location where you want to save the workbook.
  4. Enter a name and technical name for the workbook.
    Note If you use SAP BusinessObjects Business Intelligence platform 4.1, the workbook is saved as an Analysis Workbook object.

    Depending on your selection in the Plattform Settings, you may select between two formats: Analysis Workbook or Analysis Workbook (Compatibility Mode). The Analysis Workbook (Compatibility Mode) object corresponds to the Microsoft Excel object that is saved to the BI platform with former Analysis releases.

  5. Press Save.
    The workbook is saved to the selected platform.

    You can refresh the displayed document list by choosing Refresh in the context menu or pressing F5.

Results

The workbook is saved. You and other users with access to the server can open and analyze it.