• 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

To add a result member to an existing BI query, complete the following:

1. Open the Business Intelligence and Reports application from the AudienceView Desktop.
2. Select the Business Intelligence tab.
   The Business Intelligence|Search page appears.
3. Search for and select the business intelligence (BI) query that you want to work with. For more information, refer to the Business Intelligence-Search Page and Performing Searches.
   The Business Intelligence|Results page appears.
   The current result members are displayed in the result members section.
4. In the result members section, choose an option:

   If you want to	Then
   add one result member,	Click 'Add One'. Select the result member you want to include. Click 'OK'. You can use the search functionality to find the desired result member. Type the name of the member in the search field and the list is filtered automatically.
   add multiple result members at one time,	Click 'Add Many'. Select the result members you want to include from the list on the left. Click '>>' to move the fields to the selected list. Click 'OK'. You can use the search functionality to find the desired result member. Type the name of the member in the search field and the list is filtered automatically.

   The window closes and the field(s) are added and displayed in the result members section.
   A result member with a plus sign (+) indicates that the item could contain multiple results. For example, the customer 'First Name' field can have multiple results representing all the contacts on the customer account.

5. To define whether to sort, group or total the result member, select the desired option from the 'Srt/Grp/Tot' dropdown. For more information, refer to Sorting, Grouping or Totalling Result Members.
6. To define an aggregate function for the result member, select the desired aggregate from the 'Function' dropdown. For more information, refer to Defining an Aggregate Function.
   If you use an aggregate function, you should enter a 'Heading'; otherwise, the application will create a column header with the name of the function and the database ID used to represent the field as defined in the Registry. For example, COUNT_order_number.
7. If you want to define the column heading for the result member, enter a value into the 'Heading' field.
   If you do not specify a heading, the value displayed in the Name field will be used for previews and PDF extracts. If you extract to Microsoft Excel and do not define a heading, the database column name is used.
8. If you want to create a pivot extract and this result member is to be displayed horizontally or as data, select a value from the Display Type dropdown. For more information, refer to Creating a Pivot Extract (Display Types).
9. To define where to place the result member, enter the numeric value to represent the position in the 'Order' column where 0 is the furthest to the left.
10. Click 'Update Details'.
11. To preview your changes, select the Preview tab.
    The Business Intelligence|Preview page appears.
12. To extract to Microsoft Excel or PDF, refer to Running a Saved Query.
13. If you want to save your changes, expand the save lists and extracts section of the Business Intelligence|Results page and save your changes. For more information, refer to Saving a BI Query.