Excercise -1

The Cognos Connection Web site

Before you can use Report Studio, you must know how to open the Cognos Connection web site.

 Exercise 1—Open the Cognos Connection Web Site

 Note: Report Studio works only on the Internet Explorer web browser on a computer running the Windows operating system.

1.      Open the Internet Explorer web browser.

2.      To access the Cognos Connection web site, type the following URL in the browser’s Address field and then press ENTER:

   https://cognos.udel.edu/crn/

3.      Type your UDelNet ID in the appropriate field.

4.      Type your password in the appropriate field.

      You should see a window similar to the following:

The Cognos Connection web site gives you access to the ReportNet suite of reporting tools: Query Studio and Report Studio. Query Studio allows you to create ad hoc reports from an existing data source. Report Studio allows you to author complex reports based on your business needs. Reports can contain multiple report objects: lists, charts, and crosstabs as well as images, logos, and other elements.

End of Exercise

Table of Contents

 Cognos Connection Website
           Exercise 1—Open the Cognos Connection Web Site.

Open Report Studio        
           Exercise 2—Open Report Studio and Begin a New Report.

The Report Studio Window      

Report Terminology    

Add Data to a Report      
            Exercise 3—Add Data to a Report and Save It.

Run the Report    
             Exercise 4—Validate and Run the Report.

Types of Reports                                                                              
List Reports        
Grouped List Reports      
            Exercise 5—Create a Grouped List Report and Set the Level Span

Create Repeated Form Frames from a List      
             Exercise 6—Create Repeated Form Frames from a List

Crosstab Reports                                                                                                                    Exercise 7—Create a New Crosstab Report.
             Exercise 8—Create a Crosstab Report from an Existing Report.

Charts                                                                                                                  
             Exercise 9—View the Types of Report Studio Charts.
Create a Chart    
             Exercise 10—Create a Column Chart.
             Exercise 11—Create a Combination Chart.

Manipulate Data in Reports                                                                    
Filters        
             Exercise 12—Add a Filter.

Filter on Details and Summaries      
             Exercise 13—Filter on Details
             Exercise 14—Create a Summary Filter.

Filter Groups      
             Exercise 15—Filter Groups.
Filter Crosstabs    
            Exercise 16—Filter a Crosstab Report.

Prompts      
            Exercise 17—Add a Prompt.
            Exercise 18—Use the “Build Prompt Page” Tool.

Cascading Prompts      
            Exercise 19—Build a Cascading Prompt.
            Exercise 20—Create a Single-Value Cascading Prompt.
            Exercise 21—Create a Multiple-Value Cascading Prompt.

Optional Prompts    
             Exercise 22—Add an Optional Prompt.
Drill Throughs    
            Exercise 23—Create a Target Report.
            Exercise 24—Create a Parent Report with a Drill Through.

Report Layouts                                                                                            
            Exercise 25—Create a Report Layout.
            Exercise 26—Create a Crosstab Report from Scratch.

Advanced Techniques                                                                                              
            Exercise 27—Change the Organization of a List Report.
            Exercise 28—Add Styling at a Higher Level.
            Exercise 29—Add an Image or Annotate a Crosstab Report.

Report Studio Queries                                                                                  
            Exercise 30—Explore the Report Studio Tabular Model.
            Exercise 31—Work with the Report Studio Cube Definition.

Master-Detail Reports                                                                                              
            Exercise 32—Create a Master-Detail Report.
            Exercise 33—Add a Filter to a Master-Detail Report.

Parent-Child Report                                                                                  
          Exercise 34—Create a Parent-Child Report.

Create an Invoice                                                                                                    
            Exercise 35—Create a Query for an Invoice.
            Exercise 36—Build the Invoice Page Header.
            Exercise 37—Create the Invoice Page Body.
            Exercise 38—Add Data to the Invoice.
            Exercise 39—Add a List Footer to the Report.

Create a Template                                                                                                  
            Exercise 40—Create a  Report Template.

Cognos Introduction

Cognos Report Studio

Introduction

This document introduces you to Cognos Report Studio. The Report Studio and Query Studio reporting tools are two parts of  the Cognos ReportNet web application that allows you to create ad hoc and managed reports. With Query Studio, you created ad hoc reports. Report Studio lets you create and manage complex reports, define layouts and styles, and much more. It offers more  flexibility in calculating and in formatting report data. With Report Studio you can

·        Author complex reports using your data.

·        Save and reuse reports.

·        Run reports in a variety of formats.

·        Print reports.

·        Create report templates.

·        Manage reports.

Note: You can open a Query Studio report in Report Studio and edit it as a Report Studio report. However, you cannot open a Report Studio report in Query Studio

Prerequisites

To use this training material effectively, you should be familiar with producing ad hoc reports using Query Studio. Some exercises in this class build on skills you acquired in the Query Studio class. You should also be familiar with your department’s data. This training is designed to familiarize you with the Cognos Report Studio reporting tool; it is not designed to familiarize you with the underlying data in UD’s system. The training is based on data in a demonstration database.

Important Note

This training document was designed originally to be used in a class setting. Therefore, the exercises are meant to be followed in a sequence. If you have difficulty working through an exercise, try the first four exercises to familiarize yourself with the basics.

Training Objectives

