Show TOC

To create a local providerLocate this document in the navigation structure

Context

You can upload local data to create a local provider. The data in the local provider can then be analyzed with Analysis and you can use the local provider to create a CompositeProvider.

Procedure

  1. Open the Microsoft Excel file containing the data you want to upload to a local provider.
  2. Select the cells you want to upload.
    The entries in the first row of the selected range will be defined as column names automatically. You can change these column names in the local provider settings.
  3. Select Upload in the Data Source group.
  4. Log on to the BW system.
    The new local provider will be added to a workspace. Log on to the BW system containing the workspace where you want to add the local provider.
  5. Select the workspace and press Next.
    The Details dialog appears.
  6. Enter a name for the local provider in the Description field (optional step).
  7. Enter a technical name for the local provider in the Technical Name field (optional step).
    The first part is predefined by the system containing the elements @3 and the workspace prefix.
  8. In the Column Definition section, you can define the following settings:
    • Column Name

      The column name is predefined with the entries in the first row of the uploaded range. You can change the name here. If you change the name, you should also change the entries in your Excel source file to be able to reload data later.

    • Measure

      Select the check box if the column contains measure data.

      A default entry for the measure is made. It can however be changed manually.

    • Type

      For dimensions, select one of the following types: Time, Date, Dimension, Text (default), Text with Leading Zeros.

      For measures, select one of the following types: Integer, Decimal, Floating Point Number, Measure.

      A default entry for the type is made. It can however be changed manually.

    • Type Details

      If you want to use this local provider to create a CompositeProvider, you can select the InfoProvider object of the workspace where the uploaded data should be linked to. The selection is possible for type Dimension and Measure. For dimensions, you get a list of all dimensions in the workspace to select an object. For measures, the list contains all measures available in the workspace.

  9. Press Next.
    In the Target Location dialog, you can specify wether the new local provider should be inserted into the current workbook sheet or a new workbook sheet after being created. You can also select that the new local provider is not inserted in a sheet after the creation.
  10. Press OK to create the local provider.

Results

The local provider is created in the workspace. You can add it to a workbook as a data source and analyze the data with Analysis.