質問 1：
A client is loading data from an Excel spreadsheet but is not certain whether to enable the Allow query variables in the path and sheet name. What do you tell the client?
A. This feature will enable you to link data across reports.
B. This should never be enabled; it is not a supported function in the current version.
C. This feature needs to be used to be able to load an Excel sheet; if it is not selected, the user will receive an error when trying to complete the load.
D. This feature will provide a dynamic link to Excel source files during the rollover process.
正解：D
質問 2：
A user has created a ##S variable called Netincome for net income in the Statement of Operation object. In a separate Excel object, ##D was used to retrieve the number. However, after saving the object, the ##D value is not populated. What are three reasons why this is happening? (Choose three.)
A. ##D Netincome was used.
B. The user did not refresh data.
C. ##s and ##d were used.
D. ##D is placed within the ##RS/##RE range.
E. ##S Netincome was used at the source.
正解：B,C,D
質問 3：
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
質問 4：
While creating the hierarchy in the Account Hierarchy feature, an end-user realizes that accounts have not been entered in the correct order. Which statement is correct?
A. FSR empowers users to move the accounts within the hierarchy.
B. The user must delete the hierarchy and start over.
C. The user can use the sort sequence feature to re-position the accounts in the hierarchy.
D. The user can use the query variables to change the order of the accounts.
正解：A
質問 5：
FSR users at a company are using a 1 inch margin throughout their report. The users want to maintain a standard margin for all Excel tables. What will the FSR users at the company need to do?
A. All the tables should be created in one Excel object.
B. All the objects are created with a standard 625 pixel count.
C. Each Excel object has ##RS and ##RE tags around the print range.
D. Page Setup margins in each Excel object will need to be manually set to 1 inch.
正解：B
質問 6：
When selecting automatic note numbering, it is important to use a correct note variable naming convention. You should choose a note variable name that corresponds to the line item that will contain the note. For example, if a note will correspond to the line item: receivables from affiliated parties, you would use ##RAP. Using this logic, which two choices are valid note variables? (Choose two.)
A. ##IRE
B. ##WR
C. ##PEOC
D. ##IACS
正解：C,D
A client is loading data from an Excel spreadsheet but is not certain whether to enable the Allow query variables in the path and sheet name. What do you tell the client?
A. This feature will enable you to link data across reports.
B. This should never be enabled; it is not a supported function in the current version.
C. This feature needs to be used to be able to load an Excel sheet; if it is not selected, the user will receive an error when trying to complete the load.
D. This feature will provide a dynamic link to Excel source files during the rollover process.
正解：D
質問 2：
A user has created a ##S variable called Netincome for net income in the Statement of Operation object. In a separate Excel object, ##D was used to retrieve the number. However, after saving the object, the ##D value is not populated. What are three reasons why this is happening? (Choose three.)
A. ##D Netincome was used.
B. The user did not refresh data.
C. ##s and ##d were used.
D. ##D is placed within the ##RS/##RE range.
E. ##S Netincome was used at the source.
正解：B,C,D
質問 3：
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
質問 4：
While creating the hierarchy in the Account Hierarchy feature, an end-user realizes that accounts have not been entered in the correct order. Which statement is correct?
A. FSR empowers users to move the accounts within the hierarchy.
B. The user must delete the hierarchy and start over.
C. The user can use the sort sequence feature to re-position the accounts in the hierarchy.
D. The user can use the query variables to change the order of the accounts.
正解：A
質問 5：
FSR users at a company are using a 1 inch margin throughout their report. The users want to maintain a standard margin for all Excel tables. What will the FSR users at the company need to do?
A. All the tables should be created in one Excel object.
B. All the objects are created with a standard 625 pixel count.
C. Each Excel object has ##RS and ##RE tags around the print range.
D. Page Setup margins in each Excel object will need to be manually set to 1 inch.
正解：B
質問 6：
When selecting automatic note numbering, it is important to use a correct note variable naming convention. You should choose a note variable name that corresponds to the line item that will contain the note. For example, if a note will correspond to the line item: receivables from affiliated parties, you would use ##RAP. Using this logic, which two choices are valid note variables? (Choose two.)
A. ##IRE
B. ##WR
C. ##PEOC
D. ##IACS
正解：C,D
0 お客様のコメント