• Business Intelligence and Reports - Business Intelligence Pages
  • Business Intelligence and Reports - Business Intelligence|Search Page
  • Business Intelligence and Reports - Business Intelligence|Results Page
  • Business Intelligence and Reports - Business Intelligence|Formulas Page
  • Business Intelligence and Reports - Business Intelligence|Criteria Page
  • Business Intelligence and Reports - Business Intelligence|Filters Page
  • Business Intelligence and Reports - Business Intelligence|Preview Page
• Using Business Intelligence
  • Masking Payment Methods
  • Creating a BI Query
  • Working with BI Criteria
    • Searching for BI Criteria
    • Adding Criteria to a BI Query
    • Example - Customer Query
    • Using Relative Dates and Times with a BI Query
    • Deleting BI Criteria
  • Working with BI Filters
    • Searching for a BI Filter
    • Adding a Filter to a BI Query
    • Example Session Filter - Filtering Customers by Create User
    • Example Filter - Filtering Performances by Venue and Date Range
    • Deleting a BI Filter
  • Working with BI Formulas
    • Creating a BI Formula
    • Modifying a BI Formula
    • Deleting a BI Formula
  • Working with Result Members
    • Adding New Result Members to a BI Query
    • Sorting, Grouping or Totalling Result Members
    • Sorting Results by Data Not Included as a Result Member
    • Defining an Aggregate Function
    • Creating a Pivot Extract (Display Types)
      • Example Pivot Extract -- Customers with Same Last Name in Same City
      • Example Pivot Extract -- Sales by Postal Code
    • Deleting Result Members
  • Running a BI Query
  • AudienceView Charting
    • Creating an AudienceView Chart
    • Example Chart BIs
    • Modifying the Chart Output
    • AudienceView Charting Options
    • Working with AudienceView Charts
    • Saving an AudienceView Chart
    • Printing an AudienceView Chart
    • Emailing an AudienceView Chart
  • Saving a BI Query
  • Saving a BI Query to a Folder (Custom Searches)
  • Scheduling a BI Query
    • Configuration of the Business Intelligence Scheduler
    • Scheduling Business Intelligence Queries
    • Defining the Number of Concurrently Scheduled Queries
  • Creating a Customer Correspondence Extract (Prior to AudienceView 6.8.10)
  • Joining BI Queries
  • Copying a Saved Query
  • Deleting a Saved Query

The Business Intelligence|Results page enables you to define result members for your query. Result members define what data to include in the results of your BI query.

When creating a new query, a default set of result members displays based on the type of BI object.

Information For example, the default result members for a customer BI query include Customer Number, Default First Name, Default Last Name, Default Address. You can modify these default result members and/or add new ones based on your requirements.

If you will be saving your query to a folder for use elsewhere in the application, some folders require certain result members. For more information, refer to Saving a BI Query to a Folder (Custom Searches).

Once you have added result members to your BI query, you can specify whether to sort, group or total the member, create an aggregate function, and/or develop more complex results such as pivot extracts.

The following sections describe how to work with BI result members:

• Adding New Result Members to a BI Query
• Sorting, Grouping or Totalling Result Members
• Sorting Results by Data Not Included as a Result Member
• Defining an Aggregate Function
• Creating a Pivot Extract (Display Types)
  • Example Pivot Extract – Customers with Same Last Name in Same City
    Describes how to create a BI query that searches customers with the same last name in the same city.
  • Example Pivot Extract – Sales by Postal Code
    Describes how to create a BI query that searches for sales by postal code.
• Deleting Result Members