A developer added a manuallevel in the time dimension. During category generation, the developer gets a warning that Transformer is not able to relate the categories to the parent levels. What must be done to ensure Transformer relates the categories correctly?
A. Specify a date function for each level.
B. Specify date input format.
C. Specify an Invalid Dates category.
D. Specify a time-state rollup.
What can be done if a regular time dimension is added to a model, and the levels Year, Quarter,and Month are not automatically generated?
A. Set the date input format for the time dimension.
B. Set the data class of the source category to Date.
C. Change the numeric time sequence for each level.
D. Create a non-standard time dimension with thenew levels.
For a cube that represents values in Euros, what should be done for American consumers to see the appropriate currency symbol in Euros?
A. Build Cubes using a system locale that matches the measure locale.
B. Manually create and update the base currency information.
C. Set up currency conversion without defining a default currency.
D. Use more than one data source to supply the conversion rates.
To add dimensional data to an existing model, how can metadata be leveraged from other published OLAP packages?
A. Insert an OLAP package in the data source list.
B. Import a PowerCube as a data source.
C. Add dimensions from an OLAP package in the dimension map.
D. Add a data source query using a Cognos 10 OLAP report.
How can a developer rebuild an incrementally updated cube?
A. Enabletime-based partitioning and rebuild the cube.
B. Clean house and rebuild the cube.
C. Save the model, and revert to the backup .mdl file.
D. Delete the old .mdc file and recreate the entire cube.
At the beginning of the fiscal year, the Camping Equipment product line reduced the number of products that are being sold. What can be done to remove the inactive categories that are no longer needed in the model?
A. Set the level inclusion to suppress categories that are not needed.
B. Incrementally update the Powercube.
C. Prevent the automatic generation of new categories.
D. Generate the categories.
How is the PowerCube updated once changes are made to a custom view?
A. The cube must be rebuilt.
B. The custom view should be re-defined.
C. The changes are automatically updated.
D. Security objects must be re-assigned.
What can be created if the financial analyst wants to look at the data by fiscal year, while the senior manager wants to analyze the data by calendar year?
A. An alternate hierarchy in the time dimension.
B. A subdimension in the time dimension.
C. A special category.
D. A calculated category.
What must be unique to create an alternate hierarchy?
A. The top level
B. The highest level in a dimension
C. The lowest level in adimension
D. The level of convergence
When there are too many childcategories, what can be created to allow intermediate groupings?
A. A cube group
B. An alternate drill-path
C. A manual level
D. A subdimension
