Why are OLAP variables used in FSR?
A. OLAP variables can be defined globally for a given report and once applied, query variables can fully automate the roll forward process.
B. OLAP variables can be defined locally within a given object and once applied, queries can fully automate the roll forward process.
C. OLAP variables can be defined locally within a given object and once applied, data loads will be automated each time Refresh Data is selected.
D. OLAP variables can be defined globally for a given report and once applied, data loads will be automated each time Refresh Data is selected.
正解:A
質問 2:
A client has started to load data from an OLAP cube through the "Load Data" function. The client wants to use query variables in the "Year" dimension. Which statement is correct?
A. Ensure that the query variables are not checked when selecting data from an OLAP cube.
B. Check on the allow query variables, input the variables into the file path.
C. Query variables are added and edited in the OLAP data wizard.
D. Query variables are automatically added when connecting to an OLAP cube.
正解:C
質問 3:
An end-user at a company is concerned about the validity of the amounts throughout the report. Within FSR, which rule can be used to reconcile the accuracy of the numbers in the report?
A. The checks must be performed manually by the user.
B. The user can use the audit trail feature to reconcile the numbers in the report.
C. The user can create a workflow rule to ensure that the numbers match in the report.
D. The user can create a validation rule to verify the accuracy of the amounts in the report.
正解:D
質問 4:
A user has created a journal entry, but the net difference of the debits and credits is not equal to zero. How can the user adjust the amounts?
A. Export the journal entries, fix the amount in the generated Excel file and re-import the file.
B. Delete the journal entry and create a new one.
C. Click the Reverse Journal Entry button.
D. Click Edit Journal Entry and edit the debit/credit amount for an entry.
正解:D
質問 5:
FSR has numerous ways to bring data into Excel objects into the Database tab.What are three valid methods? (Choose three.)
A. Account Hierarchy
B. Excel file
C. OLAP cube
D. query variables
E. database query
正解:A,B,C
質問 6:
Upon generating the balance sheet Excel object, an end-user realizes that the generated balance sheet object is not generated with the line items containing zeros. Why does this happen?
A. FSR automatically suppresses the line items with zeros.
B. The items do not have the ##NL and ##SL in the column.
C. Dollar ($) signs need to be placed in separate columns.
D. The line items containing zeros need to be merged.
正解:A