Please enable JavaScript to view this site.

AudienceView Unlimited 7  Product Guides

The following image illustrates the Business Intelligence and Reports - Saved Business Intelligence|Parameters page:

 

BIR-Saved BI-Parameters-7.10

The Saved Business Intelligence|Parameters page allows you to perform counts on the number of results the query will retrieve as well as extract the query results to email, printed output, to the screen or a downloadable file.

The run saved query section of the page allows you to select the format of the query result export. You are able to select options from the following fields:

Field

Description

Extract Template

Select the file template in which you want the extract generated:

 

•A Bar Graph (text/html): Returns results as a standard bar graph.

•A Multi-bar Graph (text/html): Returns results as a graph with multiple bars.

•A Multi-line Graph (text/html): Returns results as a graph with multiple plotted lines.

•A Pie Chart (text/html): Returns results as a standard pie chart. You can explode a slice of the pie chart by clicking on it.

For more information, refer to Generating a Chart.

•Business Intelligence AVDOC Report Extract (text/avdocument): Return results in AVDOC. This template is suitable for emailing.

•Business Intelligence CSV Report Extrac (text/csv)t: Return results in CSV (comma separated values) template. This template is suitable for use in spreadsheets and for importing into another system.

•Business Intelligence HTML Report Extract (text/html): Return results in HTML.

•Business Intelligence XML Report Extract (text/xml): Return results in XML (extensible markup language) template. This template is suitable for importing into another system.

•CSV with count and rank (text/csv):

Max Extract Rows

Enter the number of resulting rows expected for the extract.

info_outline

Information

BI queries will only return the maximum number of results defined in the Registry - Registry::EN::Collection Objects node 'extract_max_rows' field. If the Registry is set to 1,000 and you set the 'Extract Max Row' field to 1,500, only 1,000 results will be returned.

Extract Header

Specify which labels you want to use to represent the result members in the extract’s headers:

•Name: uses the column name from the database

•Label: uses the label as it appears in the result member 'Name' field

•None: uses no header labels

 

If you entered a label for the result member in the 'Heading' field, this will always be used in the extract.

Search Type

Choose the default type of matches you are expecting:

•Match Any: When you want to search for records containing one or more of the search terms you selected.

•Match All: When you want to search for records that contain all of the search terms you selected.

In the saved list criteria section of the page, you are able to enter criteria values for the query. The criteria displayed is the criteria saved as part of the Business Intelligence query.

For more information, refer to Using Saved Business Intelligence.