C2020-701 Online Practice Questions and Answers

What must a TM1 Application Web user do to perform what-if analysis on budgetamounts, without affecting the current version of the data?

A. Export to Cognos Insight.

B. Create a Sandbox.

C. Slice to Excel.

D. Create a scenario.

A userentering numerical data into TM1 Application Web places a hold consolidate on North America with three children: Canada, USA, and Mexico. At the time the hold is placed, the value of North America is $30.00, with each child value set at $10.00. A user subsequently adds $10.00 to the value of Canada.

Which statement is correct?

A. "North America" increases $10.00, "USA" and "Mexico" remain unchanged.

B. "North America" remains unchanged. "USA" and "Mexico" are reduced by $5.00 each.

C. "North America" remains unchanged, "USA" is reduced by $10.00, "Mexico" remains unchanged.

D. All values are on hold, so the add function is ignored.

A user wants to interactively stack and unstack dimensions to view.

What are two ways to accomplish this? (Choose two.)

A. Use an Excel slice generated from TM1 Cube Viewer.

B. Use TM1 Cube Viewer.

C. Use In-Spreadsheet Browser.

D. Use an Active Form generated from TM1 Cube Viewer.

Click the Exhibit button.

In the cube shown in the exhibit, you need to show only the five most expensive products. The list should change dynamically with the selection of the budget version.

How would you achieve this?

A. Create a filtered subsetfor products with the option TopSum.

B. Create a view filter with the option TopSum.

C. Create a filtered subset for products with the option TopCount,

D. Create a view filter with the option TopCount.

Which three selections are available when filtering a TM1 cube view? (Choose three.)

A. TopCount

B. Max

C. BottomPercent

D. BottomSum

E. GreaterThan

A user wants to update TM1 data within a Microsoft Excel worksheet. What are the three ways to do this? (Choose three.)

A. Create an Active Form from within TM1 Cube Viewer.

B. Createa Snapshot from within TM1 Cube Viewer.

C. Create a Sandboxfrom within TM1 Cube Viewer.

D. Select In-Spreadsheet Browser from within TM1 Perspectives.

E. Create an Excel Slice from within TM1 Cube Viewer.

A user requires the use of the "Insert Subset" operation to create a user-defined consolidation in the TM1 Subset Editor. Which TM1 user interface would be used to do this?

A. TM1 Contributor

B. TM1 Websheet

C. TM1 Explorer

D. TM1 Web Cube Viewer

How do you configure aTM1 Administration Server to run as a Windows service?

A. Usetm1sd.exe.

B. Usetm1a.exe.

C. Use tm1 admsd.exe.

D. Edit the tmls.cfg file.

When should you use the DBR formula over the DBRW formula?

A. When you only want users to read the data

B. When a cell must be calculated prior to beingreferenced

C. When referencing a SUBNM formula

D. When using Active Forms

The human resources department requires a TM1 Web Labor Detail report which shows Total Salary, Benefits, and Taxes for each employee within a selecteddepartment. The user should be able to select a department and have the rows of the report display just the employees in that department with the costs across the columns. Employees should be sorted in descending order based on Total Salary. UnfortunatelySalary, Benefits, and Taxes are all stored in different cubes and the cubes only share the Employee and Department dimensions.

How should you build the Labor Detail report?

A. Use three slices, one for each of the source cubes and combine using Excel formulas.

B. Use one slice with zero suppression for Salary and two snapshots for the other cubes.

C. Use an Active Form.

D. Use the In-Spreadsheet Browser.