• 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

Caution Formulas that are in use (on the Business Intelligence|Results, Business Intelligence|Criteria or Business Intelligence|Filters pages) cannot be deleted. When attempting to delete a formula that is in use, no message will be displayed.

To delete a formula from 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.
4. Select the Formulas tab.
   The Business Intelligence|Formulas page appears.
5. Select the 'del ?' check box next to the formula that you want to delete.
6. Click 'Update Details'.
   Formulas that are not in use are removed from the list.
   If a formula is in use, a warning icon () will appear next to the 'Name' field, indicating that the formula is in use. If you want to delete the formula, you must first remove it from the Business Intelligence|Results, Business Intelligence|Criteria or Business Intelligence|Filters pages.
7. Select the Results tab.
   The Business Intelligence|Results page appears.
8. Click 'Apply'
   A window confirms that the application updated the Business Intelligence query.
9. Click 'OK'.