Filtering by SAP BW Member Properties

SAP uses the term member properties to refer to member attributes. You can select SAP BW members and filter them by their member properties. You select the members and then define filtering definitions on the selections.

  To select SAP BW members by their member properties:

  1. In Dimension Browser, select a member.

    The member is displayed in the Selection frame.

  2. Right-click the member, and select Filter on Member Properties.

    The Member Properties dialog box is displayed. The controls at the top prompt you to compose a rule.

  3. From the list, select a member property.

  4. Select an operand.

  5. In the text area, enter a value for the member property.

  6. Click Add.

    You must add the rule to the filter definition for it to be used. You can use multiple rules to create compound definitions.

    Table 19. Advanced Filter on Member Properties Options  

    Option

    Submenu

    Description

    Add

    		 

    Rule added to the filter definition

    Update

    		 

    Rule replaced by another rule

    Remove

    		 

    Rule deleted from the filter definition

    Remove All

    		 

    All rules deleted from the filter definition

    Parenthesis

    Add (

    Open parenthesis inserted at beginning

     

    Add )

    Close parenthesis inserted at end

     

    Remove (

    Open parenthesis deleted

     

    Remove )

    Close parenthesis deleted

    Connect

    And

    AND inserted at end (AND is used by default when multiple rules are added to the definition.)

     

    Or

    OR inserted at end

    Move

    Move Up

    Rule moved up in the filter definition

     

    Move Down

    Rule moved down in the filter definition

  7. Optional: To compose compound definitions, repeat steps 3 through 6.

  8. Click OK.