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 selected department. The user should be
able to select a department and have the rows of the report display just the employees in that
department with the costs across the columns. Employees should be sorted in descending order
based on Total Salary. Unfortunately Salary, Benefits, and Taxes are all stored in different cubes
and the cubes only share the Employee and Department dimensions.
How should you build the Labor Detail report?

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 strategy department 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?

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

A user 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 and
reduce it by 5%. The TM1 cube you are using contains last year’s budgetary data and the new
year element has been added.
Which two TM1 data spreading operations will allow you to do this? (Choose two.)