Show TOC

To convert a BEx workbookLocate this document in the navigation structure

Context

You can convert workbooks created with SAP BEx Analyzer 3.5 and SAP BEx Analyzer 7.0 to an Analysis workbook. In the platform settings, you can specify which BEx objects should be converted and you can also specify whether a conversion log should be created.

Procedure

  1. In Microsoft Excel 2010,choose Start of the navigation path File Next navigation step Analysis Next navigation step Convert BEx Workbook End of the navigation path.
    In Microsoft Excel 2007, press the Microsoft Office Button and choose Convert BEx Workbook .
    In Microsoft Excel 2003, choose Convert BEx Workbook in the Analysis Standard toolbar.
  2. Select the SAP NetWeaver 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 platform settings, 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 SAPGetDimensionInfo
    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
    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 deactivated 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 availabe 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