C2020-701 Online Practice Questions and Answers

A company usesExcel workbooks to access IBM Cognos TM1 data over a wide area network. The company needs to improve the performance of their Excel workbooks which contain multiple slices from multiple TM1 cubes.

Which two changes will improve performance? (Choose two.)

A. Convert all DBR() functions to DBRW() functions.

B. Make all DBRW() functions reference a single VIEW function.

C. Convert all DBRA() functions to DBRW() functions.

D. Convert all DBRW() functions to DBR() functions.

A TM1 Application Web user has completed data input. Which action allows the user to lock the data for review?

A. Commit

B. Save

C. Release ownership

D. Submit

You have entered new planning data into a TM1 Model and all figures are blue. Which statement is correct?

A. The numbers are in the base cube andneed to be submitted before seen by others.

B. The numbers are in the base cube and need to be committed before seen by others.

C. The numbers are in a Personal Workspace and need to be committed before seen by others.

D. The numbers are in a Personal Workspace and need to be saved before seen by others.

You want to create TM1 Excel reports.

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

A. Build from Excel directly

B. Use the Slice to Excel button

C. Export Cognos Insight report to Excel

D. Use the TM1 Excel wizard

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.

What data spreading options are available to users in the Perspectives or Architect Cube Viewer? (Choose two.)

A. Repeat

B. Straight Line

C. Increase

D. Decrease

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.

When usingthe suppress zero option in a cube view, data that is in an aggregated or calculated value but still zero will display as what?

A. Highlighted in blue

B. Zeros

C. Hidden

D. Bold text

Which three statements are true regardingTM1 Excel functions? (Choose three.)

A. The VIEW function creates an optimized view of the cube specified by the cube argument.

B. The DBR function stands for Database Read.

C. The value returned by the DBRA function cannot be edited.

D. ELCOMP returns the name of a child of a consolidated element in a specified dimension

E. SUBNM returns the element of a dimension subset and allows a double-click to bring up the subset editor.

A Private TM1 Cube View can be shared with which group?

A. Public

B. Only to the creator

C. Administrators D. Only to directory managers

The manufacturing department interacts with IBMCognosTM1 data using TM1 Perspectives. They want to view data by product and location. Products are on the rows of the analysis and plants are on the columns. Products are consolidated into categories and locations are consolidated into regions.

Which twointerfaces allow them to expand and collapse on both the rows and columns of the analysis? (Choose two.)

A. Active Form

B. Cube Viewer

C. In-Spreadsheet Browser

D. Excel Slice

Click the Exhibit button.

Referring to the exhibit, you are asked to allocate overhead expenses to the budget. Currently everything is set to zero. You are instructed toallocate $100,000 to the Communications budget and to distribute the amount equally across all months.

Which three TM1 data spreading operations will allow you to do this? (Choose three.)

A. Proportional Spread

B. Equal Spread and selecting the "Extend Right" checkbox

C. Relative Proportional Spread

D. Equal Leaves Spread and selecting the "Apply to All Leaf Cells" radio button

E. Relative Percent Change

A subset was created using the Expression Recorder. The user modified the subset.

What is the resulting change to the subset?

A. The subset is dynamic.

B. The subset is static.

C. The subset must be renamed.

D. The subset is temporary.

A company wants to deploy an application of summary level data with drill through capability to the underlying transaction detail.

Which interface should be used?

A. Active Report

B. TM1 Web

C. Cognos Insight Connected

D. Cognos InsightDisconnected

You need to calculate a ratio on all levels in IBM Cognos Insight. Which action would you take?

A. Create a calculation for C and N elements.

B. Create a calculation and set the calculation order to Summarize First.

C. Create a calculation for all elements.

D. Create a calculation and set the calculation order to Calculate First.