## 2.9 To convert a BEx workbook
## Context
You can convert workbooks created with SAP BEx Analyzer 3.5 and SAP BEx Analyzer 7.0 to an Analysis workbook. In the Conversion options dialog, you can specify which BEx objects should be converted and you can also specify whether a conversion log should be created.
## Procedure
1. Choose File Analysis Convert BEx Workbook .
2. Select the SAP BW system and press Next .
3. Enter your user and password to log on to the system.
4. Select the workbook you want to convert. You can search for the name or technical name of the workbook or you can select it in a folder. BEx Analyzer workbooks have the following icon in the workbook list: .
5. Press OK .
The conversion starts directly. Depending on your selection in the conversion options, the following objects will be converted:
| BEx Analyzer object                  | Analysis object                                                   |
|--------------------------------------|-------------------------------------------------------------------|
| Workbook                             | Workbook                                                          |
| Data Provider                        | Data Source                                                       |
| Item: Grid                           | Crosstab                                                          |
| Chart                                | Chart                                                             |
| Item: List Of Filters                | Formulas: SAPGetDimensionEffectiveFilter and SAPGet­ DimensionInfo |
| Item: Dropdown Box                   | Component: Filter with single member selection                    |
| Item: Checkbox Group                 | Component: Filter with multiple member selection                  |
| Item: Radio Button                   | Component: Filter with single member selection                    |
| Item: Text                           | Different info fields and formulas                                |
| Item: Message                        | Formula: SAPListOfMessages                                        |
| Planning Objects used in item Button | Planning Objects                                                  |

| BEx Analyzer object                         | Analysis object                                                                                                                                   |
|---------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------|
| Styles                                      | The style is not converted. The converted workbook is displayed with the default Analysis style set.                                              |
| Item: List of Conditions                    | The list is not converted. The conditions are available as BEx conditions in Analysis and can be activated and deac­ tivated with the menu.        |
| Item: List of Exceptions                    | The list is not converted. The exceptions are available as Conditional Formatting in Analysis and can be activated and deactivated with the menu. |
| VBA API                                     | Customer-specific code is not converted, but it is available in the workbook after the conversion.                                                |
| Navigation Pane                             | No conversion. You can use the design panel in Analysis.                                                                                          |
| Item: Dropdown Box (displaying query views) | No conversion.                                                                                                                                    |
| Item: Button                                | No conversion.                                                                                                                                    |
## Results
After the conversion, the converted workbook is opened in Analysis. You can save the newly created workbook to a platform and continue your analysis.
## Related Information
Conversion log [page 41] Conversion Options [page 329]