Maintaining Time-Dependent BI Master Data

Use

The maintenance of the master data is more complex with time-dependent master data, as the validity period of a text is not necessarily in concordance with that of an attribute master record.

The InfoObject User master record has the time-dependent attribute Personnel number, and the time-dependent text User name. If the user name changes (after marriage, for example), the personal number still remains the same.

Prerequisites

In the InfoObject Maintenance, make sure that the relevant InfoObject is flagged as ‘time-dependent’.

Procedure

To maintain texts with time-dependent master data, proceed as follows:

...

1. Select the master data that want, and select one of the three text pushbuttons.

If you choose Display text, a list appears containing all the texts for this characteristic value. By double clicking, you can select a text. A dialog box appears with the selected text for the characteristic value.

If you choose Change text, a list appears containing all the texts for this characteristic value. By double clicking, you can select a text. A dialog box appears with the selected text for the characteristic value, which you can then edit.

If you choose Create text, a dialog box appears in which you can enter a new text for the characteristic value.

The texts always refer to the selected characteristic value.

2. Choose Save.

When you select time-dependent master data with attributes, the list displays the texts that are valid until the end of the validity period of the characteristic value. When you change and enter new texts, the lists are updated.

Master data must exist between the period of 01.01.1000 and 12.31.1000 in the database. When you create data, gaps are automatically filled. When you change or initially create master data, in some cases, you must adjust the validity periods of the adjoining records accordingly.

If a newly created record already exists in the database but does not appear in the processing list (because you have not selected it in the selection screen) there is no check. Instead, the old records are overwritten.

If you change master data in BW, you must adjust the respective source system accordingly. Otherwise the changes will be overwritten in BW the next time you upload data.

Master data, which you have created in BW, remains even after you have uploaded data from the source system.