Once you have created your BI query, you can save the query. When you save a query, you can choose how others will be able to work with the query by defining the Access Mode. Once you have saved the query, it becomes available from the Saved Bus. Intelligence tab or from the Business Intelligence tab.
By saving a BI query to a specific folder you can make the query available for use elsewhere in the application. For example, saving a customer query to the Saved Customer Search folder, makes the query accessible as an advanced search in the Customer Services - Customer|Search page.
Customer queries can also be saved so you can generate a message extract.
Saved Business Intelligence makse BI queries available to other users without allowing them to view, create or delete BIs.
You do not need to save a BI query to run it; however, for troubleshooting purposes, it is useful to save the BI.
To save a BI query:
1.With the BI that you want to save open, select the Results tab.
The Business Intelligence|Results page appears.
2.Expand the save lists and extracts section.
3.Use the table below to complete the fields in this section:
•Name: Enter a unique name for the saved query.
•List Description: Enter a description of the query. This will be displayed as users mouse-over the query on the Business Intelligence|Search page, Saved Bus. Intelligence|Saved Queries page and elsewhere in the application.
For example, you might include the creation date, the department for which it is used, how often it is used and if and when it can be deleted.
•Access Mode: Specify who can view, run and modify the query after it is saved.
If you do not select a mode in this field, it defaults to Public.
oPrivate: The extract can only be viewed, run, modified and copied by the user who created it.
oPublic: The extract can be viewed, run, modified and copied by other users.
oReadable: The extract can be viewed, run and copied by other users, but can only be updated by the creator.
If you are creating a customer correspondence extract, this field does not affect who can view resulting extracts visible from the Extracts|Search page.
•Folder: Enables you to make the query available from other areas of the application. For more information, refer to Saving a BI Query to a Folder (Custom Searches).
•Extract Format: Select the file format in which you want the extract generated:
oCSV: Return results in CSV (comma separated values) format. This format is suitable for use in spreadsheets.
oPDF / AVDocument: Returns results in a PDF. This format is suitable for printing and emailing.
oXML: Return results in XML (extensible markup language) format. This format is suitable for loading into an XML database.
•Extract Row Limit: Enter the number of resulting rows expected for the extract.
•Extract Header: Specify which labels you want to use to represent the result members in the extract’s headers:
oName: Uses the column name from the database
oLabel: Uses the label as it appears in the result member 'Name' field.
oNone: 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.
4.To schedule the BI query to run at specific times, complete the schedule saved bi section.
5.To define how you want to run the query, complete the run lists section.
6.Click 'Create' or 'Apply'.
A window confirms that the query was created or updated.
7.Click 'OK'.
Alternatively, you can fill in the fields in the run lists, result members, sorting options and saved list criteria sections on the Business Intelligence|Results page before clicking 'Create'.
