In Cognos Insight, users can perform which two functions? (Choose two.)
A. Generate an Excel slice.
B. Run scripts from an Action Button.
C. Import data,
D. Publish model.
正解:C,D
質問 2:
A user entering 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" remains unchanged, "USA" is reduced by $10.00, "Mexico" remains unchanged.
B. All values are on hold, so the add function is ignored.
C. "North America" remains unchanged. "USA" and "Mexico" are reduced by $5.00 each.
D. "North America" increases $10.00, "USA" and "Mexico" remain unchanged.
正解:C
質問 3:
A company uses Excel 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 slices from multiple TM1 cubes.
Which two changes will improve performance? (Choose two.)
A. Convert all DBRW() functions to DBR() functions.
B. Convert all DBR() functions to DBRW() functions.
C. Convert all DBRA() functions to DBRW() functions.
D. Make all DBRW() functions reference a single VIEW function.
正解:B,C
質問 4:
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. Static Subset
C. User Defined Subset
D. Filter-based Dynamic Subset
正解:D
質問 5:
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. Relative Percent Change
C. Equal Spread and selecting the "Extend Right" checkbox
D. Proportional Spread
E. Relative Proportional Spread
正解:A,C,D
質問 6:
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?
A. WRITE access to all cells
B. WRITE access to July cells only
C. READ access to all cells
D. READ access to July cells only
正解:C