C2020-702 Exam Dumps

Q31. In Cognos Insight, you have a cube containing the following dimensions with the following members. Products - Pencils, Pens Regions – North, South, East, West Months - Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sept, Oct, Nov, Dec Versions - Actuals, Budget You need to determine which region did not sell any Pencils in January (Jan). Where do you need to set explore points? A. All regi

Q21. Click the Exhibit button. Referring to the entries in the tm1server.log shown in the exhibit, which statement is correct? A. The product dimension has been updated. B. The process Update_Product_Dimension has not created an error log. C. The process Update_Product_Dimension has no parameters. D. The chore Scheduledjmport has completed. Answer: B Q22. You want to improve one TM1 cube

Q11. Click the Exhibit button. A user has requested that you create a cube view displaying individual fruit costs by month formatted as currency with two decimal places. Based on the dimensional information shown in the exhibit, how would you arrange the cube to meet the user's formatting requirement? A. Assign Version on row, Months on columns, Products and Measures in title. B. Assign t

Q31. You develop a new Active Form and would like to format it so that all simple (N-level) cells have a gray background with standard row IDs. Where do you apply the gray formatting? A. To the first data row in the Active Form if Column A = N B. To the first data row in the Active Form if Column A = 0 C. To Format Range 0 in the Format Area D. To Format Range N in the Format Area Answer: D

Q11. In a Turbolntegrator process, you need to create a cube structure before loading data into it. In which tab would you create the cube? A. Epilog B. Metadata C. Data D. Parameters Answer: B Q12. Click the Exhibit button. Referring to the entries in the tm1server.log shown in the exhibit, which statement is correct? A. The product dimension has been updated. B. The process Update_Pro

Q1. A Skipcheck statement appears in the Rules file, however the calculated cells are not fed. What are two results? (Choose two.) A. Leaf level calculated cell values will not be calculated. B. Non-null/non-zero Leaf level calculated cell values will be suppressed by a view's Zero-Suppression property. C. Non-null/non-zero Leaf level calculated cell values will be ignored when imbedded in

Q1. Regarding the persistence of Local, Global, and User variables, which statement is correct? A. Local variables are destroyed when a process exits. B. Global variables are destroyed when a process exits. C. User variables are destroyed when a chore exits. D. Local variables persist as long as the user executing the chore is logged into the TM1 server. Answer: A Q2. Which statement is tr

Q31. Which statement is true for TM1 dimensions? A. TM1 can have dimension hierarchies with only one roll-up/consolidation structure per dimension. B. All dimension attributes must be unique across dimension elements. C. Dimension aliases must be unique across dimension elements. D. Dimension attributes can be either type numeric, type subset, or type string/text. Answer: C Q32. You execut

Q21. Click the Exhibit button. A user has requested that you create a cube view displaying individual fruit costs by month formatted as currency with two decimal places. Based on the dimensional information shown in the exhibit, how would you arrange the cube to meet the user's formatting requirement? A. Assign Version on row, Months on columns, Products and Measures in title. B. Assign t

Q11. You want to export only user-entered non-zero numeric values from a cube. Which three view manipulation functions are required? (Choose three.) A. ViewExtractSkipZeroesSet (exclude zero/null values in export) B. ViewExtractSkipRuleValuesSet (exclude rule calculated values in export) C. ViewExtractSkipStringSet (exclude string values in export) D. ViewExtractSkipCalcsSet (exclude consoli