Reporting - Daniel Preto Questions

1. 7. What is the result of the following expression:if(yearpart(@voucher_date)=$year(-1), "PASSOU", "NÃO PASSOU")

If the year of the transaction date is equal to the previous year then it will return “NÃO PASSOU”;

If the year of the transaction date is equal to the previous year then it will return “PASSOU”;

It will only return values if the date is from the previous year;

None of the above

If the year of the transaction date is equal to the previous year, the expression will return "PASSOU". This means that if the year part of the @voucher_date is the same as the current year minus 1, the result will be "PASSOU".

Explanation

If the year of the transaction date is equal to the previous year, the expression will return "PASSOU". This means that if the year part of the @voucher_date is the same as the current year minus 1, the result will be "PASSOU".

2. 6. What is the differences between the Report Engine and the Query Engine?

There are no differences, they are the same;

The correct answer explains that the Query Engine acts as a layer between the Browser Template and the Agresso database, while the Report Engine takes the results of a server report and converts them into an output. This implies that the Query Engine is responsible for retrieving data from the database, while the Report Engine is responsible for formatting and presenting the data in a readable format.

Explanation

The correct answer explains that the Query Engine acts as a layer between the Browser Template and the Agresso database, while the Report Engine takes the results of a server report and converts them into an output. This implies that the Query Engine is responsible for retrieving data from the database, while the Report Engine is responsible for formatting and presenting the data in a readable format.

3. 5. What is a Data Warehouse?

A method of updating Balance Tables;

An aggregated Balance Table;

A View Balance Table

None of the above

The given options do not accurately define what a data warehouse is. A data warehouse is a large, centralized repository of integrated and structured data from various sources. It is designed to support business intelligence and analytics activities by providing a reliable and consistent source of data for reporting and analysis purposes.

Explanation

The given options do not accurately define what a data warehouse is. A data warehouse is a large, centralized repository of integrated and structured data from various sources. It is designed to support business intelligence and analytics activities by providing a reliable and consistent source of data for reporting and analysis purposes.

4.

What will be the results of the following Browser Template?

Account ascending, followed by Amount, followed by account ascending;

Account, followed by amount, followed by period;

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

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

The given answer suggests that the results of the Browser Template will be sorted in the following order: first by Account in descending order, then by Amount, and finally by Period in ascending order. This means that the accounts will be listed in descending order, followed by the amounts, and then the periods in ascending order.

Explanation

The given answer suggests that the results of the Browser Template will be sorted in the following order: first by Account in descending order, then by Amount, and finally by Period in ascending order. This means that the accounts will be listed in descending order, followed by the amounts, and then the periods in ascending order.

5. 2. Which of the following sentences are incorrect about Ordered Reports:

Data Control is not effective on Server Reports;

In the Maintenance of Ordered Reports (CR16) Status T means a report was successful;

It is possible for some users to see other users ordered reports if the REP_VIEW parameter is activated;

It is possible to choose the output type of a server report.

The given statement is incorrect because in the Maintenance of Ordered Reports (CR16), Status T means that a report is in transit or being processed, not that it was successful.

Explanation

The given statement is incorrect because in the Maintenance of Ordered Reports (CR16), Status T means that a report is in transit or being processed, not that it was successful.

6. 9. When do you use the "##" in the Browser Templates?

When we have the Aggregate Option checked to show the number of rows;

When we need to make a calculation involving the “Grand Total” of a column;

To sort the order of parameters;

ALL of the above

The correct answer is "When we have the Aggregate Option checked to show the number of rows." In Browser Templates, the "##" is used when the Aggregate Option is checked to display the number of rows. This allows users to see the total count of rows in a particular section or table. It is a helpful feature when analyzing data and understanding the overall quantity of information being presented.

Explanation

The correct answer is "When we have the Aggregate Option checked to show the number of rows." In Browser Templates, the "##" is used when the Aggregate Option is checked to display the number of rows. This allows users to see the total count of rows in a particular section or table. It is a helpful feature when analyzing data and understanding the overall quantity of information being presented.

7. 10. What is the correct answer?

Both Agresso Analyser Template and Analyzer cannot be saved in an Information Page;

Analyzer was made available only after Milestone 4;

Analyzer is a basic tool that allows you to surf the data;

ALL of the above are true;

Only two of the above are true;

None of the above are true

The correct answer is "Only two of the above are true." This means that out of the three statements provided, only two of them are true while the other one is false. The answer does not specify which two statements are true and which one is false, but it confirms that not all three statements can be true simultaneously.

Explanation

The correct answer is "Only two of the above are true." This means that out of the three statements provided, only two of them are true while the other one is false. The answer does not specify which two statements are true and which one is false, but it confirms that not all three statements can be true simultaneously.

8. 8. When we add a posting attribute as a relation to a Browser Template which of the following is correct?

You will be able to change from a left outer join to an inner join by clicking “Change Relation Settings”

As extra field will be automatically added in the SearchC tab;

Option B is also true when you add a tree or a flexi-field

ALL of the above

Adding a posting attribute as a relation to a Browser Template allows for the ability to change from a left outer join to an inner join by clicking "Change Relation Settings". Additionally, an extra field will be automatically added in the SearchC tab. This is also true when adding a tree or a flexi-field. Therefore, all of the statements mentioned in the options are correct.

Explanation

Adding a posting attribute as a relation to a Browser Template allows for the ability to change from a left outer join to an inner join by clicking "Change Relation Settings". Additionally, an extra field will be automatically added in the SearchC tab. This is also true when adding a tree or a flexi-field. Therefore, all of the statements mentioned in the options are correct.

9. 3. Which of the following differences about Server Reports and Browser Templates are CORRECT?

Data Control is not effective in Browser Templates, but it is effective in Server Reports;

A server report ordered by a CR29 window has the data as it was at the time the report was run, in contrast a reporting item based on a Browser Template always returns current data. This means that a server report will display the data as it existed at the time the report was generated, while a Browser Template will always show the most up-to-date information. Additionally, it is possible to schedule a server report to run at specific times, but it is not possible to schedule a Browser Template using only basic configuration.

Explanation

A server report ordered by a CR29 window has the data as it was at the time the report was run, in contrast a reporting item based on a Browser Template always returns current data. This means that a server report will display the data as it existed at the time the report was generated, while a Browser Template will always show the most up-to-date information. Additionally, it is possible to schedule a server report to run at specific times, but it is not possible to schedule a Browser Template using only basic configuration.

Submit

10. 4. When defining an Advanced Information Page and you include a Browser Template which of the following is INCORRECT?

Each column which has a prompt will automatically be defined as a parameter on the information page;

You can choose individual browser reports to be run automatically;

The incorrect statement is "You should always go to the Common Parameters tab, even if you do not have prompts on the Browser Templates you have added." This statement suggests that it is necessary to go to the Common Parameters tab even if there are no prompts on the Browser Templates. However, if there are no prompts, there is no need to access the Common Parameters tab.

Explanation

The incorrect statement is "You should always go to the Common Parameters tab, even if you do not have prompts on the Browser Templates you have added." This statement suggests that it is necessary to go to the Common Parameters tab even if there are no prompts on the Browser Templates. However, if there are no prompts, there is no need to access the Common Parameters tab.

Submit