Show TOC

Managing DataStore Objects (advanced)Locate this document in the navigation structure


The DataStore object is active.


You can display technical information about the contents of a DataStore object using the Manage DataStore Object function. You can perform administrative tasks here, such as delete requests.


  1. You are in the Data Warehousing Workbench. Open the context menu for your advanced DataStore object, choose Start of the navigation path Modeling Next navigation step InfoProvider End of the navigation path and then Manage.
  2. The system now displays all requests that have been loaded to the DataStore object. You can group the requests by day, month or year. The status is displayed as cumulated. The DM flag indicates whether the deltas have already been updated to other connected InfoProviders. No flag is shown for full updates or if no InfoProvider is connected. The TSNs (transaction sequence numbers) are displayed in a monotonously ascending order.
  3. By selecting Display Connections you can view the InfoProviders connected using a DTP, provided that the DTP has already been executed.
  4. Under Manage Archiving, you can create an archiving request.
  5. By double-clicking on a request, you can call the detail view. You can see details about every individual load request here. You can also view logs and call the monitor.
  6. You can activate load requests. You can also activate multiple load requests using a single activation request. To do this, choose Activate.
  7. You can delete load requests. You have the option here of deleting multiple requests at one time.

    Load requests cannot always be deleted. The restrictions are described in relation to modeling templates: Templates for Modeling the Data Warehousing Layers

  8. By double-clicking on a request, you can display the details of the request, a process log and a history.
  9. By choosing Start of the navigation path Environment Next navigation step Display New Data End of the navigation path n the main menu, you can view the content of the inbound table. By choosing Display Active Data, you can view the content of the table of active data. By choosing Display Change Log, you can view the content of the change log.
  10. Choose Start of the navigation path Environment Next navigation step Delete Active Data End of the navigation path in the main menu, in order to delete data from the active table, and if required, rebuild the data later on. This also applies to the data of the inbound table and the change log.
  11. By choosing Start of the navigation path Environment Next navigation step Selective Deletion End of the navigation path in the main menu, you can delete data selectively from the active table.

    You can use selective deletion to delete records from the DataStore object with keys that no more data will be loaded for. This is the case for example if a product is taken out of a product range and no more data is loaded to its product number

    You might also want to delete data that is no longer needed, for example because it is already over three years old. You can also selectively delete data that has errors due to its processing in the BW system. On the other hand, data created with errors in the source system should not be selectively deleted. It should be corrected with reverse postings instead.

    For DataStore objects with the properties Activate Data and Write Change Log, you can also delete data from the change log selectively. These changes can then be rolled back again, and the deletion can be passed on to other connected InfoProviders. This would not be possible if the data in the change log was unchanged.