Which of the following element types identifies the lowest level in a dimension hierarchy?
A. String
B. Attribute
C. Consolidation
D. Simple
The sales report needs to use the current price of cars in the pricing cube in order to calculate the current revenue in the sales cube.
Which of the following should the application developer use to create this calculation so that it is continuously updated?
A. VBA
B. Rules
C. Microsoft Excel
D. Turbo Integrator
Which of the following is the best location to calculate a formula once a month, when the data is updated?
A. Rule
B. Hierarchy
C. Turbo Integrator
D. Relational Database
Why would an application developer compute Gross Margin in a dimension hierarchy?
A. To use the fast consolidation engine.
B. To use a feeder.
C. To store the data in a specific cell in the cube.
D. To optimize a rule.
When creating a drill process to drill to data from an external source, which of the following must be created?
A. An ODBC connection.
B. A process to read the data into a cube.
C. A cube containing the data.
D. A view of the data.
Which of the following specifies the connection information for a drill through process?
A. Drill assignment rule
B. Rule file
C. Control cube
D. Drill process
Which of the following can be used to load data directly from Microsoft Excel?
A. Processing worksheets
B. ODBC
C. Rule worksheets
D. ODBO
Once the budget is complete, the final version must be moved from the budgeting cube into a read-only reporting cube.
Which of the following data sources should be used in the TI process to move this data?
A. ODBC
B. ODBO
C. Excel Worksheet
D. TM1 View
When an application developer constructs a cube, what is the minimum number of dimensions the cube must contain?
A. 1
B. 2
C. 3
D. 4
Why would an application developer apply a numeric attribute to an element?
A. To store a numeric code for the color of a product.
B. To display the account number instead of the account name.
C. To display the values in an alternate format.
D. To store the square footage of a store for capacity planning.