This class was designed using a desktop computer running the Windows 10 operating system and using the Internet Explorer (version 10) browser. If you use a different type of computer or operating system, some of the screen graphics may appear slightly different from those printed here. However, the function of the screen (page) should remain the same.

After you complete the exercises in this training material, you should be able to do the following:

·        Open the COGNOS Connection web page.

·        Open Report Studio.

·        Create a report.

·        Choose the package for the report.

·        Choose a template for the report.

·        Add query items to the report.

·        Save the report.

·        Run the report.

·        Recognize the types of reports.

·        Change the appearance of reports.

·        Create crosstab reports.

·        Use charts.

·        Filter, sort, and group data.

·        Add prompts.

·        Perform calculations.

·        Create Drill-Through reports.

·        Create reports from scratch.

·        Add styling and images.

·        Understand how reports are structured.

·        Create a Master-Detail report.

·        Create a Parent-Child report.

·        Create a report template.

Cognos OLAP developer sample preparation questions

1) When the model contains two data sources that provide date values, how can the developer avoid ambiguity when Transformer sets the current time period?

A. Disable the data source's ability to set the current time period.

B. Assign the current date (obtained from the system clock) as the current period.

C. Let Transformer assign the date closest to the model's creation date as the current period.

D. Enter the initial current period and adjust it to match the system date and time.

Answer: A

2) Where can a developer change relationships to create a structure different from what the data suggests?

A. Categories Diagram

B. Dimension Map

C. Data source property sheet

D. Level property sheet

Answer: A

3) What must be done to make the cube data available in Analysis Studio?

A. Use the PowerCube Connection Utility to publish the cube.

B. Create a data source connection to the cube in Transformer.

C. Publish the PowerCube as a data source and a package.

D. Generate a package that contains a data source connection to the cube.

Answer: C

4) A developer added a manual level 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.

Answer: A

5) 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 the new levels.

Answer: B

6) Senior Managers need to see total and regional sales figures, but Regional Managers should see relevant figures for only their regions.

Where can the developer specify the degree of detail to be included?

A. In a manual level

B. In a cube group

C. In the PowerCube

D. In a scenario dimension

Answer: B

7) How can a developer customize the reporting period so that the year has 52 weeks, with 7 days in each week, yielding 364 days?

A. Set up a lunar time period.

B. Set up a time period based on a calendar year.

C. Set up a time period based on fiscal year.

D. Set up a relative time category.

Answer: A

8) 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?

A. Ensure the level labels and category labels remain unchanged.

B. Specify a category limit for the level.

C. Prevent the automatic creation of categories.

D. Exclude the dimension from auto-partitioning.

Answer: C

9) How can a developer populate a level with a different data source column?

A. Through level properties.

B. Through column properties.

C. Through data source properties.

D. Through data source scope.

Answer: A

10) What can be done to correct a report that contains time categories that are out of range and irrelevant to the user?

A. Ensure the input format is correct for dates in the source data.

B. Check to see if an absolute range category is automatically generated.

C. Adjust the acceptable dates included in the model.

D. Create a non-standard time dimension.

Answer: C

11) How can the parent-child relationship for each category be established?

A. Verify the model.

B. Insert manual levels.

C. Show category counts.

D. Generate the categories.

Answer: D

12)The developer notices a decrease 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?

A. Use a duplicates rollup instead of a before rollup setting.

B. Use an external rollup instead of a before rollup setting.

C. Use calculated columns instead of before rollup measures.

D. Use a time state rollup instead of before rollup setting.

Answer: C

13)How can a developer include a key performance indicator that is unavailable in the Transformer data source?

A. Add a manual category.

B. Add a calculated measure.

C. Create a cube group.

D. Add a measure allocation.

Answer: B

14) What can be done to show how many retailers of each type bought a specific product each month, quarter, or year?

A. Create a calculated measure with a Time state rollup.

B. Specify an allocated measure as the Activity Measure.

C. Create a calculated column.

D. Define a measure that counts categories.

Answer: D

15)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?

A. Use a Regular rollup function.

B. Use a Time state rollup function.

C. Use an External rollup function.

D. Use a Non-regular rollup function.

Answer: A

16) 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.

Answer: A

17) When measures are calculated after rollup, when are the calculations performed?

A. Before time state rollup takes place.

B. After allocated measures are calculated.

C. Before regular rollup takes place on all measures.

D. After relative time calculations.

Answer: B

18) How can a developer best address values that are being rounded excessively?

A. Adjust the number of decimal places.

B. Create a calculated measure.

C. Modify the rollup operations.

D. Assign scale and precision settings.

Answer: D

19) For performance reasons, what is the best parent-child ratio for categories in each level?

A. 1:10 or less

B. 1:11 or more

C. 5:1 or less

D. 10:1 or more

Answer: A

20) Transformer is unable to locate one of the source files for a data source in the model, and the model update fails. Which type of files can be used to restart the processing at the point of failure?

A. .py?

B. .qy?

C. .mdl

D. .mdx

Answer: B

21) How can the cube build flexibility and performance be maximized?

A. Enable Consolidation.

B. Enable the AutoSummarize property.

C. Combine Structural and Transactional data into one data source.

D. Preprocess the data.

Answer: D

22) Where should fact queries against OLAP sources come from?

A. A flat file

B. An .iqd file

C. A Cognos 10 report

