The Data Warehousing Workbench is the central point of entry when managing most Data Warehouse Management processes. It provides tools and functions for metadata and process management.
Data Warehouse Management in BI incorporates various tools and functions:
You use process chains, you can automatically control load processes, the further processing of data in BI, and additional central processes in BI. The scheduler is the tool that defines the load process in BI. You can monitor the requests for load and data transfer processes using the respective monitors.
In InfoProvider administration, you can display technical information about the content of the InfoProvider. This provides information on the requests that are already in the InfoProvider and allows you to rebuild InfoProviders.
Information Lifecycle Management allows you to classify data according to how current it is and archive it as required. This simplifies the administration of the data warehouse and improves performance.
To ensure that the data warehousing solution represents the structure of your company and fulfills its requirements, you have to define who has access to which data.
An authorization allows a user to perform a certain activity on a certain object in the BI system. There are two different concepts for this depending on the role and tasks of the user: standard authorizations and analysis authorizations.
Information on BI objects (metadata, master data, InfoProvider data) can be managed in the form of documents. In Reporting, documents can be created, displayed and found using full-text search. In the Documents functional area of the Data Warehousing Workbench, in addition to the functions for creating, importing and exporting documents and searching within documents, there are also functions for the administration of BI document management.
In the Translation functional area of the Data Warehousing Workbench, you can translate short and long texts for BI objects.
Transport system: BI development projects are not usually implemented in a productive system, but in a system landscape with one or more development and test systems. Using the transport connection, you can collect newly created or changed BI objects in the respective development system and then transport it into the required target system (usually a test or productive system) using the Change and Transport Organizer (CTO).
The concept of transporting and using SAP objects in various versions, which is used in the transport system, is also relevant for the delivery and usage of Business Content.
SAP delivers Business Content in the SAP Delivery Version (D version). This means that modified or active objects are not changed when you install or import the delivered Business Content.
During import of customer transports into the target system, the objects are imported either directly into the active version (A version) or into a modified version (M version). Customer-specific changes are also saved in the modified version (M version). In order to be able to use the Business Content that has been delivered or changed according to customer specifications, a customer has to convert the desired objects to an active version (A version).
The Install Business Content functional area of the Data Warehousing Workbench allows you to select (or “collect”) the objects from the Business Content that is supplied by SAP and activate (or “install”) them. This allows customers to determine which objects from Business Content they want to copy, compare with customer-specific modified objects or those that they do not want to install. The system automatically includes all necessary objects as well as the sequence of their activation.
Content that is delivered to business areas by a BI customer or consulting partner is referred to as Customer and Partner Content. The functionality of customer or partner content complements and enhances the options for using the Business Content delivered by SAP.
In BI, Technical Content is delivered along with Business Content. On the one hand, this includes objects that allow you to analyze the processes in the BI system and to optimize them for performance (BW statistics, BW data slices, BW features characteristics) On the other hand, technical content also includes special DataStore objects that provide data for BEx personalization, for example, or for generating analysis authorizations.
BW Statistics provide data for reporting from the data warehousing (warehouse management) and OLAP areas from several BW statistic InfoCubes using a BW Statistic MultiProvider Within technical content, appropriate BW statistic queries and diagrams are also supplied for the evaluation of data.
An extensive Analysis and Repair Environment is available for performing consistency checks on the data and metadata stored in a BI system.