C2020-701 Online Practice Questions and Answers

How do you configure a TM1 Web application so that users are not prompted for the TM1 Admin Host every time they login?

A. Modify the capability assignments in TM1 Architect.

B. Edit the pmpsvc_config.xml file.

C. Edit the web.config file.

D. Change security on the top-Level application folder from "private" to "public".

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.

What are three reasons why you would choosean Active Form over other report styles? (Choose three.)

A. When the user needs to drill down and drill up on rows

B. When the user needs to drill down and drill up on columns

C. When the user needs to suppress zeros

D. When there is a need to dynamicallyformat cells

E. When the user needs to move dimensions around the report

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.

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.

In TM1 Cube Viewer, you are viewing an Income Statementcube containing dimensions for Department, Months, Budget Version, and Account. Currently, the Account dimension is listed in the rows and the Months dimension is listed in the columns. You want to see a comparison of each element in the Budget Version dimension next to each account.

Which feature in TM1 Cube Viewer will accommodate this requirement?

A. Personal Workspace

B. Sandbox

C. Stacking dimensions

D. Layout Right to Left

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

Which two functions have been optimized for the wide area network (WAN)? (Choose two.)

A. SUBNM

B. DBRW

C. DBSW

D. DBR

An international company has an existing TM1 server application they use for planning, forecasting, and reporting. The corporate strategydepartment wants to share parts of this application with external consultants and partners. They decide to create Cognos Insight workspaces which includes data from this server application combined with additional analysis and content. They intend to distribute a single workspace ".cdd" file to the recipients.

How should they integrate the TM1 server data with additional content resulting in distributable Cognos Insight workspace files?

A. Connect to the server using Distributed Mode, save the workspace and then modify as needed.

B. Drag and drop TM1 cube views and subsets into the workspace, save the workspace and then modify as needed.

C. Connect to the server using Connected Mode, save the workspace and then modify as needed.

D. Import TM1 cube views and subsets, save the workspace and then modify as needed.

Whenever you open the Salescube you see a hierarchical list of all products. The default view consists of default subsets for all dimensions. You would like to see a list of 10 products you are responsible for by default. Which three actions would achieve this? (Choose three.)

A. Create a private default subset for the product dimension and leave the default view unchanged.

B. Create a private default subset for the product dimension and leave the default view unchanged,

C. Create a private named subset for the product dimension and create a private named view using it.

D. Create a private named subset for the product dimension and create a private default view using it.

E. Create a private default subset for the product dimension and create a private default view using it.