D. A Cognos 10 package

Answer: A

23) What does a unique move ensure when applied to a level in a dimension map?

A. The measure values are not rolled up to the new path of the moved categories.

B. The category can be moved to another level.

C. The developer must manually restructure the categories in the dimension.

D. The category moved within the level has its data history moved with it.

Answer: D

24) Which of the following can be done to improve performance when dealing with large volumes of data?

A. Include multiple data sources.

B. Use a single large data source.

C. Include transactional and structural data sources of the same type.

D. Use Cognos 10 reports as transactional and structural data sources.

Answer: A

25) 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.

Answer: C

26) What should a developer do if some levels appear red after validating the model using Show Scope?

A. Ensure the level exists in the data source.

B. Specify a valid relationship between the level and the data source.

C. Re-attach the categories in the Dimension Diagram.

D. Apply unique move to the level and regenerate the categories.

Answer: B

27) Which of the following will help improve processing time when Transformer queries the data?

A. Use normalized structural data sources.

B. Separate structural and transactional information in multiple data sources.

C. Combine structural and transactional information into one data source.

D. Define dimensions within a transactional data source with unique values.

Answer: B

28) What does unique mean when applied to a level in a dimension map?

A. The level is designated as a convergence level.

B. The level must be the bottom level of the dimension.

C. No two categories in the level can be derived from the same source value.

D. The data history does not move with the categories as they move in the level.

Answer: C

29) A Cognos 10 report with prompts is used as a data source. What must be done to create a second query that is

based on the same report but provides different values for mandatory prompts?

A. Add the second query to the report data source.

B. Refresh the source when adding the second query.

C. Add prompt values to the cache in the Transformer data source.

D. Add the same report as another Transformer report data source.

Answer: D

30) When can Transformer category codes change?

A. When a new cube is defined.

B. When a reset partition is applied.

C. When the cube connection is updated with pcconn.

D. When a Clean House is performed before a cube is rebuilt.

Answer: D

31) What modeling factor affects the auto-partitioning strategy and causes poor consolidation for partitioned categories?

A. Wide, flat dimensions

B. Well-balanced hierarchical dimensions

C. Allocated measures

D. After rollup calculated measures

Answer: A

32) Columns have been renamed in the data source. Which command must the developer run to update the model?

A. Check Columns

B. Update Columns

C. Rename columns

D. Modify Columns

Answer: D

33) How can a developer rebuild an incrementally updated cube?

A. Enable time-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.

Answer: D

34) A developer notices that tildes (~) exist in the category codes. What can be done to avoid unstable MUN values?

A. Perform a Clean House.

B. Resolve the non-unique keys within a dimension in the data source.

C. Regenerate the categories.

D. Ensure the values are non-conformed in the data source.

Answer: B

35) What improves performance in the reporting application by combining records with identical non-measure values?

A. Consolidation

B. Partitioning

C. PC Optimizer

D. Crosstab caching

Answer: A

36) When running simultaneous cube builds, how can cube build times be decreased?

A. Assign each Transformer process one CPU.

B. Assign each Transformer instance one CPU.

C. Use the same configuration files for each Transformer instance.

D. Use a single-CPU server model.

Answer: A

37) What can the developer specify for the cube build to use multiple directories to generate temporary work files?

A. Log files

B. Model temporary files

C. Operating system page file

D. Data temporary files

Answer: D

38) How can a cube be built with data volumes that result in a .mdc file larger than 2 GB?

A. Set the MultiFileCubeThreshold value to zero.

B. Enable the creation of multiple local PowerCube files.

C. Remove the auto-partitioning scheme.

D. Use multiple checkpoint files.

Answer: B

39) What could be done if the report does not run after the category codes change?

A. Rebuild the cube and publish a new package.

B. Perform a Clean House.

C. Modify the report to point to the updated member.

D. Manually change the category codes within the model.

Answer: C

40) As a good practice, what can a developer do to be prepared in case a model develops conflicts or becomes corrupt?

A. Keep a backup .mdl file.

B. Keep a backup .py? file.

C. Keep a backup qy? file.

D. Keep a backup .py? and qy? files.

Answer: A

41) What does the developer specify when creating a test build that uses a subset of the source data?

A. The number of categories.

B. The dimensions to include in the cube.

C. The number of records.

D. The measures to include in the cube.

Answer: C

42) Where are the log files accessed to troubleshoot issues?

A. In the Content store.

B. In the Bin folder in the installation directory.

C. In the path set in Transformer preferences.

D. In the Temp directory.

Answer: C

43) 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.

Answer: A

44) How does a developer associate a custom view with a PowerCube?

A. Update the Powercube properties.

B. Specify the path of the Powercube in the custom view.

C. Specify the package name in the custom view.

D. Drag the custom view to the appropriate Powercube.

Answer: D

45) To control access to content for users that have similar responsibilities and privileges,where should security be applied?

A. Data source

B. Role

C. User

D. Namespace

Answer: B

46) 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.

Answer: A

47) In Transformer, how can a developer restrict access to an entire PowerCube from authorized users?

A. Apply cube-based security.

B. Set member-based security.

C. Apply namespace-level security.

D. Set package-based security.

Answer: A

48) A group called Authors is used in a custom view. How is information updated if the Author group members change in the authentication provider?

