The Saved Bus. Intelligence tab of Business Intelligence and Reports enables you to run BI queries to which you have access.
Your access to the queries on this tab is dependent on the query’s access mode:
▪Public: Anyone can edit, delete, view or run the query.
▪Readable: Anyone can view or run the query. Only the creator can edit and delete the query.
▪Private: Only the creator can edit, delete, view or run the query.
|
Hint You cannot modify saved queries from this tab. |
To run a saved query from Saved Bus. Intelligence tab:
1.Open Business Intelligence and Reports from the Desktop.
2.Select the Saved Bus. Intelligence tab.
The Saved Bus. Intelligence|Saved Queries page appears.
3.Select the query that you want to run from the list.
The Saved Bus. Intelligence|Parameters page appears.
4.Enter your search criteria in the saved list criteria section, if applicable.
5.Complete the following:
a.Extract Template: Enables you to select how the output format of the BI query:
•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 JSON Report Extract (text/json): Return results in JSON.
•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)
b.Extract Row Limit: Enter the number of resulting rows expected for the extract.
c.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 from the Registry
•None: uses no header labels
If the user who created the query specified a label for the header, this will always be used in the extract.
If you want to find out how many records are returned by your query, click 'Count' in the run lists section.
d.If you want to:
▪Preview the results of the query: Select the Preview tab.
The Saved Bus. Intelligence|Preview page appears. It contains a sample preview of the query results
▪Extract the results to Microsoft Excel or to the format that you selected in Step 5: Click 'Extract' and complete the prompts to view or save the file.
