Reporting

Question 1

1 - Analyzer is a tool which takes its input from the result set of:

a) a standard enquiry
b) a Browser
c) all of the above
d) none of the above

Answer 1

c) all of the above

Question 2

2 - Links from the Browser to other Agresso items are possible

a) True
b) False

Answer 2

a) True

Question 3

3 - When creating expressions in the Browser using the IF function it is possible to
include an OR operator. This is done using the following symbol:
a) &
b) |
c) /
d) !=

Answer 3

b) |

Question 4

4 - In browser setup, when Aggregated is checked, rows are grouped if they have the
same values in some of the non-numerical fields which are shown:
a) True
b) False

Answer 4

b) False

Question 5

5 - Select all of the following which are available in the Browser:

a) direct relations
b) indirect relations
c) trees
d) value matrix
e) flexi-fields
f) other data tables related to the browser

Answer 5

b) indirect relations
c) trees
e) flexi-fields
f) other data tables related to the browser

Question 6

6 - In browser setup, when the “Text/Code” option is selected and Sort is checked, data
will be sorted by the description
a) True
b) False

Answer 6

a) True

Question 7

1. What will be the results of the following Browser Template?
   a) Account ascending, followed by Amount, followed by account ascending;
   b) Account, followed by amount, followed by period;
   c) Account, descending followed by period ascending, followed by amount;
   d) Account descending, followed by amount, followed by period ascending;

Answer 7

d) Account descending, followed by amount, followed by period ascending;

Question 8

2. What is an Agresso data warehouse?
   a) A method of updating Balance Tables;
   b) An aggregated Balance Table;
   c) A View Balance Table
   d) None of the above

Answer 8

d) None of the above

Question 9

3. What is the difference between the Report Engine and the Query Engine?
   a) The Query Engine is a layer between the Browser template and the Agresso
   database, and the Report Engine transforms the results of a Browser enquiry or
   server report.;
   b) The Report Engine is a layer between the Browser Template and the Agresso
   database and the Query Engine transforms the results of a server report into an
   output;
   c) The Query Engine is a link between the database and the server report, and the
   Report Engine is a link between an element type and a database;
   d) There are no differences, they are the same;

Answer 9

a) The Query Engine is a layer between the Browser template and the Agresso
database, and the Report Engine transforms the results of a Browser enquiry or
server report.;

Question 10

7. What are the advantage of the Query Engine?
   a) Eases maintenance
   b) Ensure consistency
   c) Enhance performance
   d) All of the above
   e) None of the above

Answer 10

d) All of the above

Question 11

8. Regarding columns widths, in the Results tab in Browser templates, Select the truth
   statements
   a) The Browser does not set a default column width
   b) Column set can be distributed to other users
   c) A header can be wrapped to several rows automatically

Answer 11

c) A header can be wrapped to several rows automatically

Question 12

9. In Browser templates, delete all fields command affects:
   a) The results tab
   b) The searchC tab
   c) The setup tab
   d) All the above
   e) None of the above

Answer 12

a) The results tab

c) The setup tab

Question 13

10. In Output Browser Results, which outputs can only be saved as a global template and
grand the total of only one value column
a) Excelerator
b) Gauge
c) Analyser
d) Report Creator
e) Worderator
f) Analyzer
g) Chart
h) None of the above

Answer 13

b) Gauge