A. The PowerCube must be rebuilt.

B. The services must be restarted in Cognos Configuration.

C. The changes are automatically updated at run time.

D. The package must be republished.

Answer: C

49) What objects can be created within the Cognos Namespace?

A. Roles and users

B. Groups and roles

C. Groups and users

D. Members

Answer: B

50) How can a developer define a specific view of the data and restrict access to it?

A. Apply cube-based security.

B. Set member-based security.

C. Apply namespace-level security.

D. Set package-based security.

Answer: B

51) What can be done to apply member-based security if the model contains cube groups?

A. Define the security for each member cube.

B. Inherit the security that was used in the control cube.

C. Create a hierarchical custom view.

D. Create a descendant custom view.

Answer: A

52) 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.

Answer: A

53) What can be applied to a category if only the parent and child categories are required?

A. Suppress

B. Exclude

C. Summarize

D. Cloak

Answer: A

54) The time dimension contains levels for year, quarter, and month. How can the month levels in 2008 be retained while removing them from 2007?

A. Add a special category.

B. Add a manual level.

C. Create a scenario dimension.

D. Create a subdimension.

Answer: D

55) 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 a dimension

D. The level of convergence

Answer: D

56) What can a developer set up to analyze actual, planned, and forecasted budget information that do not rollup into a single root category?

A. Scenario dimension

B. Calculated category

C. Special category

D. Exception dimension

Answer: A

57) The dimensions in the model include Product, Customer, and Order. If the Powercube should focus on the sales orders,

how can the developer remove customer data?

A. Omit the dimension from the PowerCube.

B. Apex the dimension in the model.

C. Set measure allocation for the Customer dimension.

D. Suppress the dimension in the model.

Answer: A

58) The Region dimension is organized by Territory, Country, and City. Which option can be applied to only show data for the United States and its descendants?

A. Suppress

B. Apex

C. Summarize

D. Cloak

Answer: B

59) A dimension organizes all the regions by Country and City. Disregarding the hierarchical organization, how can the five best performing regions be grouped?

A. Create a scenario dimension.

B. Add an alternate drill-down path.

C. Add a special category.

D. Create a subdimension.

Answer: C

60) When there are too many child categories, what can be created to allow intermediate groupings?

A. A cube group

B. An alternate drill-path

C. A manual level

D. A subdimension

Answer: C

61) A developer created a cube for 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 other regions. What should be created?

A. Custom view

B. Cube group

C. Apexed view

D. Suppressed view

Answer: B

62) What can be created to determine the monthly growth showing the percentage of change between Current Month and Last Month for all measures

included in the PowerCube?

A. Calculated columns

B. Calculated categories

C. Calculated measure

D. Alternate hierarchies

Answer: B

63) Which option decreases cube size by removing data from the cube?

A. Suppress

B. Summarize

C. Apex

D. Cloak

Answer: C

64) What can be done in a manual level to keep new data separate until it can be connected to the appropriate parent category?

A. Create an orphanage category.

B. Create a special category.

C. Include categories when needed.

D. Prohibit automatic creation of new categories.

Answer: A

65) What can be created to provide 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?

A. Scenario dimension 

B. Exception dimension

C. Special category

D. Calculated category

Answer: B

Cognos TM1 developer sample practice questions for certification

IBM Cognos TM1 10.1 Developer sample practice questions

QUESTION NO: 1

The logging parameter within \}CubeProperties is designated by a "Yes" or "No" for each cube.

What does this define?

A. Data changes to the TM1 cubes logged into the tm1s.log file

B. cubepropertiesdataloggedintothetm1server.log

C. dimensionupdatesloggedintothetm1audit.log

D. userpermissionsloggedtothetm1server.log

Answer: A

QUESTION NO: 2

Which three are typically stored within a TM1 control object? (Choose three.)

A. A list of TM1 users

B. TM1 system errors

C. Data required by the TM1 server to perform a driver-based calculation

D. TM1 object-level security permissions

E. Statistical performance data about the TM1 server

Answer: A,D,E

Explanation:

QUESTION NO: 3

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

Explanation:

QUESTION NO: 4

What are the elements of a rule?

A. Area Definition, Qualifier, Formula, Terminator, and Sequence Indicator

B. Area Definition, Qualifier, Formula, and Priority Flag

C. Area Definition, Qualifier, Formula, and Terminator

D. Area Definition, Formula, Terminator, and Priority Flag

Answer: C

Explanation:

QUESTION NO: 5

You want to improve one TM1 cube by adding Skipcheck and Feeder statements to a Rules file.

Which statement is correct?

A. The addition of rule-calculated cells to a cube will cause reduced consumption of RAM.

B. The data integrity of consolidated cells will improve.

C. The performance of views containing rule-calculated cells will improve.

D. Cross cube rule statements will be no longer be ignored.

Answer: C

Explanation:

QUESTION NO: 6

Cross-Cube Feeder statements will result in a Cube Dependency relationship between the Dependent Cube (containing the feeder) and the Base Cube (the target cube of the Feeder from the Dependent Cube) if the Feeding cells contain data at Server startup or if initially null at server startup, the feeding cells are subsequently updated during the server session.

Which statement describes the relationship between the cubes having the Cube Dependency

relationship?

A. Cell value updates to the Dependent Cube will invalidate the cache of the Base Cube.

