• 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 modify a formula on 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. Modify the applicable fields.
   For more information, refer to Business Intelligence and Reports Business Intelligence-Formulas Page.

   Information If a formula is in use (has been selected in the Result Members) and the 'Name' is modified, the change will automatically be reflected in all of the places where it is being used.

6. When modifying the 'Formula' field, the formula:
   • can only contain numbers, result members and math symbols (i.e. +, -, *, /, (, ), <, >, <=, => and =).
   • must be structurally reasonable (e.g. opening and closing brackets).
   • may include = operator that allows direct assignment of an ouput value that may be alphanumeric.
7. Click 'Add Member' to use a result member as part of the calculation (e.g. seat).
   The New Result Member window appears.
8. Search for and select the result member that you want to insert into your formula.
   Result members that begin with an asterisk (*) are other formulas that have been created. Formulas can be used in other formulas.

   Information You cannot use a result member that returns a GUID. This applies to most ID result members.

9. Complete the remainder of the formula, including mathematical symbols.
10. To verify the formula's results, select the Results tab.
    The Business Intelligence|Results page appears.
11. Click 'Add One'
    The New Result Member window appears.
12. Search for and select the formula that you just created.
    Formula names are prefaced with an asterisk (*).
13. Click 'OK'.
14. Select the Preview tab.
    The Business Intelligence|Preview page appears.
15. The formula and the returned results appear. Ensure that the formula returns the appropriate results.
16. Select the Results tab.
    The Business Intelligence|Results page appears.
17. Click 'Apply'
    A window confirms that the application updated the Business Intelligence query.
18. Click 'OK'.