Show TOC

Tasks on DemandLocate this document in the navigation structure

You perform the following tasks to adjust current processes and functions to reflect changes in your data warehouse, to improve performance and for troubleshooting:

Task Further Information

Adjust processes and objects

Adjust process chains

You can adjust processes or process chains to reflect changes in your data warehouse.

More information:Process Chain Maintenance.

Configure authorizations

You can assign users the authorizations they require for their tasks.

More information:Setting Up Standard Authorizations andManagement of Analysis Authorizations.

Remodel an InfoProvider

You can modify the structure of an InfoProvider that data has already been loaded into, without losing any data.

More information:Remodeling InfoProviders.

Modify aggregates to reflect changes to hierarchies and attributes

If the hierarchies and attributes of characteristics belonging to an InfoCube have changed, structural changes need to be made to the aggregates to modify the data.

In this task, you can perform the attribute change run.

More information:System Response to Changes to Master Data and Hierarchies

Change system parameters

In this task, you can change system parameters, such as the debugging user.

You call the function in the Administration functional area in the Data Warehousing Workbench (DWB), under Current Settings → System Parameters.

Change parameters for data transfer

In this task, you can change data transfer parameters for non-SAP source system and the settings for partition sizes of PSA tables.

You call the function in the Administration functional area in Data Warehousing Workbench (DWB), under Current Settings → BI System Data Transfer.

Switch BW accelerator index to inactive if the BW accelerator is no longer available

BEx queries that use an InfoCube as the data provider terminate if a BW accelerator index has been created for the InfoCube but the BW accelerator is no longer available. If this occurs, call the index maintenance transaction for the BW accelerator. Select the relevant InfoProvider that the BWA index was created for, choose Edit and set it to active on the BWA Index Settings tab page.

More information:Indexing BW Data in SAP Net Weaver BW Accelerator.

Create connection to near-line storage

If you decide to use near-line storage as the data archiving method in your operational system, you can set up the connection to your near-line storage here. Status information indicates whether the connection is working and can be used.

You call the function in the Administration functional area of the Data Warehousing Workbench (DWB), under Current Settings → Near-Line Storage Connections.

More information:Creating Near-Line Storage Connections

Make performance-related adjustments

Adjust performance settings for InfoProviders

In this task, you can adjust the settings you made when you defined the InfoProvider in InfoProvider properties maintenance.

You call the function in the Administration functional area in the Data Warehousing Workbench (DWB), under Current Settings → InfoProvider.

Adjust performance settings for DataStore objects

In this task, you can adjust the settings you made in the Implementation Guide, under SAP Net Weaver → SAP NetWeaver Business Warehouse → Performance Settings.

This setting allows you to improve the performance of the data processing in the DataStore object.

You call the function in the Administration functional area in the Data Warehousing Workbench (DWB), under Current Settings → DataStore Objects.

Adjust performance settings for aggregates

In this task, you can change the parameters for the change run and for building aggregates that you set in the Implementation Guide, under Net Weaver → SAP NetWeaver Business Warehouse → Performance Settings.

This setting allows you to improve performance when filling aggregates and during the change run.

You call the function by choosing Current Settings → Aggregate Parameters under Administration in the Data Warehousing Workbench (DWB).

Adjust parameters for OLAP cache

In this task, you can adjust the settings you made in the Implementation Guide, under SAP Net Weaver → SAP NetWeaver Business Warehouse → Performance Settings.

You call the function by choosing Current Settings → OLAP Cache under Administration in the Data Warehousing Workbench (DWB).

More information:Cache Parameters.

Repartition or recluster InfoCube

You can repartition or recluster an InfoCube into which data has already been loaded, to improve the performance of reporting, for example.

More information:Partitioning andClustering.

Recluster DataStore objects

You can recluster a DataStore object into which data has already been loaded, to improve the performance of database access, for example.

More information:Partitioning andClustering.

Archive request administration data

You can archive old request administration data from tables RS*DONE and RSMON* that is no longer needed, to improve the performance of actions for which requests are called.

More information:Archiving Request Administration Data.

Adjust settings for parallel processing of BW processes

In this task, you can change the setting for the parallel processing of a process.

You call the function in the Administration functional area in the Data Warehousing Workbench (DWB), under Current Settings → Batch Manager.

More information:Setting Parallel Processing of BI Processes

Record traces for query execution and navigation or actions in the Planning Modeler

In this task, you can improve the read performance of queries with regard to selected query executions and query navigation by scheduling traces, which are used to fill the OLAP cache.

More information:Trace Tool (transaction RSTT).

Check BW accelerator box performance, configuration, and connection to the BI system

In cases of reduced or poor performance, you can use test scripts and monitors to test the performance and connection speed of the BW accelerator box to the BW system. You have to check the settings in the configuration file for the BW accelerator.

For more information, see SAP Note 902533: Trex 7.0: HowToGuide Connecting/Operating BW Accelerator Box

Error analysis

Record traces for query execution and navigation or actions in the Planning Modeler

In this task, you can use traces to save and analyze errors.

More information:Trace Tool (transaction RSTT).

Perform consistency checks for data and metadata in the BW system

More information:Analysis and Repair Environment.

Test, execute, and manage queries and query views

More information:Query Monitor (transaction RSRT).

More Information

Performance Optimization in the Data Warehouse