IBM Cognos TM1 10.1 Analyst 試験
Question No : 1
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, the security group Executive is assigned WRITE access to all elements of the Employee dimension.
Using element security, the security group Executive is assigned WRITE access to only 1 element, July, and READ access to all other elements in the Time dimension.
A user of the security group Executive will have which access level when viewing the Salary cube?
Question No : 2
Whenever you open the Sales cube 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.)
Question No : 3
You need to calculate a ratio on all levels in IBM Cognos Insight. Which action would you take?
Question No : 4
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.)
Question No : 5
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?
Question No : 6
When publishing a IBM Cognos Insight workspace to servers, which three actions can you perform? (Choose three.)
Question No : 7
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?
Question No : 8
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?
Question No : 9
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?
Question No : 10
When should you use the DBR formula over the DBRW formula?
Question No : 11
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?
Question No : 12
Which two functions have been optimized for the wide area network (WAN)? (Choose two.)
Question No : 13
How do you configure aTM1 Administration Server to run as a Windows service?
Question No : 14
In which tier of the IBM Cognos TM1 client-server architecture does the TM1 Administration Server reside?
Question No : 15
There has been a number of requests by users to have an option to easily select quarters for their views, rather than having to select the individual quarters every time they go into their views.
Which solution meets this requirement?