Reporting - Daniel Preto Questions

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Danielfiliperp
D
Danielfiliperp
Community Contributor
Quizzes Created: 1 | Total Attempts: 60
| Attempts: 60
SettingsSettings
Please wait...
  • 1/10 Questions

    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
Please wait...
About This Quiz

This quiz, titled 'Reporting - Daniel Preto Questions,' assesses knowledge on various aspects of reporting systems including Browser Templates, Ordered Reports, and differences between Server Reports and Browser Templates. It is designed to evaluate understanding of data management and reporting dynamics in a business context.

Reporting - Daniel Preto Questions - Quiz

Quiz Preview

  • 2. 

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

    • The Query Engine is a layer between the Browser Template and the Agresso database, and the Report Engine transforms the results of a server report into an output;

    • 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;

    • 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;

    • There are no differences, they are the same;

    Correct Answer
    A. The Query Engine is a layer between the Browser Template and the Agresso database, and the Report Engine transforms the results of a server report into an output;
    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.

    Rate this question:

  • 3. 
    What will be the results of the following Browser Template? - ProProfs

    1. 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;

    Correct Answer
    A. Account descending, followed by amount, followed by period ascending;
    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.

    Rate this question:

  • 4. 

    5. What is a Data Warehouse?

    • A method of updating Balance Tables;

    • An aggregated Balance Table;

    • A View Balance Table

    • None of the above

    Correct Answer
    A. None of the above
    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.

    Rate this question:

  • 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.

    Correct Answer
    A. In the Maintenance of Ordered Reports (CR16) Status T means a report 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.

    Rate this question:

  • 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

    Correct Answer
    A. When we have the Aggregate Option checked to show the number of rows;
    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.

    Rate this question:

  • 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

    Correct Answer
    A. Only two of the above are true;
    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.

    Rate this question:

  • 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

    Correct Answer
    A. ALL of the above
    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.

    Rate this question:

  • 9. 

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

    • 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 return current data;

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

    • It is possible to schedule a server report, but it is not possible to schedule a Browser Template (using only basic configuration);

    • An Excelerator generated by a Browser Template can be included in the Global Reports Menu, but an Excelerator generated by a Server Report, cannot be included in the Global Reports Menu

    Correct Answer(s)
    A. 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 return current data;
    A. It is possible to schedule a server report, 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.

    Rate this question:

  • 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 should always go to the Common Parameters tab, even if you do not have prompts on the Browser Templates you have added;

    • You can choose individual browser reports to be run automatically;

    • It is possible to save a layout of an Information Page to all users if you are a member of the SUPER role

    Correct Answer(s)
    A. You should always go to the Common Parameters tab, even if you do not have prompts on the Browser Templates you have added;
    A. You can choose individual browser reports to be run automatically;
    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.

    Rate this question:

Quiz Review Timeline (Updated): Jun 6, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Jun 06, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jul 10, 2015
    Quiz Created by
    Danielfiliperp
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.