C2020-701 Exam Questions

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

A user is a member of four security groups: A,B,C, and D. For the Budgetcube, group A has WRITE access, group B has READ access, group C has RESERVE access, and group D has a NONE...

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...

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?

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

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 wa...

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

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 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 p...

A customer wants to be able to select elementsfrom a subset for a fixed number of columns. Which statement is correct?

Why would an analyst create a subset?

Which type of subset will ensure the Products dimension includes an up to date list?

Which of the following is used to display elements in different languages for use world-wide?

In the list of accounts, cash accounts are preceded with 100 in the five digit account code. Which of the following can be used as a wildcard character to display only the accounts...

Which of the following can an analyst create to override the public default view when opening a cube?

Each individual month is the leaf element in the month dimension. Which type of filter can an analyst use to create a subset with just the individual months?

A user would like to export data from a TM1 Web Cube View so that subsequent data changes on the TM1 server will not affect the exported data. Which two export options should the u...

A user working within a TM1 Web cube view needs to prevent a leaf cell from being changed by a spread operation. Which command would you use?

A user has invoked the Slice option in a TM1 Cube Viewer. Which TM1 Excel function is generated in each of the data cells?

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

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 int...

In which tier of the IBM Cognos TM1 client-server architecture does the TM1 Administration Server reside?

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

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

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?

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

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 b...

A user wants to update a TM1 cube with string data from an Excel spreadsheet Which TM1 Excel function will allow you to do this?

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 app...

When publishing a IBM Cognos Insight workspace to servers, which three actions can you perform? (Choose three.)

Auser would like to create a view showing the top 10 sales by region. Which type of subset would the user use to accomplish this?

You are asked to prepare next year's budget for your organization. Because of budgetary pressures for the new year, you are instructed to copy last year's budget into the new year...

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

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 pro...

A cube called Salary has two dimensions: Employee and Time. Using cube security, the security group Executive is assigned READ access to the Salary cube. Using element security, th...

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

Which of the following describes a relative proportional spread?

Which of the following may be used to calculate reporting currencies in one cube using rates in another cube?

When budgeting for next year's expenses, rent expense has already been applied to the analysis. How can this value be kept constant while spreading data into other cells?

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 s...

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

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

You want to create TM1 Excel reports. What are two methods to accomplish this? (Choose two.)

Click the Exhibit button. In the Assumptions dimension all key figures are formatted correctly as shown in the exhibit, yet all values are displayed as currency. Wherewould you sea...

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

A user has created a Sandbox based on a cube view. The user wants to have the Sandbox data savedas the base information. What should the user do?

You need to calculate thepossible outcome if prices are raised. However, the data in the IBM TM1 server should not be overwritten. The IBM TM1 model contains many business rules an...

A user wants to interactively stack and unstack dimensions to view. What are two ways to accomplish this? (Choose two.)

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

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.)