• 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 The Scripts|Edit page uses JavaScript only. It is understood that to edit the scripts, you have a basic knowledge of JavaScript and the appropriate tag formats and content.

To alter the type of chart that will be generated when an abstract is run, complete the following:

1. Open the General Configuration application from the AudienceView Desktop.
2. Select the Scripts tab.
   The Scripts|Search page appears.
3. Search for and select the script that you would like to alter. For more information, refer to General Configuration Scripts-Search Page and Performing Searches.
   The Scripts|Edit page appears.
4. Search for the current chart output type (Shockwave Flash file) by pressing CTRL+F, entering .swf and clicking 'Next'.
5. Replace the current chart's file name with the file name of the new chart.

   Information To find all of the available chart types, navigate to the FusionCharts folder within the UI folder (e.g. C:\AudienceView\Builds\audienceview_6_8\UI\FusionCharts). All of the Shockwave Flash files are located here. For more information on the types of available graphs and charts, refer to AudienceView Charting Options.

6. Click 'Apply'
   A pop-up appears indicating that the script has been updated.
7. Click 'OK'.

Information The Bar2D.swf file will create a chart with horizontal bars. If you want to create a chart with vertical bars, select the Column2D.swf or Column3D.swf files.