Working with Local Providers

1. Go to the Administration page, and in the Modeling section, choose InfoProviders.
2. On the screen that appears, choose Local Providers and then choose New to start the local provider creation wizard.
3. Enter the ID and Description of the new local provider. If you want to set a prefix for the local providers generated in the environment, go to transaction RSBPCADMIN and add the parameter WSP_PFX, In the value of this parameter, you can specify the prefix. There’re some other customization settings you can define in transaction code RSBPCADMIN:
   • Parameter WSP_MAX_SP: set maximum memory
   • Parameter WSP_MAX_PR: set maximum number of local providers
   • Parameter WSP_SIDX: if the value is “X”, then generation of master data (SID) is allowed
4. In the Data File field upload a comma-separated value (CSV) file and enter the following format information about the file:
   • The number of the header row
   • The number of the first data row
   • The character that is used as separator
   • The character that is used as a field delimiter
   • Select the character that is used as decimal mark.
   • Select the format of the date.
   Note

   The CSV file must contain transaction data (for planning) and must have columns that represent dimensions and key figures.

   Choose Next.

5. In Map InfoObjects you can map your dimensions to SAP BW InfoObjects, or you can manually enter the data type of a column. Select at least one key figure. In this step you can also enable data auditing for the new provider.
   Note

   When you map a dimension to an existing SAP BW InfoObject, its master data and hierarchy can be used directly by the local provider. The dimensions that are not mapped to SAP BW InfoObjects receive their master data from the uploaded CSV file.
   When you map a column to a BW InfoObject, you have three options:

   • Map to a global BW InfoObject

   • Map to a global BW InfoObject and select the checkbox Generate Local InfoObject to create a local InfoObject

   • Map to an existing local InfoObject, which are InfoObjects created in the current environment

     For information about how to create a local dimension directly from a dimension list, refer to Creating Local Dimensions.

   A local InfoObject (dimension) has the same metadata as the global BW InfoObject from which it was created. The local InfoObject inherits master data from the global BW InfoObject; master data changes in the global BW InfoObject are reflected in the related local InfoObject. Also, new members are visible only in the local InfoObjects and overwrite the property values of global members (members from the global BW InfoObject).

   Choose Next.

6. In the Create Model step you can create a new model that uses the local provider. If you do not need to create a model at this time, you can skip this step.
   Note

   Models that contain a local provider cannot be exported.
7. Review your changes and choose Done.

1. Go to the Administration page, and in the Modelling section, choose InfoProviders.
2. On the screen that appears, choose Local Providers, then select the required provider and choose Update.
3. In the Data File field upload a comma-separated value (CSV) file and enter the following format information about the file:
   • The number of the header row
   • The number of the first data row
   • The character that is used as separator
   • The character that is used as a field delimite.
   • Select the character that is used as decimal mark.
   • Select the format of the date.
   Note

   The CSV file must contain transaction data (for planning) and must have columns that represent dimensions and key figures.

   Choose Next.

4. In Map InfoObjects you can map your dimensions to SAP BW InfoObjects, or you can manually enter the data type of a column. Select at least one key figure. In this step you can also enable data auditing for the new provider.
   Note

   When you map a dimension to an existing SAP BW InfoObject, its master data and hierarchy can be used directly by the local provider. The dimensions that are not mapped to SAP BW InfoObjects, receive their master data from the uploaded CSV file.

   Choose Next.

5. Review your changes and choose Done.

1. Go to the Administration page, and in the Modelling section, choose InfoProviders.
2. On the screen that appears, choose Local Providers, then select the required provider.
   The following information is displayed:

   • The local provider's name and description
   • The aggregation level that was generated automatically
   • The query that was generated automatically
   • Data auditing settings
   • The dimensions of the provider

• When you choose Enable Data Audit, the system automatically creates the necessary auditing dimension.
• When you choose Activate Data Audit, the system begins to log information when data is changed or new data is entered.

If a local provider has dimensions that are mapped to SAP BW InfoObjects, you can use work status for the models that are built on that local provider.

Besides the default aggregation level that is generated automatically, you can also create new aggregation levels with transaction RSPLAN.

You can also create new queries on aggregation levels with BW modeling tools. Queries can be consumed through the Business Planning and Consolidation Web client or the Analysis Office add-in.