B. Cell value updates to the Base Cube will invalidate the cache of the Dependent Cube.

C. Cell value updates to the Dependent Cube will invalidate the Cube Dependency.

D. Cell value updates to the Base Cube will invalidate the Cube Dependency.

Answer: A

Explanation:

QUESTION NO: 7

Which three parameters create a view extract of a cube either manually or when using

Turbolntegrator? (Choose three.)

A. Skip consolidated values.

B. Skip an ancestor of a specified element.

C. Skip zero/blank values.

D. Skip values greater than a specified numeric value.

E. Skip the eighth element in a dimension.

Answer: A,C,D

Explanation:

QUESTION NO: 8

The customer is experiencing performance issues with threads blocking as shown in the TM1

Operations Console.

Which setting within the tmls.cfg file improves writer response time by removing lock contention

resulting from concurrent cube data access?

A. AllowSeparateNandCRules=T

B. Parallellnteraction=T

C. UseStargateForRules=T

D. PersistentFeeders=T

Answer: B

Explanation:

QUESTION NO: 9

An international enterprise has planners in European, Asian, and North American regions. The enterprise wants to have planners in each region enter cube data into the local regional TM1 server but report globally on a daily basis from a single enterprise-reporting server located in Canada. The enterprise wants to integrate the cube data from the different regions into a single reporting server in Canada.

Which method accomplishes this goal?

A. Use the TM1 rules to push data from each regional server into the Canadian reporting server.

B. Use the TM1 rules to pull data from each regional server into the Canadian reporting server.

C. UsetheTM1 replication/synchronization in the Canadian server to pull data from the regional

servers.

D. Use the TM1 replication/synchronization in the regional servers to push data to the Canadian

server.

Answer: C

Explanation:

QUESTION NO: 10

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

Explanation:

QUESTION NO: 11

Which two attributes are aliases on a large product dimension? (Choose two.)

A. Product size

B. Product standard color

C. Product name in German

D. Unique long product name

Answer: C,D

Explanation:

QUESTION NO: 12

When creating TM1 applications using Performance Modeler, what are the three legal values for Application Type? (Choose three.)

A. Central

B. Workflow

C. Responsibility

D. Approval

E. Distributed

Answer: A,C,D

Explanation:

QUESTION NO: 13

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: B,C

Explanation:

QUESTION NO: 14

A Skip check 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 ZeroSuppression

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: B,D

Explanation:

QUESTION NO: 15

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

Explanation:

QUESTION NO: 16

A TM1 Action Button can directly perform which two tasks? (Choose two.)

A. Sort worksheet data in ascending or descending order.

B. Run a Turbolntegrator process.

C. Navigate to another worksheet.

D. Open a TM1 cube view.

Answer: B,C

Explanation:

QUESTION NO: 17

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

Explanation:

QUESTION NO: 18

Which component would you use to define and publish a package in IBM Cognos Bl to report from TM1 data?

A. Framework Manager

B. Transformer

C. Report Studio

D. TM1 URL API

Answer: A

Explanation:

QUESTION NO: 19

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.

Answer: D

Explanation:

QUESTION NO: 20

Active Forms support which three features? (Choose three.)

A. Zero suppression columns

B. Zero suppression rows

C. Drill-through

D. Expandable/collapsible consolidations rows

E. Expandable/collapsible consolidations columns

Answer: B,C,D

Explanation:

QUESTION NO: 21

You have developed a sequence of T1 processes connected together by the ExecuteProcess(..) command. To improve the performance of the application, you decide to break up the subprocesses so that they run in their own thread to use cores more efficiently.

Which TM1 object accomplishes this goal?

A. TM1 RunTl.exe

B. ExecuteProcessNewThread(..)

C. ExecuteProcess(...)

D. BatchProcess.exe

Answer: A

Explanation:

QUESTION NO: 22

Using Performance Modeler, items are set either from an amount which is brought in from another cube by a link or from a calculation (quantity times price). During testing, all the items are quantity times price. The relevant part of the rules file is shown in the exhibit. How do you change the rules so that the items are set to the amount where required?

A. Disable Region "#Region Link rule: my link- Numeric" and manually add the corrected rule below the disabled region.

B. Move Region "#Region Link rule: my link- Numeric" above Region "N-Calculation rules: MY Calc".

C. Manually overwrite Area Definition in Region "N-Calculation rules: MY Calc".

D. Change the definition in the Dimension for Region "N-Calculation rules: MY Calc" to include If and Continue.

Answer: B

Explanation:

QUESTION NO: 23

If vOriginalDate = July 27, and you require vNewDate = Jul2012, which syntax is appropriate to complete this task?

A. vNewDate=SUBST(vOriginalDate,3,3) | '2012';

B. vNewDate=SUBST(vOriginalDate,3,3) & '2012';

C. vOriginalDate=SUBST(vNewDate,3,3) & '2012';

D. vNewDate=SUBST(vOriginalDate,3,3) + '2012';

Answer: A

Explanation:

QUESTION NO: 24

Referring to the exhibit, a rule is written where the sales_amt is equal to units multiplied by avg selling price What does the cube view tell you about the rule calculation?

A. The rule is missing a Skipcheck statement.

B. The rule is overfed.

C. The rule is underfed

