C2020-701 Online Practice Questions and Answers

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

A user wants to createa TM1 Excel report using the DBRW function.

What are two ways to reference the elements in the dimensions? (Choose two.)

A. Use an Element Name,

B. Use an Element Attribute,

C. Use an Element Alias.

D. Use an Element Index.

A user wants to create a view looking at a particular product called "101 - Chips". They use the "Filter by Wild Card' function to locate the product, but no elements are returned.

Which statement describes what is happening?

A. The user does not firstselect the Hierarchy Sort function.

B. The user does not first select the All function.

C. The user did not first select the Reload Subset function.

D. The user should be using Filter by Level function.

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.

Which three statements are correct about aliases? (Choose three.)

A. Aliases must be unique within the dimension.

B. Subset (user defined consolidation) cannot be the same name as an alias.

C. Aliases can be used for alternative languages.

D. There can only be one aliasper dimension.

E. Aliases must only contain non-numeric string characters.

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

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

An end user wants to interactively create a temporary consolidation that does not exist within the dimension using the TM1 Cube Viewer.

Which action will accomplish this?

A. Create a user defined subset and the roll up takes place automatically.

B. Create a user defined subset and use the Roll Up function.

C. Create a roll up set and insert into a user defined subset.

D. Create a roll up set and insert into a dynamic subset.