Restricting the Members Retrieved

When you build a query, you can restrict the members retrieved based on the required number of child nodes, level members, hierarchy levels, hierarchy members, hierarchy child members, property, SAP variable members, or key figures. This provides greater flexibility and enhances performance - particularly for levels containing thousands of level members (common for InfoCubes).

*  To restrict the members retrieved:

  1. On the Query Builder - Fields page, select a tab in the Query Clause section (Filter, Slicer, or SAP Variable).

  2. Select a level member, hierarchy level, hierarchy member, hierarchy child member, property member, SAP Variable member, or key figure and click Range.

  3. In the Select Members dialog box, enter the start and end values for the range and click Retrieve.

    For example, to restrict the data to the first 100 members, you would enter 1 for the start value and 100 for the end value. If you leave the start and end values at their default value of 0, SQR Production Reporting Studio retrieves all of the records.

    When you click Retrieve, the members in the defined range display under Available Members.

  4. (Optional) Further restrict the members retrieved by entering information to perform a wild card search.

    • Low—Enter the low value for the search. For example, to restrict the search to members containing the letter “R”, you would enter R*.

    • High—Optionally, enter a high value for the search.

    • Operand—Use the drop down list to select an operand. For example, to restrict the search to members containing the letter “R”, you would select “contains” as the operand.

    • Flag—Select either Include or Exclude.

      In the example above, restricting the search to members containing the letter “R” would change the members retrieved from Commercial, Residence, and Not Assigned, to Residence.

  5. Specify whether to search using descriptive names or technical names.

    For example, you could search using “Billing Dispute Analyzer” or “TELCO/DSP1.”

  6. (Optional) Further restrict the returned result set for a member under Available Members by selecting the member and clicking Right Arrow button to move the member to Filtered Members.

    Depending on whether your are creating a filter, slicer, or SAP variable, the filtered data appears in the Filter, Slicer, or SAP Variable tab in the Query Clause section of the Fields page.

  7. Click OK to return to the Query Builder - Fields page.