Fonction SAP BAPI_MDPROVIDER_GET_MEMBERS - Delivers a List of MEMBERS

Paramètre Reférence Type Long. Valeur par déf. Facultatif Description
ALL_PROPERTIES BAPI6111GEN-ALL_PROPERTIES C 1 SPACE X All Properties Wanted
CAT_NAM BAPI6110LVL-CAT_NAM C 32 X Restriction: CAT_NAM
CUBE_NAM BAPI6110LVL-CUBE_NAM C 70 X Restriction: CUBE_NAM
DIM_UNAM BAPI6110LVL-DIM_UNAM C 32 X Restriction: DIM_UNAM
END_ROW BAPI6110MEM-MEM_ORDINAL N 6 X General reference field for numbering
HRY_UNAM BAPI6110LVL-HRY_UNAM C 65 X Restriction: HRY_UNAM
LVL_NUMBER BAPI6111GEN-CHAR2RESTR C 2 X Restriction: LVL_NUMBER
LVL_UNAM BAPI6110LVL-LVL_UNAM C 108 X Restriction: LVL_UNAM
MEM_CAP BAPI6110MEM-MEM_CAP C 60 X Restriction: MEM_CAP
MEM_NAM BAPI6110MEM-MEM_NAM C 64 X Restriction: MEM_NAM
MEM_TYPE BAPI6111GEN-CHAR2RESTR C 2 X Restriction: MEM_TYPE
MEM_UNAM BAPI6110MEM-MEM_UNAM C 143 X Restriction: MEM_UNAM
SET_NAME BAPI6110NST-SET_NAME C 70 X Tensor processor command parameter
START_ROW BAPI6110MEM-MEM_ORDINAL N 6 X General reference field for numbering
TREEOP BAPI6111GEN-CHAR2RESTR C 2 X Restriction: Treeoperator

Paramètre Reférence Type Long. Description
RETURN BAPIRET2 u 548 BAPI Return Parameter
STATISTIC BAPI6111STT u 25 BI Statistics

Paramètre Reférence Long. Facultatif Description
MEMBERS BAPI6110MEM 513 Resulting Set: MEMBERS
OPTIONAL_PROPERTIES BAPI6110PRPVAL 96 X Resulting Set: Properties
RESTRICTIONS BAPI6110RES 161 X Restrict to a Characteristic
SELECTED_PROPERTIES BAPI6110PRPNAM 30 X Selection of Wanted Properties

Functionality
This method returns a quantity of members according to the specifiedrestrictions. For CAT_NAM, CUBE_NAM, DIM_UNAM, HRY_UNAM, LVL_UNAM,MEM_NAM, MEM_UNAM, MEM_CAP, there are are corresponding values to useas with other methods for MD_SCHEMA objects.
A feature of import fields for the restrictions is to be noted forLVL_NUMBER, MEM_TYPE and TREEOP. These fields refer to the fieldBAPI6111GEN-CHAR2RESTR and are of type CHAR with a length of 2. In thisway you can decide whether no restrictions, for example, to LEVEL havebeen set or a restriction with LEVEL 0 is required. This would not bepossible using the corresponding NUMC types.
The following features for the tree operator are supported:
MDTREEOP_CHILDREN ,,,,= 1
MDTREEOP_SIBLINGS ,,,,= 2
MDTREEOP_PARENT ,,,,= 4
MDTREEOP_SELF,,,,,,= 8
MDTREEOP_DESCENDANTS ,,= 16
MDTREEOP_ANCESTORS,,= 32
The values can be combined by addition. MDTREEOP_CHILDREN +MDTREEOP_SELF = 1 + 8 = 9
In this instance, the member specified by MEM_UNAM would be returned aswould its children.
The restrictions have to restrict at least one particular dimension.Several restrictions are interpreted to mean that they are linkedtogether with AND.
Using the table SELECTED_PROPERTIES, the provider can enter aparticular number of properties (attributes) that are required for theselected members in the resulting quantities.
With the ALL_PROPERTIES flag, the client can specify that allproperties are required. If this flag is not set, theSELECTED_PROPERTIES table is interpreted and no properties are returnedif this is empty.

1688917TREXOPS for not being considered from MDX/F4
1701000MDX: Incomplete display of values for 0FISCPER3
1648779Restrictions work incorrectly in BAPI_MDPROVIDER_GET_MEMBERS
1567394MDX: Consulting note for sort sequence
1608724MDX:BAPI_MDPROVIDER_GET_MEMBERS: Structure: Members missing
1540583MDX: Missing restrictions via the label
1517091MDX: BAPI_MDPROVIDER_GET_MEMBERS: Runtime for CP and NP
1528869MDX: BAPI_MDPROVIDER_GET_MEMBERS, CP/NP, Prty Member_Caption
1508719MDX: Variables and compounded characteristics
1524724MDX: BAPI GET_MEMBERS, duplicate display of Self member
1494861MDX: Restricting to # does not work for NUMC
1162349OLE DB for OLAP: Restriction on text and performance
1090781OLE DB for OLAP: Incomplete member rowset
1063767Various minor MDX errors
1047852Selection in MEMBERS rowset for [measures] or structures
971837Time dependency in the MDX execution
973002BAPI_MDPROVIDER_GET_MEMBERS and RESTRICTIONS parameter
971835No values for BAPI_MDPROVIDER_GET_MEMBERS
934144Missing values with BAPI_MDPROVIDER_GET_MEMBERS
898640Fixed filters, variables and BAPI_MDPROVIDER_GET_MEMBERS