In a Turbolntegrator process, you need to create a cube structure before loading data into it. In which tab would you create the cube?
If vOriginalDate = July 27, and you require vNewDate = Jul2016, which syntax is appropriate to complete this task?
A. vNewDate=SUBST(vOriginalDate,3,3) | ‘2016’;
B. vNewDate=SUBST(vOriginalDate,3,3) & ‘2016’;
C. vOriginalDate=SUBST(vNewDate,3,3) & ‘2016’;
D. vNewDate=SUBST(vOriginalDate,3,3) + ‘2016’;
Which two statements are true about predefined administrator groups? (Choose two.)
A. Members in the DataAdmin group can create processes.
B. Members in the SecurityAdmin group can view all cube data in read-only mode.
C. Members in the DataAdmin group can view all security settings in read-only mode
D. Members in the SecurityAdmin can create rules to manage security.
You have a cube which contains four regions, North, South, East, and West. You want to clear all data from the West region.
Which method accomplishes this goal?
A. Create a rule that sets values equal to zero.
B. Unload the cube.
C. Clear the cube data using CubeClearData.
D. Zero out the view using ViewZeroOut.
Question : 26
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
Question : 24
You setup a chore to run nightly at 9:00 p.m. The T1 process requires specific parameters to be set.Where do you specify the parameters so that they are applied by the chore?
A. In the default inputs in the T1 process
B. In the Parameter Values in the chore
C. In the T1 process using the ChoreParameterSet( . . ) function
D. In the \}Parameters control cube
Answer : B
Question : 23
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 another leaf level cell rule calculation.
D. Non-null/non-zero Leaf level calculated cell values will not be included in the parent consolidation(s).
Answer : BD
Question : 22
A customer is using TM1 subsets.Which two statements are true? (Choose two.)
A. There are three types of subsets: conventional, static, and dynamic.
B. There are only two access-types for subsets: private and public.
C. In TM1, there is a notion of a default subset that will appear in the system default view
D. Subsets can only contain leaf-level elements.
Answer : BC