IBM Cognos TM1 10.1 Analyst 認定 C2020-701 試験問題:

1. Which three statements are true regarding TM1 Excel functions? (Choose three.)

A) The VIEW function creates an optimized view of the cube specified by the cube argument.
B) The DBR function stands for Database Read.
C) SUBNM returns the element of a dimension subset and allows a double-click to bring up the subset editor.
D) The value returned by the DBRA function cannot be edited.
E) ELCOMP returns the name of a child of a consolidated element in a specified dimension

2. Click the Exhibit button.

Referring to the exhibit, you are asked to allocate overhead expenses to the budget. Currently everything is set to zero. You are instructed to allocate $100,000 to the Communications budget and to distribute the amount equally across all months.
Which three TM1 data spreading operations will allow you to do this? (Choose three.)

A) Equal Leaves Spread and selecting the "Apply to All Leaf Cells" radio button
B) Equal Spread and selecting the "Extend Right" checkbox
C) Relative Proportional Spread
D) Proportional Spread
E) Relative Percent Change

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

A) Expression Base Subset
B) User Defined Subset
C) Filter-based Dynamic Subset
D) Static Subset

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

A) Java Runtime Engine (JRE)
B) DoJo 1.6
C) Adobe Acrobat
D) Microsoft Excel

5. A financial controller wants to create a financial statement report however, the chart of accounts dimension has more aggregations than is required for 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 Wildcard function.
B) Use the Filter by Element function.
C) Use the Filter by Level function.
D) Use the Filter by Attribute function.

質問と回答：