D. The ruled calculation is missing a feeder.

Answer: C

Explanation:

QUESTION NO: 25

Regarding Sandboxes, why do numbers sometimes appear in blue or green?

A. Green is for values not sent to the server and blue is for uncommitted values.

B. Green is for uncommitted values and blue is for values not sent to the server.

C. Green and blue are for uncommitted values depending on client interface used.

D. Green and blue are for values not sent to the server depending on the client interface used.

Answer: A

Explanation:

QUESTION NO: 26

In Turbolntegrator, as part of the monthly data load, you need to add new products and their sales values but the products do not exist within the Product dimension in the cube. Which function would you use to first add the new products to the Product dimension?

A. DimensionCreate()

B. DimensionElementlnsert()

C. DimensionElementPrincipalName()

D. CellPutN()

Answer: B

Explanation:

QUESTION NO: 27

You are importing data into TM1 using Turbolntegrator. Which three actions are available?

(Choose three.)

A. Create or update a dimension from an external source.

B. Create or update a cube from an external source.

C. Re-create a cube to change both data and meta data.

D. Re-order the dimensions of an existing cube.

E. Remove a dimension to an existing cube.

Answer: A,B,C

Explanation:

QUESTION NO: 28

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

Explanation:

QUESTION NO: 29

A new member is added to a dimension called Products which is used in a cube called Sales.

What information is recorded in the audit log?

A. A change to the total number of members in the Products dimension

B. A change to the size of the Sales cube

C. A change to the last updated time of the Products dimension

D. The name of the new member

Answer: C

Explanation:

QUESTION NO: 30

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 consolidated values in export)

E. ViewExtractSkipLevelZero (exclude leaf level values in export)

Answer: A,B,D

QUESTION NO: 31

All items are in the same dimension and performance is of the highest priority.

How do you calculate the difference between item A and item B, and then store the result in item C?

A. Define C as sibling of A and B, and a rule ['C']=N:['A']-['B'];.

B. Define C as consolidation of A and B, B with a weight of-1.

C. Define C as consolidation of A and B2, and a rule ['B2']=N:-['B'];.

D. Define C as consolidation of A and B, and a rule ['C'] = C: ['A']-['B']:.

Answer: B

Explanation:

QUESTION NO: 32

You want to load data to Cube A that will result in faster load times while ensuring TM1 can recover the content of the data load in the event of a subsequent server failure.

Which technique would you use?

A. On the T1 Maps/Cube tab, select Enable Cube Logging, and add a CubeSaveData(CubeA) function to the Advanced/Epilog tab.

B. On the T1 Maps/Cube tab. do not select Enable Cube Logging, and add a

CubeSaveData(CubeA) to the Advanced/Epilog tab.

C. On the T1 Maps/Cube tab, select Enable Cube Logging, and add a SaveDataAII function to the Advanced/Epilog tab.

D. On the T1 Maps/Cube tab, do not select Enable Cube Logging, and add a SaveDataAII function to the Advanced/Epilog tab.

Answer: B

Explanation:

QUESTION NO: 33

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

Explanation:

QUESTION NO: 34

If there is more than one rule in the rules file for a given cell, which rule does IBM CognosTM1 calculate?

A. The rule with the highest priority flag is calculated.

B. Depending on which rule was calculated immediately before, the next one is used.

C. It calculates the last applicable rule.

D. It calculates the first applicable rule and then stops.

Answer: D

Explanation:

QUESTION NO: 35

You have three elements (A, B, and C) of a dimension in a public subset called THE_SUB. You want to address them in an Area Definition in a rule.

Which syntax should you use?

