Tab Page: Master Data/Texts BI InfoObject

Use

On this tab page you specify whether the characteristic can have master data and/or texts.

Structure

With Master Data

Here you specify whether the characteristic has master data. You have to create a master data table for a characteristic if you want the characteristic to have attributes.

When you select this option, the system generates a master data table. You branch to the relevant maintenance dialog by choosing Maintain Master Data.

The master data table can have a time-dependent and a time-independent part. See also Master Data Types: Attributes, Texts and Hierarchies

In attribute maintenance, you specify whether an attribute is time dependent or time independent.

With Texts

Here you specify whether the characteristic has texts.

If you want to use texts with a characteristic, you have to select at least one text. The short text (20 characters) option is set by default but you can also choose medium-length texts (40 characters) or long texts (60 characters).

Language-Dependent Texts

You can choose whether you want the texts in the text table to be language dependent. If you specify that you want texts to be language dependent, the language is a key field in the text table. If you specify that you do not want the texts to be language dependent, there is no language field in the text table.

Some BI Content characteristics, for example customer (0CUSTOMER), do not need to be language dependent.

Time-Dependent Texts

If you want texts to be time dependent (the date is included in the key of the text table), you make the appropriate settings here. See also: Using Master Data and Characteristics That Bear Master Data

Master Data Maintenance with Authorization Check

If you set this indicator, you can use authorizations to protect the master data and texts for this characteristic from being maintained at single-record level. If you activate this option, for each key field of the master data table, you can enter the characteristic values for which the user has authorization. You do this in the profile generator in role maintenance using authorization object S_TABU_LIN.

See Authorizations for Master Data.

If you do not set this indicator, you can only allow access to or lock the entire maintenance of master data (for all characteristic values).

DataStore Object for Checking Characteristic Values

If you create a DataStore object for checking the characteristic values of a characteristic, in the update rules and transfer rules, the valid values for the characteristic are determined from the DataStore object not the master data. The DataStore object must contain the characteristic itself and all the fields in the compound as key figures.

See Checking for Referential Integrity.

Characteristic Is ....

InfoSource:

If you want to use a characteristic as an InfoSource (by means of direct update), you have to assign an application component to the characteristic. The system displays the characteristic in the InfoSource tree in the Data Warehousing Workbench. You can assign DataSources and source systems to the characteristic. You can also load master data, texts, and hierarchies for the characteristic.

In the following cases you cannot use an InfoObject as an InfoSource with direct update:

· The characteristic is characteristic 0SOURSYSTEM (source system ID).

· The characteristic has no master data, texts or hierarchies – there is no point in loading data for the characteristic.

· The characteristic is not a characteristic but a unit or key figure.

For more information, see InfoSource Types.

If you want to generate an export DataSource for a characteristic, the characteristic has to be an InfoSource with direct update; it has to be assigned to an application component.

InfoProvider:

This indicator specifies whether the characteristic is an InfoProvider.

If you want to use a characteristic as an InfoProvider, you have to assign an InfoArea to the characteristic. The system displays the characteristic in the InfoProvider tree in the Data Warehousing Workbench. You can use the characteristic as an InfoProvider in reporting.

You can only use a characteristic as an InfoProvider if the characteristic contains texts or master data.

You can define queries for the characteristic (more precisely, for the master data of the characteristic) if you are using a characteristic as an InfoProvider. In this case, on the Attributes tab page, you can switch on dual-level navigation attributes (navigation attributes for navigation attributes) for this characteristic in its role as an InfoProvider.

For more information see InfoObjects as InfoProviders.

Export DataSource:

If you set this indicator, you can extract the master data, texts, and hierarchies of the characteristic into other BI systems. See also Data Mart Interface.

Master Data Access

You have three options for accessing the master data at query runtime:

...

1. Standard: The system displays the values in the master data table for the characteristic. This is the default setting.

2. Own implementation: You can define an ABAP class to implement the access to master data yourself. You need to implement interface IF_RSMD_RS_ACCESS. You need to be proficient in ABAP OO. An example of this is the time characteristic 0FISCYEAR that is delivered with BI Content.

3. Direct: If the characteristic is selected as an InfoProvider, you can access the data in a source system using direct access. If you choose this option, you have to use a data transfer process to connect the characteristic to the required DataSource and you have to assign the characteristic to a source system.

We recommend that you use the standard default setting. If you have special requirements with regard to reading master data, you can use a customer-defined implementation.

We recommend that you do not use direct access to master data in performance-critical scenarios.