Properties of Data Providers 
Definition
Command for a data provider.
Use
A data provider has a great variety of properties. You can change the properties by specifying the parameter and its value. Therefore, you do not have to specify parameter 'CMD'.
The data provider properties are evaluated after the command processing has ended.
Structure
Parameter |
Description |
ZERO_SUPPRESSION ' ' = do not hide any zeros 'X' = hide overall results columns and rows which contain zero values '1' = only hide columns which have zeros in the cross-classified table '2' = only hide overall results columns which contain zeros '3' = only hide rows which have zeros in the cross-classified table '4' = only hide rows and columns which have zeros in the cross-classified table '6' = only hide overall results rows which contain zeros
|
Hide zeros which occur in the inner or outer rows and columns of a cross-classified table. A cross-classified table contains characteristics in both the rows and columns. Example of a cross-classified table: You create a query in which you analyze the net revenue of your products in relation to your customers. The Product characteristic is located in the rows and the Customer characteristic and the key figure Net Revenue 2004 are located in the columns. See also the table below on Zero Suppression for Structures. For more information, see Zero Row and Zero Column Suppression. |
ZERO_PRESENTATION '0' = display '1' = display without currency/unit '2' = do not display '3' = display zero text |
Zero value display |
ZERO_TEXT |
Text for zero value display '3' |
SHOW_SCALING_FACTORS 'X' = Yes, ' ' = No |
Display scaling factors and exclude currency / unit |
SIGN_PRESENTATION '1' = sign before number '2' = sign after number '3' = concatenated display |
+/- sign display |
FULL_CONCAT_KEYS 'X' = Yes, ' ' = No |
Display of characteristic and attribute keys fully concatenated |
SHOW_DOCUMENTS 'X' = Yes, ' ' = No |
Show document links for each characteristic variant |
SHOW_DR_LINKS 'X' = Yes, ' ' = No |
Show Drag&Relate master data |
UHRY_ACTIVE_ROWS 'X' = Yes, ' ' = No |
Display rows as hierarchy |
UHRY_CAPTION_ROWS |
Labeling for rows for hierarchical display |
UHRY_LEVEL_ROWS |
Number of objects (characteristics, hierarchies, structures) on the rows that are initially visible as hierarchy when display is switched on. |
UHRY_ACTIVE_COLUMNS 'X' = Yes, ' ' = No |
Display columns as hierarchy |
UHRY_CAPTION_COLUMNS |
Labeling for columns for hierarchical display |
UHRY_LEVEL_COLUMNS |
Number of objects (characteristics, hierarchies, structures) on the columns that are initially visible as hierarchy when display is switched on. |
Zero Suppression for Structures
Parameter |
Description |
SUPPRESSION 'X' = Yes, ' ' = No |
The structure is included In the zero suppression. |
STRUCTURE_NAME |
Technical name of structure (UID) |
In order to use zero suppression for structures, both parameters have to be specified.
<sap_bw_url data_provider='*' multi='X' structure_name='DTG057U7OQ8K2ALKCMR2AWM14' suppression=’X’>
<sap_bw_url data_provider='*' multi='X' structure_name_1='DTG057U7OQ8K2ALKCMR2AWM14' suppression_1=’X’ suppression_2=’ ‘ structure_name_2=’ EFG057U7OQ8K2JKKCMR2AWM67’>
Integration
The data provider properties can be added to every other command.