COG-635 - IBM Cognos 10 BI OLAP Developer
Go back to IBM
What sholud a developer do if some levels appear red after validating the model using show scope?
Specify a valid relationship betwen the level and the data source.
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?
Set the level inclusion to suppress categories that are not needed.
When there are too many child categoies, what canbe created to allow intermediate groupings?
A manual level
How is the Powercube updated once changes are made to a custom view?
The cube must be rebuild
Columns have been renamed in the data source. Which command must the developer run to update the model?
A developer create a cube each regional Sales Manager. Each cube should contain only the transactional details for each Sales Manager's region,, as well as the summarized values for each other regions. What should be created?
How can the parent-child relationship for each category be established?
Generate the categories.
As a good practice, what can a developer do to be prepared in case a model develops conflicts or becomes corrupt?
Keep a backup .mdl file.
How can a cube be build with data volumes that result in a .mdc file large than 2GB?
Enable the creation of multiple local PowerCube files.
In Transformer, how can a developer restrict access to an entire Powercube from authorized users?
Apply cube-based security
A developer added a manual level in the time dimension. During category generatioon, 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 correclty?
Special a date function for each level.
What can be done to apply member-based security if the model contains cube groups?
Define teh security for each member cube.
The time dimension contains levels for year, quarter, and month. how can the month lvels in 2008 be retained while removing them from 2007?
Create a subdimension.
What does the developer specify when creating a test that uses a subset of the source data?
The number of records.
What does unique mean when applied to level in a dimension map?
No two categoriess in the level can be derived from the same source value.
Where are the log files accessed to troubleshoot issues?
In the path set in Transformer preferences.
If a cube group based on a level in a dimension is created, how can the developer prevent another cube from being added to the cube group?
Prevent the automatic creation of categories.
How can the cube build flexibilty and performance be maximized?
Preprocess the data.
The model contains a measure named Quantity, and the OLAP reports need to show the Minimum monthly quantity sold to each store. how would a developer get the correct result?
Use a Regular rollup function.
What must be done to make the cube data available in Analysis Studio?
Publish the PowerCube as a data source and a package.
What can be created to determine the monthly growth showing the percentage of change between Curent month and Last Month for all measures included in the Powercube?
when running simultaneous cube builds, how cancube build times be decreased?
Assign each Transformer process one CPU.
Which of the following can be done to improve performance when dealing with lange volumes of data?
Include multiple data sources.
When measures are calculated after rollup, when are the calculateions performed?
After allocated measures are calculted.
When the model contains two data values, how can the developer avoid ambiguity when Transformer sets the current time peiod?
Disable the data source's ability to set the current time period.
Which if the following will elp improve processing time when Transfermer queries the data?
Separate structural and transactional information in multiple data sources.
The region dimension si organized by territory, Counttry, and City. which option can be applied to only show data for the united States and its descendants?
What can the developer specify for the cube build to use multiple directories to generate tempory work files?
Data temporary files
How can a developer include a key performance indicator that is unavailable and the Transformer data source?
Add a calculated measure.
A developer notices that tildes(~) exist in the category codes. What can be done to avoid unstale MUN values?
Resolve the non-unique keys within a dimension in the data source.
What modeling factor affects the auto-partitioning strategy and causes poor consolidation for partitioned categories?
Wide, flat dimensions.
Where can a developer change relationships to create a structure different from what the data suggests?
How can a developer best address values that are being rounded excessively?
Assign scale and precision setting.
A cognos 10 report with prompts is used as a data source. What must be done to create a second query that is
Add the same report as another Transformer report data source.
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?
An alternate hierarchy in the time dimension.
What can be created to propvide new insight into the data if Margin Ranges are defined as Low, Medium, and high, based on a calculated column using the revenue and cost columns?
What can be applied to a category if only the parent and child categories are required?
For a cube that represents values in Euros, what should be done for American consumers to see the appropriate currency symbol in Euros?
Build Cubes using a system locale that matches the measure locale.
For performance reasons, what is the best parent-child ratio for categories in each level?
1:10 or less
How can a develeoper populate a level with a different data source column?
Through level properties.
What can be done to show how many retails of each type bought a specific product each month, quarter, or year?
Define a measure that counts categories.
What can be done to correct a report that contains time categories that are out of range and irrelevant to the user?
Adjust the acceptable dates included in the model.
What objects can be created within the Cognos Namespace?
Groups and roles
To add dimensional data to an existingmodel, how can metadata be leve lraged from other published OLAP packages?
Add dimensions from an OLAP package in the dimension map.
Transformer is unable to locate one of the source files for a date source in the model, and the model updates fails. Which type of files can be used to restart the processing at the point of failure?
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?
Set the date class of the source category to Date.
The developer notices a devrease in run-time performance in a model that has calculated measures(before rollup). Because auto-partitioning is not used, how can the developer increase performance?
Use calculated columes instead of before rollup measures.
What can be done in a manual level to keep new dataseperate until it can be connected to the apprepriate parent category?
Create an orphanage category
What does a unique move ensure when applied to a level in a dimension map?
The category moved within the level has its data history moved with it.
When can Transformer category codes change?
When a Clean House is performed before a cube is rebuilt.