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.

What are three reasons why you would use Cognos BI Reporting rather than TM1 Web? (Choose three.)

A. You must merge data from different cube sources.

B. You require bursting of reports.

C. You require different report versions.

D. You require data entry capability.

E. You require highlight capability for reports.

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 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 financial controller wants to create a financial statement report however, the chart of accounts dimension has more aggregations than is requiredfor the report. The controller wants to create a subset that has only the sub account and account elements

How should this be accomplished?

A. Use the Filter by Attribute function.

B. Use the Filter by Level function.

C. Use the Filter by Wildcard function.

D. Use the Filter by Element function.

What is the differencebetween a TM1 Sandbox and a Personal Workspace?

A. A Personal Workspace allows you to work in a private area where a Sandbox is shared.

B. A Personal Workspace is a special default unnamed Sandbox where you begin your work.

C. A Personal Workspace is shared.

D. A Personal Workspace does not require you to commit your data as a Sandbox does.

When exporting a cube view from TM1 Web, which prerequisite is required to ensure charts are included?

A. DoJo 1.6

B. Java Runtime Engine(JRE)

C. Microsoft Excel

D. Adobe Acrobat

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.

Whichthree statements are true in regards to the applications folder? (Choose three.)

A. Application folders can be used to publish reports to TM1 Web.

B. Application folders can be used to organize reports.

C. Application folders can be used to store references to URLs.

D. Application folders do not have any security.

E. Application folders are not required for published TM1 Web reports.

There has been a number of requests by users to have an option to easily select quartersfor their views, rather than having to select the individual quarters every time they go into their views.

Which solution meets this requirement?

A. A new public view should be created.

B. A new private subset should be created.

C. A new public subsetshould be created.

D. A new alias should be created.