Reporting - Daniel Preto Questions

10 Questions | Total Attempts: 53

SettingsSettingsSettings
Reporting - Daniel Preto Questions - Quiz

.


Questions and Answers
  • 1. 
    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;

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

      Data Control is not effective on Server Reports;

    • B. 

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

    • C. 

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

    • D. 

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

  • 3. 
    3. Which of the following differences about Server Reports and Browser Templates are CORRECT?
    • 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;

    • B. 

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

    • C. 

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

    • D. 

      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

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

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

    • B. 

      You should always go to the Common Parameters tab, even if you do not have prompts on the Browser Templates you have added;

    • C. 

      You can choose individual browser reports to be run automatically;

    • D. 

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

  • 5. 
    5. What is a Data Warehouse?
    • A. 

      A method of updating Balance Tables;

    • B. 

      An aggregated Balance Table;

    • C. 

      A View Balance Table

    • D. 

      None of the above

  • 6. 
    6. What is the differences 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 server report into an output;

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

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

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

    • B. 

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

    • C. 

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

    • D. 

      None of the above

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

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

    • B. 

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

    • C. 

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

    • D. 

      ALL of the above

  • 9. 
    9. When do you use the “##” in the Browser Templates?
    • A. 

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

    • B. 

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

    • C. 

      To sort the order of parameters;

    • D. 

      ALL of the above

  • 10. 
    10. What is the correct answer?
    • A. 

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

    • B. 

      Analyzer was made available only after Milestone 4;

    • C. 

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

    • D. 

      ALL of the above are true;

    • E. 

      Only two of the above are true;

    • F. 

      None of the above are true

Back to Top Back to top