Queries are used in Web Intelligence to access data. Rather than having to know the specifics of formal Structured Query Language (SQL), you only need to know which universe the data that you want is stored in, the data object requested, and its basic relationships to get started.
Reports are built in the Query Panel using Report objects.
Note: Report Designer times out after 20 minutes of inactivity.
In this example, you are going to create a report listing the amount expended on items received during a given time period. This report uses the following objects in the Acquisitions universe:
If you save your custom report, it will be available in search after 24 hours.
Run time: 7:38
Learn how to use WorldShare Report Designer to create a simple report.
Run time: 7:34
This video demonstrates how to sort and format reports, including switching between portrait and landscape modes, aligning and wrapping text, and repeating a table header on each page.
Run time: 6:31
This video demonstrates using functions to calculate sums, counts, or averages in a report; inserting breaks to calculate subtotals; and creating simple formulas.
Run time: 5:32
In this video you will learn why and how to add input controls to a report in WorldShare Report Designer.
Run time: 8:30
After watching this video, you will be able to determine when to use a variable, differentiate three kinds of variables, and create and use variables in reports.
Run time: 5:58
After watching this video, you will be able to select a chart type, add a chart to a report and format it, and turn a table into a chart.