• 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
  • Joining BI Queries
  • Copying a Saved Query
  • Deleting a Saved Query

Any query that has been saved can be copied to make a new query with a different name, which can then be modified. This is useful when you are creating a new query that is very similar to a query you have already saved or to modify a query created by another user.

Information You can only view and copy a query created by another user if it was saved as Public or Readable.

To copy a saved 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 query 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. Expand the save lists and extracts section.
5. Enter a name for the new query in the 'Name' field.
6. Modify the query as desired.
   For more information, refer to:
   • Working with Result Members
   • Working with BI Criteria
   • Working with BI Filters
7. Click 'Save Copy'.
   A window confirms that the application created the query.
8. Click 'OK'.

You do not need to save your changes to view or extract the results. For more information, refer to Working with BI Criteria, Working with BI Filters and Working with Result Members.