Open
You can open queries or workbooks with the open functions on the analysis toolbar or the BEx Analyzer menu. The Open dialog box itself is a general service shared by Business Explorer applications, but there are some features surrounding open functionality that are specific to BEx Analyzer.
Open features and background relevant for BEx Analyzer are discussed below.
Open Query
You can use this function to open a query from a BW system.
When you open a query, it is embedded into the workbook you have currently defined as default (see Current Default Workbook in theGlobal Settings dialog box). In the standard setting, you see a navigation pane and an analysis grid embedded in a Microsoft Excel worksheet. The query is automatically executed, and the current state of the result is returned from the server. You can then navigate the query using the navigation pane and analysis grid.
Normally, a power user will open a query and work in design mode to customize an interface for it, and then save it in a workbook that an end-user can use to run analyses. The power user thus determines to what extent end-users can interact with and navigate the query.
You can also create a new query by launching Query Designer from the BEx Analyzer analysis toolbar.
More information:Tools
Open Workbook
You can use this function to open a workbook from a BW system.
A workbook delivers the interface for your query. In a workbook, you can embed design items and customized macros, and you can format its appearance for a highly customized look and feel. Normally, end-users can open workbooks and navigate in them to execute queries and view current data.
You can customize workbooks and set them to default, so that subsequent queries open in the same workbook (see Current Default Workbook in theGlobal Settings dialog box to learn how to set a workbook to default.) To set a workbook to default, you must have opened it from a BW system (rather than locally).
You can open workbooks from your local file system or create new workbooks using Microsoft Excel's Open and New commands.
Local History
You can easily access recently opened workbooks or queries using the local history, which is a submenu on the Open tool. The number of workbooks or queries displayed in the local history is determined by the Maximum Number of Objects in Local History setting in theGlobal Settings dialog box.
- To open a query, choose Open → Open Query in the analysis toolbar, or BEx Analyzer → Open Query in the menu.
- To open a workbook, choose Open → Open Workbook in the analysis toolbar, or BEx Analyzer → Open Workbook in the menu.
- If you set the flag Support Single Query Refresh in the workbook settings, you can use the context menu to define whether you want to refresh all the workbook queries or only one workbook query when you open the workbook.
- If you set the flag Refresh Workbook on Open in the workbook settings, all the queries are refreshed when you open the workbook.
- After opening the workbook, you can use the Refresh / Pause Automatic Refresh analysis function to get the most current data from your BW system.
More information:
To open a recently-opened workbook or query from your local history, choose Open → [Name of workbook or query] from the analysis toolbar.
- If you are not connected to a system first, after you choose a BEx Analyzer open function the SAP Logon dialog box appears. After selecting and logging on to a system, you go to the common Business ExplorerOpen dialog box.Note
If you are already connected to a system and want to open a query or workbook from a different system, first disconnect (seeConnect / System Information) and then use the Open function.
- To open a workbook from your local file system, choose File → Open from the menu in Microsoft Excel.
- To create a new workbook, choose File → New in the menu in Microsoft Excel, and select Blank Workbook. If you are not already logged on when you then save the workbook usingSave on the BEx Analyzer analysis toolbar, you will be prompted to log on via the SAP Logon dialog box.
More information: