Show TOC

Workspace AdministrationLocate this document in the navigation structure

A workspace has to be created by an administrator before a business user can work in it.

The administrator defines settings such as lifetime, maximum disk space and the BW InfoProviders available in the workspace.

  1. Call Workspace Administration from your user menu. You can use this to edit either one individual workspace (transaction RSWSP) or to edit several workspaces using a structure (transaction RSWSPW).

    Choose Display Impact Logs for InfoObjects to display a Workspace-neutral log, which lists the changes made to InfoObjects and their effects on local characteristics and CompositeProviders. More information: Changes to the Central InfoObject

Editing Individual Workspaces

  1. Select a workspace to edit or enter a name for a new workspace and choose Create.

Editing Multiple Workspaces

  1. The folder <ROOT> is initial. You can create your own folders for your workspaces below this. You can also upload a folder structure from a CSV file. More information: Managing the Folder Structure

  2. Choose a workspace to edit or create a new one by choosing Create Workspace in the context menu for your folder.

Tab: Settings

  1. You can make settings to define how the workspace is used:

    • General Settings:

      • You can set an expiry date. Once the expiry date is reached, the workspace is no longer available in Workspace Designer. Following consultation with the user, the administrator can extend the validity of the workspace or delete it, together with the objects it contains.

      • You can set a prefix for the providers in the workspace. All providers and transient queries in the workspace are then given this prefix. This prefix cannot be changed once an object hast been created with it.

      • You can enter the name of two contacts who can be called upon if problems arise with the workspaces.

    • Settings for Central Providers:

      You can assign a main provider of type MultiProvider or central CompositeProvider to the workspace. This is then assigned as a central provider. You need to explicitly select the InfoProviders you need from the main provider on the Central Providers tab page. More information: The Assigned MultiProvider

    • Settings for Local Providers: These settings apply both for local providers and local characteristics:

      • You can set the maximum memory space for your own data in the workspace and the maximum number of providers. One provider is created for each uploaded data source. The system also displays the used memory and the number of providers created. If you have not made any entries, there is no restriction. This may be displayed as zero, depending on the system.

      • If you select Data Backup, a backup will be made of the uploaded data on the BW database as well as in the BWA. More information: Activating Data Backups for Local Providers

    • Data/Provider/CompositeProvider Settings:

      • Under certain circumstances, uploading local data can cause new master data attributes to be created when a query is created. The Creation of Master Data Allowed flag allows you decide whether or not this should happen.. For local characteristics, this means that you can also load characteristic values that do not exist in the master data tables of BW InfoObjects.

      • If you set the Non-Unique Join Columns Allowed flag, a multiplication of key figures can occur if join links are used when modeling a CompositeProvider. For information about key figure multiplication, see: Union / Inner Join / Left Outer Join

Tab Page: Central Providers

  1. You can drag indexed BW InfoProviders from the object repository on the left to the right. (BWA-indexed as secondary persistence; SAP HANA as primary persistence) from the the left to the right.


    If you subsequently call a workspace with central providers that have already been assigned, the object tree is not displayed automatically. You have to choose Build InfoProvider Selection for this to happen.

  2. You can also select DataSources that can be used in BW Workspace Designer as the source for creating a local provider. To select DataSources, choose Display DataSource Selection. For DataSources of type File, the system checks whether the file is located on the application server. If not, it cannot be selected.


    Using DataSources in BW Workspaces is not recommended for mass data.

    The InfoProviders that you drag to the right are assigned to the workspace and can then be used in Workspace Designer for modeling CompositeProviders.

    The DataSources that you drag to the right serve as the source for uploads to a local provider that can be used for modeling.

  3. By double-clicking on an InfoProvider, you can display it.

  4. For InfoCubes from assigned MultiProviders, you can define whether they can be used for the workspace.

  5. You can also define whether certain key figures or characteristics can be used for the workspace.

Tab Page: Local Providers

  1. If data has already been uploaded in Workspace Designer, you see a list of local providers created during the upload. The system displays the status for each local provider. OK, With Errors, Inactive or Analytic index does not exist. You can remove workspace assignments from the list for analytic indexes that no longer exist. By choosing Check you can run a more detailed analysis of the status.

    These local providers are edited in Workspace Designer. There is also a transaction that provides you with an overview of the local providers (analytic indexes) that you can use. More information: Managing Analytic Indexes

  2. You can also restore the analytic indexes if they are backed up in the BW system (if you are using a BWA). Choose Restore.


If data backup is activated, your models and data that you have uploaded are also restored during a complete restore of BWA indexes belonging to a BW system. In BW Accelerator Monitor (transaction RSDDBIAMON), you can use the Rebuild BWA Indexes function.

Tab Page: Local CompositeProviders

  1. The system displays a list of the local CompositeProviders that have been created in Workspace Designer. The system displays the status for each CompositeProvider. OK, With Errors, Inactive or CompositeProvider does not exist.

  2. You can remove workspace assignments from the list for CompositeProviders that no longer exist.

Tab Page: Local Data

  1. The system displays a list of the local characteristics that have been created in Workspace Designer. The system displays the status for each local characteristic. OK, With Errors, Inactive or does not exist.

  2. You can remove workspace assignments from the list for local characteristics that no longer exist.

Tab: Users

  1. The system displays a list of users who are authorized to work or run workspace-specific queries in the workspace in question. The authorizations are checked using the assigned roles/profiles in the user master record. The various authorizations (Workspace Designer/query) are displayed in the list using flags.


    Note however that the list can only contain users that you are authorized to display user master record maintenance for.

Finish Editing the Workspace

  1. Check the workspace. During the check, the system checks the active and revised version if one exists.


    There are two versions of the check if you have already activated the workspace (active version), made another change and only saved it for the time being (revised version).

  2. Save and activate the workspace. You can only use activated workspaces in Workspace Designer.

More information:

Tips for Editing Workspaces