Show TOC

To insert a data source in a workbookLocate this document in the navigation structure

Procedure

  1. Select the cell in the worksheet where the crosstab with the data from the selected data source should be inserted.
  2. Select Insert Data Source.
    The Log on to SAP BusinessObjects BI platform dialog box appears.
  3. Log on to the platform you want to use:
    • Enter your User, Password and the WEB Service URL to log on to the business intelligence platform.
    • Select Skip to use the SAP NetWeaver platform. Log on to a BW system directly without using the business intelligence platform. Continue with step 7 if using this log on.
    Note If you log on with an initial password to a BW system, or your password is expired and needs to be reset, the dialog for changing the password opens automatically.
  4. Optional step: Enter System and Authentication.
    You will normally not be asked to supply this information. However, if you are asked to log on to a special Central Management System (CMS), you can add these two additional fields to the dialog box by selecting Options. Enter the name of your Central Management System in the System field and the authentication type in the Authentication field.
  5. Press OK.
    The Select Data Source dialog box appears.
  6. Select a connection in the Show Connections list:
    • If you select All, all available systems, Cubes / InfoProvider and Query / Query views on the business intelligence platform are displayed.
    • If you select System, all available systems on the business intelligence platform are displayed.
    • If you select Cube / InfoProvider, all available Cubes and InfoProvider on the business intelligence platform are displayed.
    • If you select Query / Query View, all available Queries and query views on the business intelligence platform are displayed.
    • If you select Local System, all systems in your local SAP Logon are displayed.
  7. Select a system and press Next.
    To select a Query, query view or InfoProvider directly, double-click the object you want to select.
    The Logon to System dialog box appears.

    You can refresh the displayed system list by choosing Refresh in the context menu or pressing F5, for example after adding a new system to the SAP Logon.

  8. Enter Client, User and Password in the fields and press OK.
    If you want to specify the system language, select Options and enter the language in the Language field.
  9. Select a data source in the Select Data Source box and press OK.

    On the Folders tab, you can navigate in the Roles, InfoAreas or Workspaces views to find a data source.

    On the Search tab, you can search for the description or technical name of a data source. To retrieve data sources that begin with a specific string, you can type * after a partial string.

Results

A new crosstab with the data of the selected data source is inserted into the worksheet. The SAP style set SAP Black&White is used as default. You can now analyze the data and change the displayed data set according to your needs. You can also add other components to your analysis, charts for example.