A. [{'A', 'B' , 'CV}]

B. [{THE_SUB'\}]

C. ['THE_SUB']

D. [A'.'B'.'C]

Answer: A

Explanation:

QUESTION NO: 36

You are asked to use Performance Modeler to Transfer a cube. The target cube already exists in the target system but the source cube contains an additional dimension.

What happens to the target cube and its data?

A. The additional dimension is added and the existing data is deleted.

B. The additional dimension is added and the existing data is placed in the first leaf of the new dimension.

C. The additional dimension is added and the existing data is propagated across all leaves of the new dimension.

D. The additional dimension is not added and the existing data remains in place.

Answer: B

Explanation:

QUESTION NO: 37

Which two statements are true about spreading in TM1? (Choose two.)

A. Spreading is often performed on a single dimension without involving a cube.

B. The extend option under spreading allows spreading in more than one direction (e.g., right and up) as one operation.

C. With spreading, there is only one update action allowed: replace.

D. Spreading can be used to populate a cube with test data.

Answer: B,D

Explanation:

QUESTION NO: 38

What are three legal selection criteria for TM1 subsets? (Choose three.)

A. SQL expression

B. Hierarchical level (e.g., Leaf level)

C. Attribute value

D. Java expression

E. Spelling pattern (e.g., by Wildcard filter)

Answer: B,C,E

QUESTION NO: 39

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.

Answer: A,C

Explanation:

QUESTION NO: 40

What does element-level security control?

A. Access to cubes that contain the secured elements

B. The ability to add, remove, and reorder the secured elements in a dimension

C. Access to the cells identified by the secured elements

D. Access to applications that contain the secured elements

Answer: C

Explanation:

QUESTION NO: 41

The Rule Tracer can be used with which TM1 interface?

A. TM1 Slice Worksheets

B. TM1 Cube Viewer

C. TM1 Web View

D. TM1 In-Spreadsheet Browser

Answer: B

QUESTION NO: 42

You are concerned about overfeeding in a TM1 model.

What are two symptoms of this? (Choose two.)

A. Sub-optimal view performance

B. Unnecessary RAM consumption

C. Increases the log file size

D. Data integrity risks occur

Answer: A,B

Explanation:

QUESTION NO: 43

Your customer requires that all users be forced to collect their data and commit only a whole set of data. They are not allowed to create different versions.

Which setting is required to fulfill this requirement?

A. Set the capability Personal Workspace Mode to Off and the capability Sandbox to On.

B. Set the capability Personal Workspace Mode to Off and the capability Sandbox to Off.

C. Set the capability Personal Workspace Mode to On and the capability Sandbox to On.

D. Set the capability Personal Workspace Mode to On and the capability Sandbox to Off.

Answer: D

Explanation:

QUESTION NO: 44

A customer is using dynamic subsets.

Which statement is true about TM1 Perspectives?

A. Expression-based dynamic subsets are created using MDX.

B. Expression-based dynamic subsets are created using SQL.

C. Expression-based dynamic subsets are created using Java.

D. Expression-based dynamic subsets can include "filter-by-SQL" operators.

Answer: A

Explanation:

QUESTION NO: 45

You are developing a TM1 model for a city aquarium and must add these new elements to the Animal dimension: Amphibians. Frog, and Salamander. Assume that Amphibians is the parent of Frog and Salamander and that you want the children to automatically roll up to the parent.

Which weighting and element type will you assign to each element?

A. Amphibians Element Type = C. Weight=1

Frog Element Type = N, Weight=0

Salamander Element Type = N, Weight=0

B. Amphibians Element Type = C, Weight=1

Frog Element Type = N, Weight=1

Salamander Element Type = N, Weight=1

C. Amphibians Element Type = N, Weights

Frog Element Type = N, Weight=0

Salamander Element Type = N, Weight=0

D. Amphibians Element Type = P,Weight=1

Frog Element Type = N, Weight=1

Salamander Element Type = N, Weight=1

Answer: B

Explanation:

QUESTION NO: 46

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 regions, all months except Jan, Pencils, Actuals

B. Jan. Budget. Pens

C. Jan. Actuals, Pencils

D. All regions, all months except Jan, Pens, Budget

Answer: C

Explanation:

QUESTION NO: 47

In which TM1 cube would a developer define dimension hierarchy levels for use in IBM Cognos B1

reporting?

A. \}HierarchyLevels

B. \}HierarchyProperties

C. \}DimensionProperties

D. \}Dimensionl_evels

Answer: B

Explanation:

QUESTION NO: 48

A TM1 Operations Console shows a thread which is waiting to obtain a read lock on a cube.

Which thread is blocking it?

A. A thread which holds a read lock on the cube

B. A thread which holds a write lock on the cube

C. A thread which holds an intent to write lock on the cube

D. A thread which is waiting to write to the cube

Answer: B

Explanation:

 0

QUESTION NO: 49

You have the dimension shown in Performance Modeler as shown in the exhibit.

Which three actions create a subset containing the countries starting with "A" in alphabetical order? (Choose three)

A. Hide consolidated members.

B. Hide leaf members.

C. Sort ascending.

D. Sort descending.

E. Filter by wildcard A*.

Answer: A,C,E

Explanation:

QUESTION NO: 50

Which action must you take before the TM1 cubes can be used in IBM Cognos B1?

A. Define levels for all dimensions in TM1.

B. Define Measure dimensions for all cubes in TM1.

C. Define security for all elements in TM1.

D. Create an administrator account for IBM Cognos B1 to use.

Answer: B

Explanation:

QUESTION NO: 51

You execute a number of Turbolntegrator processes as part of a chore using the ExecuteProcess function but errors result. Upon reviewing the log files, inadequate information about the errors exist.

What is the debugging strategy?

A. Send comments to a log file with ASCIIOUTPUT function.

B. Turn on cube logging.

C. Use the SetChoreVerboseMessages function.

D. Send comments to a log file with TEXTOUTPUT function.

Answer: C

Explanation:

QUESTION NO: 52

What does IBM Cognos TM1 do with calculated values based on rules?

 A. It keeps them in a user cache for further usage.

B. It keeps them in a cube cache for further usage.

C. It keeps them in a disk-based cache for further usage.

D. It does not keep them in order to minimize memory usage.

Answer: B

Explanation:

QUESTION NO: 53

What are three examples of privileges that can be assigned to TM1 objects? (Choose three.)

A. Hold

B. Lock

C. Admin

D. Reserve

E. Delete

Answer: B,C,D

Explanation:

QUESTION NO: 54

Following TM1 best practices for budget applications, which dimension omits consolidated elements?

A. Time

B. Measures

C. Organization Chart

D. Chart of Accounts

Answer: B

Explanation:

QUESTION NO: 55

Within the TM1 cube viewer, which two filter methods are available? (Choose two.) 

A. Filter by a text pattern match.

B. Filter by the largest or smallest values for a column element.

C. Filter by the largest or smallest values whose cumulative total equals a specified percentage of a dimension total

