Editing General Settings

You can define the characteristic's general properties here.

General

1. You can specify whether an attribute view and/or an analytic view should be created for your characteristic in the SAP HANA database. More information: Generating SAP HANA Views for InfoObjects

Dictionary

2. You can edit the data type and the data length.
3. You can specify a conversion routine. More information: Conversion Routines in the BW System
   The conversion routine SNUMC is available for data in integer format (INT4, INT8, DEC). More information: Characteristics of Type Integer
4. You can set the High Cardinality flag. The High Cardinality property allows you to create more than two thousand million characteristic attributes for a characteristic. As a characteristic with high cardinality has a number of restrictions, you should only set this property if you really expect a larger number of characteristic attributes. More information: High Cardinality
5. If you set the Case Sensitive flag, the system differentiates between uppercase letters and lowercase letters when values are entered. If it is not set, the system converts all letters into uppercase letters. No conversion occurs during the load process or during transformation. This means that values with lowercase letters cannot be posted to an InfoObject that does not allow lowercase letters.
   Note

   If you allow lowercase letters, be aware of the system response when you enter variables:

   If you want to use the characteristic in variables, the system is only able to find the values for the characteristic if the lowercase letters and the uppercase letters are typed in accurately on the input screen for variables. If you do not allow the use of lowercase letters, any characters that you type in the variable screen are converted automatically into uppercase letters.

Properties

6. You can specify whether the characteristic should have master data and/or texts. You can then see the Master Data/Texts tab page and can edit the properties displayed there.
7. You can specify whether the characteristic should have hierarchies. You can then see the Hierarchies tab page and can edit the properties displayed there.
8. If you set the Usable as InfoProvider flag, you can also see the Runtime Properties tab page and can make various settings there at query runtime. More information: Query Properties

   For InfoObjects as InfoProviders, you can execute a standard query by choosing BW Reporting Preview in the lower screen area.

9. If you flag the characteristic as authorization-relevant, the authorization check will run whenever the query is worked on. Set the Authorization-Relevant flag for a characteristic if you want to create authorizations that restrict the selection conditions for this characteristic to single characteristic values.
10. If you select Attribute Only, the characteristic can be used only as a display attribute for another characteristic, not as a navigation attribute.

Compounds

11. Under Compounds, you can compound the characteristic with other InfoObjects. Compounding of InfoObjects can be necessary in order to uniquely identify the characteristic. Choose Edit to create a compound.
    Note

    If storage location A for plant B is not the same as storage location A for plant C, you can only evaluate the characteristic Storage Location in connection with once plant. In this case, compound characteristic Storage Location with Plant to make the characteristic unique.