• 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 (Prior to AudienceView 6.8.10)
  • 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.

Hint When updating a preloaded, default BI query it is recommended that you save a copy of the BI and update the copied version.

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.