D. Filter by the MDX expression.

Answer: B,C

Explanation:

QUESTION NO: 56

User security assignments are stored in which control cube?

A. \}ClientSettings

B. \}ClientGroups

C. \}ClientProperties

D. \}ClientSecurity

Answer: B

Explanation:

QUESTION NO: 57

Which statement is true about cube properties?

A. The cube properties cube includes a list of all dimensions in the cube.

B. Cube properties are held in the system cube named \}CubeProperties using the dimension \}CubeProperties.

C. The cube properties cube is visible and accessible to all users.

D. The cube properties cube includes a list of all the views associated with the cube.

Answer: B

Explanation:

QUESTION NO: 58

Which statement is true when using Cognos Access Manager (CAM) User Authentication with TM1? 

A. IBM Cognos Authentication automatically manages users on the TM1 Server.

B. IBM Cognos Authentication automatically manages TM1 Object Security.

C. IBM Cognos Authentication requires that all users must be pre-loaded into TM1.

D. IBM Cognos Authentication requires that all users belong to the TM1 group.

Answer: A

Explanation:

QUESTION NO: 59

You need to import new monthly sales data into an existing cube.

Using the Turbolntegrator wizard, which action will load the data while maintaining the cube structure?

A. Create a cube and populate it with data from the source.

B. Re-create a cube while preserving the existing data.

C. Update the cube.

D. Create a dimension from data imported from a source.

Answer: C

Explanation:

QUESTION NO: 60

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 the formatting to the cube view.

C. Assign Measures in row, Months in columns, Version in title, and Product in title.

D. Assign Months in row, Measures in column, Version in title, Product in title.

Answer: D

QUESTION NO: 61

You are developing a TM1 model for a city aquarium and need to add a new sub-category of  animals to the Animal dimension. The new elements are: Amphibians, Frog, and Salamander.Assume that Amphibians is the parent of Frog and Salamander and you want the children to automatically roll up to the parent. Which weighting and element type will you assign to each element?

 A. Amphibians Element Type = Consolidated (C), Weight 1

 B. Amphibians Element Type = Numeric (N), Weight 1

 C. Amphibians Element Type = String (S), Weight 1

 D. Amphibians Element Type = Aggregate (A), Weight 1

Answer: A

QUESTION NO: 62

 You need the current month as a number. Which function delivers the desired result?

 A. TIMEST(NOW, '\m')

 B. MONTH (NOW)

 C. TIMVL(NOW, 'M')

 D. TIME(NOW, 'M')

 Answer: C

QUESTION NO: 63

 You need to export data from a TM1 cube including the column headers. Where do you put  the ASCIIOutput command for the column headers?

A. In the PROLOG section without condition

B. In the METADATA section with condition to execute it only for the first record

 C. In the DATA section with condition to execute it only for the first record

 D. In the EPILOG section without condition

Answer: C

QUESTION NO: 64

 You are planning a customer installation with several TM1 servers, all with Integrated  Security Mode 4 and a common Cognos BI service. Security groups are common between  all TM1 servers. Where do you maintain groups and users to minimize administrative  tasks?

 A. In TM1 \}Group dimension

 B. In Cognos Connection

 C. In Cognos Configuration

 D. In Cognos TM1 Operations Console

Answer: B

QUESTION NO: 65

You have a cube that is showing slower than expected query response times. Which strategy would you pursue to improve query performance?

 A. Apply cell security to the cube.

 B. Reorder the cube dimensions using the Cube Optimizer.

 C. Create a named view on the cube.

 D. Run the query through TurboIntegrator.

Answer: B

QUESTION NO: 66

Your customer requires that all users be forced to write their data directly into the server so that the data is visible to all other users. Which setting fulfills this requirement?

A. Set the capability Personal Workspace Mode to On and the capability Sandbox to On.

B. Set the capability Personal Workspace Mode to On and the capability Sandbox to Off.

C. Set the capability Personal Workspace Mode to Off and the capability Sandbox to On.

D. Set the capability Personal Workspace Mode to Off and the capability Sandbox to Off.

Answer: D

QUESTION NO: 67

On which level of granularity can the capabilities for Personal Workspace Mode and Sandboxes be set? They can be set:

A. per cube and group

B. per cube for all groups

C. per group for all cubes

D. once for all cubes and groups

Answer: C

QUESTION NO: 68

Which settings in the tm1s-log.properties file would maximize the information producedusing TI processes while keeping other log information to a minimum?

A. log4j.logger.TM1=WARN, S1

 log4j.logger.TM1.Cube=INFO

B. log4j.logger.TM1=INFO, S1

 log4j.logger.TM1.Process=ERROR

C. log4j.logger.TM1=ERROR, S1

 log4j.logger.TM1.Process=INFO

D. log4j.logger.TM1=INFO, S1

 log4j.logger.TM1.Process=WARN

Answer: C

QUESTION NO: 69

You develop a worksheet with drop down menus displaying subset information. You want to ensure that after the worksheet is opened, all of the subsets are automatically refreshed and up-to-date with the latest server changes. Which workbook level named variable would you use?

A. TM1RefreshSheet = 1 

B. TM1RebuildOption = 1

C. TM1SubsetRefresh = 1

D. TM1ActiveFormRefresh = 1

Answer: B