Save
Use
You can save workbooks or views using the Save function in the analysis toolbar or in the BEx Analyzer menu. The Save dialog box itself is a general service shared by Business Explorer applications. However, some options of the Save function are specific to the BEx Analyzer.
Features
Save features and the corresponding background relevant for the BEx Analyzer are described below.
Save Workbook
Using this function, you save existing workbooks in a BI system.
After you open a workbook or embed a query into a new workbook, you can navigate in the query and generate different views of the data. You can also change settings for characteristic display or for the whole query. When you are customizing your workbook by inserting design items, you can decide whether you want to save this new view of the query with the workbook. You do this by configuring the Restore Initial Query View on Refresh property in the Create Data Provider or Change Data Provider dialog boxes (see Configuring Data Providers) for each data provider.
If you want a user to be able to save the state of the query after analyzing and navigating, deselect Restore Initial Query View on Refreshfor each data provider. Otherwise, the workbook opens with the original state of the query or query view. In this way, the power user who creates and configures the workbooks determines the extent to which the user can interact with and navigate in the query.
When you save the workbook, the query is not detached. When you subsequently open the workbook, connect to the server, and refresh the data contained in the workbook, your query is updated with the most recent data from the server.
Save Workbook As
Using this function, you can save a workbook in a BI system under a new name.
Save View
Using this function, you can save the current navigational state (view) of the data provider assigned to the design item in the currently active cell. When you save the query view, you can use it as the data provider for the BEx Web Application Designer, the BEx Report Designer, and the Visual Composer.
Activities
● To save a workbook, choose Save ® Save Workbook in the analysis toolbar, or BEx Analyzer ® Save Workbook in the menu.
● To save a workbook with a new name, choose Save ® Save Workbook As in the analysis toolbar, or BEx Analyzer ® Save Workbook As in the menu.
● To save the current navigational state of a data provider assigned to a particular design item, choose or scroll to the design item to select it, and choose Save ® Save View in the analysis toolbar, or BEx Analyzer ® Save View in the menu.
○ In the Technical Name field, enter a technical name for the view.
○ In the Text field, enter text to describe your view.
○ Select the Overwrite Existing View checkbox to overwrite views of the same name.
If you are not yet connected to a system, the SAP Logon dialog box appears when you choose a BEx Analyzer save function. After you select and log on to a system, you proceed to the Business Explorer Save dialog box.
● To save a workbook to your local file system, choose File ® Save or File ® Save As from the Microsoft Excel menu.
● To create a new workbook, choose File ® New in the Microsoft Excel menu, and select Blank Workbook. If you are not already logged on to a system when you save the workbook, you are prompted to log on using the SAP Logon dialog box.
More Information:
● Opening and Saving Objects in BEx