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 value of North America is $30.00, with each child value set at $10.00. A user subsequently adds $10.00 to the value of Canada.
Which statement is correct?
A. "North America" increases $10.00, "USA" and "Mexico" remain unchanged.
B. "North America" remains unchanged. "USA" and "Mexico" are reduced by $5.00 each.
C. "North America" remains unchanged, "USA" is reduced by $10.00, "Mexico" remains unchanged.
D. All values are on hold, so the add function is ignored.
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?
A. Save the View but click File > Save As.
B. Click the Save View button.
C. Recalculate the data then click Save.
D. Commit the data to the cube.
Click the Exhibit button.
In the cube shown in the exhibit, you need to show only the five most expensive products. The list should change dynamically with the selection of the budget version.
How would you achieve this?
A. Create a filtered subsetfor products with the option TopSum.
B. Create a view filter with the option TopSum.
C. Create a filtered subset for products with the option TopCount,
D. Create a view filter with the option TopCount.
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.
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 plants are on the columns. Products are consolidated into categories and locations are consolidated into regions.
Which twointerfaces allow them to expand and collapse on both the rows and columns of the analysis? (Choose two.)
A. Active Form
B. Cube Viewer
C. In-Spreadsheet Browser
D. Excel Slice
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 user select? (Choose two.)
A. Slice to Excel
B. Snapshot to Excel
C. Export to PDF
D. Slice to Active Form
How do you configure aTM1 Administration Server to run as a Windows service?
A. Usetm1sd.exe.
B. Usetm1a.exe.
C. Use tm1 admsd.exe.
D. Edit the tmls.cfg file.
When publishing a IBM Cognos Insight workspace to servers, which three actions can you perform? (Choose three.)
A. Publish to a TM1 server as an Excel Report.
B. Publishto a TM1 server as a Responsibility Application.
C. Publish to a TM1 server as a Central Application.
D. Publish to a Cognos 10 B1 server as crosstab reports.
E. Publish to a Cognos 10 B1 server as PowerPlay cubes.
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.)
A. Proportional Spread followed by Percent Change
B. Relative Percent Adjustment
C. Relative Proportional Spread followed byPercent Change
D. Relative Proportional Spread followed by Relative Percent Adjustment
You need to calculate a ratio on all levels in IBM Cognos Insight. Which action would you take?
A. Create a calculation for C and N elements.
B. Create a calculation and set the calculation order to Summarize First.
C. Create a calculation for all elements.
D. Create a calculation and set the calculation order to Calculate First.
