Ibm Cognos Tm1 10.1 Analyst - Cog-701 Certification

Front 1

How do you configure a TM1 Application Web so that users are not prompted for the TM1 Admin Host every time they log in?

Back 1

Edit the web.config file

Front 2

A company uses Excel workbooks to access IBM Cognos TM1 data over a wide area network. The company needs to improve the performance of their Excel workbooks which contain multiple slices from multiple TM1 cubes. Which two changes will improve performance?

Back 2

Convert all DBR() functions to DBRW() functions

Convert all DBRA() functions to DBRW() functions

Front 3

Why would you use Rebuild over Recalc in an Active Form?

Back 3

When metadata is added to the TM1 model that must be displayed on the row

Front 4

A TM1 Application Web user has completed data input. Which action allows the user to lock the data for review?

Back 4

Submit

Front 5

You have imported a sales data Cognos Insight local cube. You have years, quarters, and months in different dimensions. However, for your business requirements, it would be better to have a one-time dimension. How would you change your model?

Back 5

Create a new cube using the Group Dimension function

Front 6

What are three reasons why you would use Cognos BI Reporting rather than TM1 Application Web?

Back 6

You must merge data from different cube sources

You require bursting of reports

You require different report versions

Front 7

You have entered new planning data into a TM1 Model and all figures are blue. Which statement is correct?

Back 7

The numbers are in a Personal Workspace and need to be committed before seen by others

Front 8

You want to create TM1 Excel reports. What are two methods to accomplish this?

Back 8

Use the Slice to Excel button

Export Cognos Insight report to Excel

Front 9

Click the Exhibit button. In the Assumptions dimension, all key figure are formatted correctly as shown in the exhibit, yet all values are displayed as currency. Where would you search for the currency format?

Back 9

In the column dimension

Front 10

What must a TM1 Application Web user do to perform what-if analysis on budget amounts without affecting the current version of the data?

Back 10

Create a Sandbox

Front 11

A user is a member of four security groups: A, B, C, and D. For the Budget cube, group A has WRITE access, group B has READ access, group C has RESERVE access, and group D has NONE access level. Which access level will the user have to the Budget cube?

Back 11

RESERVE

Front 12

A user entering numerical data into TM1 Application Web places a hold consolidate on North America with three children: Canada, USA, and Mexico. At the time the hold is placed, the value of North America is $30.00, with each child value set at $10.00. A user subsequently adds $10.00 to the value of Canada. Which statement is correct?

Back 12

North America remains unchanged. USA and Mexico are reduced by $5.00 each

Front 13

A user has created a Sandbox on a cube view. The user wants to have the Sandbox data saved as the base information. What should the user do?

Back 13

Commit the data to the cube

Front 14

You need to calculate the possible outcome if prices are raised. However, the data in the IBM TM1 server should not be overwritten. The IBM TM1 model contains many business rules and calculations but no scenario dimension, which is what you want. How do you proceed?

Back 14

Create a named Sandbox and change all values there

Front 15

A user wants to interactively stack and unstack dimensions to view. What are two ways to accomplish this?

Back 15

Use TM1 Cube Viewer

Use In-Spreadsheet Browser

Front 16

What data spreading options are available to users in the Perspectives or Architect Cube Viewer?

Back 16

Repeat

Straight Line

Front 17

A user wants to create a TM1 Excel report using the DBRW function. What are two ways to reference the elements in dimensions?

Back 17

Use an Element Name

Use an Element Alias

Front 18

Click the Exhibit button. In the cube shown in the exhibit, you need to show only the five most expensive products. The list should change dynamically with the selection of the budget version. How would you achieve this?

Back 18

Create a view filter with the option TopCount

Front 19

Which two options allow the end user to expand and collapse dimensional elements listed on the row dimension of a given data view in TM1 Web "on-the-fly"?

Back 19

Active Form

TM1 Web Cube View

Front 20

When using the suppress zero option in a cube view, data that is an aggregated or calculated value but still zero will display as what?

Back 20

Hidden

Front 21

Which three statements are true regarding TM1 Excel functions?

Back 21

The VIEW function creates an optimized view of the cube specified by the cube argument

ELCOMP returns the name of a child of a consolidated element in a specified dimension

SUBNM returns the element of a dimension subset and allows a double-click to bring up the subset editor

Front 22

What are three reasons why you would choose an Active Form over other report styles?

Back 22

When the user needs to drill down and drill up on rows

When the user needs to suppress zeros

When there is need to dynamically format cells

Front 23

A financial controller wants to create a financial statement report, however, the chart of accounts dimension has more aggregations than is required for the report. The controller wants to create a subset that has only the sub account and account elements. How should this be done?

Back 23

Use the Filter by Level function

Front 24

Which three selections are available when filtering a TM1 cube view?

Back 24

TopCount

BottomPercent

BotomSum

Front 25

A user wants to create a view looking at a particular product called "101 - Chips". They use the "Filter by Wild Card" function to locate the product, but no elements are returned. Which statement describes what is happening?

Back 25

The user does not first select the All function

Front 26

What is the difference between a TM1 Sandbox and a Personal Workspace?

Back 26

A Personal Workspace is a special default unnamed Sandbox where you begin your work

Front 27

When exporting a cube view from TM1 Web, which prerequisite is required to ensure charts are included?

Back 27

Microsoft Excel

Front 28

A user wants to update TM1 data within a Microsoft Excel worksheet. What are the three ways to do this?

Back 28

Create an Active Form from within the TM1 Cube View

Select In-Spreadsheet Browser from within TM1 Perspectives

Create an Excel Slice from within TM1 Cube Viewer

Front 29

Which three statements are correct about aliases?

Back 29

Aliases must be unique within the dimension

Subset (user defined consolidation) cannot be the same name as an alias

Aliases can be used for alternative languages

Front 30

Using TM1 Applicaiton Web, which applicaiton is required to create a bottom-up, submission based workflow with the ability to lock data after submisssion?

Back 30

Approval

Front 31

Which three selections would you find in the Properties window of the susbet editor?

Back 31

Weight

Type

Attribute

Front 32

A Private TM1 Cube View can be shared with which group?

Back 32

Only to the creator

Front 33

In TM1 Cube Viewer, you are viewing an Income Statement cube containing dimensions for Department, Months, Budget Version, and Account. Currently, the Account dimension is listed in the rows and the Months dimension is listed in the columns. You want to see a comparison of each element in the Budget version dimension next to each account. Which feature in TM1 Cube Viewer will acccomodate this requirement?

Back 33

Stacking dimensions

Front 34

The manufacturing department interacts with IBM Cognos TM1 data using TM1 Perspectives. They want to view data by product and location. Products are on the rows of the analysis and plants are on the columns. Products are consolidated into categories and locations are consolidated into regions. Which two interfaces allow them to expand and collapse on both the rows and columns of the analysis?

Back 34

Cube Viewer

In-Spreadsheet Browser

Front 35

A customer wants to be able to select elements from a subset for a fixed number of columns. Which statement is correct?

Back 35

Column labels can be dynamic by using Excel functions

Front 36

A user requires the use of the "Insert Subset" operation to create a user-defined consolidation in the TM1 Subset Editor. Which TM1 user interface would be used to do this?

Back 36

TM1 Explorer

Front 37

Click the Exhibit button. Referring to the exhibit, you are asked to allocate overhead expenses to the budget. Currently, everything is set to zero. You are instructed to allocate $100,000 to the Communications budget and to distribute the amount equally across all months. Which three TM1 data spreading options will allow you to do this?

Back 37

Proportional Spread

Equal Spread and selecting the "Extend Right" checkbox

Equal Leaves Spread and selecting "Apply to All Leaf Cells" radio button

Front 38

A subset was created using the Expression Recorder. The user modified the subset. What is the resulting change to the subset?

Back 38

The subset is static

Front 39

In Cognos Insight, user can perform which two functions?

Back 39

Import data

Publish model

Front 40

Which three statements are true when using the Print Report wizard?

Back 40

Print Report can be used to print for multiple elements in a title dimension

Print Report can be used to convert DBRW formula values

Print Report can print to PDF

Front 41

A company wants to deploy an application of summary level data and drill through capability to the underlying transaction detail. Which interface should be used?

Back 41

TM1 Web

Front 42

A user would like to export data from a TM1 Web Cube View so that subsequent data changes on the TM1 server will not affect the exported data. Which two export options should the user select?

Back 42

Snapshot to Excel

Export to PDF

Front 43

A user working within a TM1 Web Cube View needs to prevent a leaf cell from being changed by a spread operation. Which command would you use?

Back 43

Hold

Front 44

A user has invoked the Slice option in a TM1 Cube Viewer. Which TM1 Excel function is generated in each of the data cells?

Back 44

DBRW

Front 45

Which three statements are true in regards to the applications folder?

Back 45

Application folders can be used to publish reports to TM1 Web

Application folders can be used to organize reports

Application folder can be used to store references to URLS

Front 46

There has been a number of requests by users to have an option to easily select quarters for their views, rather than having to select the individual quarters every time they go into their views. Which solution meets this requirement?

Back 46

A new public subset should be created

Front 47

In which tier of the IBM Cognos TM1 client-server architecture does the TM1 Administration Server reside?

Back 47

Tier 3: Data

Front 48

How do you configure a TM1 Administration Server to run as a Windows service?

Back 48

Use tm1admsd.exe

Front 49

Which two functions have been optimized for the wide area network (WAN)?

Back 49

DBRW

DBSW

Front 50

An end user wants to interactively create a temporary consolidation that does not exist within the dimension using the TM1 Cube Viewer. Which action will accomplish this?

Back 50

Create a user defined subset and use the Roll Up function

Front 51

When should you use the DBR formula over the DBRW formula?

Back 51

When a cell must be calculate prior to being referenced

Front 52

The HR department requires a TM1 Web Labor Detail report which shows Total Salary, Benefits, and Taxes for each employee within a selected department. The user should be able to select a Department and have the rows of the report display just the employees in that Department with the costs across the columns. Employees should be sorted in descending order based on Total Salary. Unfortunately, Salary, Benefits and Taxes are all stored in different cubes and the cubes only share the Employee and Department dimensions. How should you build the Labor Detail report?

Back 52

Use an Active Form

Front 53

A user wants to update a TM1 cube with string data from an Excel spreadsheet. Which TM1 Excel function will allow you to do this?

Back 53

DBSS

Front 54

An international company has an existing TM1 server application they use for planning, forecasting, and reporting. The corporate strategy department wants to share parts of this application with external consultants and partners. They decide to create Cognos Insight workspaces which includes data from this server application combined with additional analysis and content. They intend to distribute a single workspace ".cdd" file to the recipients. How should they integrate the TM1 server data with additional content resulting in distributable Cognos Insight workspace files?

Back 54

Import TM1 cube views and subsets, save the workspace and the modify as needed

Front 55

When publishing a IBM Cognos Insight workspace to servers, which three actions can you perform?

Back 55

Publish to a TM1 server as a Responsibility Application

Publish to a TM1 server as a Central Application

Publish Cognos 10 BI server as crosstab reports

Front 56

A user would like to create a view showing the top 10 sales by region. Which type of subset would the user use to accomplish this?

Back 56

Filter-based Dynamic Susbet

Front 57

You are asked to prepare next year's budget for your organization. Because of budgetary pressures for the new year, you are instructed to copy last year's budget in the new year and reduce it by 5%. The TM1 cube you are using contains last year's budgetary data and the new year element has been added. Which two TM1 data spreading options will allow you to do this?

Back 57

Relative Proportional Spread followed by Percent Change

Relative Proportional Spread follow by Relative Percent Adjustment

Front 58

You need to calculate a ratio on all levels in IBM Cognos Insight. Which action would you take?

Back 58

Create a calculation and set the calcualtion order to Summarize First

Front 59

Whenever you open the Sales cube you see a hierarchical list of all products. The default view consists of default subsets for all dimensions. You would like to see a list of 10 products you are responsible for by default. Which three actions would achieve this?

Back 59

Create a private default subset for the product dimension and leave the default view unchanged

Create a private named subset for the product dimensions and create a private default view using it

Create a private default subset fo the product dimension and create a private default view using it

Front 60

A cube called Salary has two dimensions: Employee and Time. Using cube security, the security group Executive is READ access to the Salary cube. Using element security, the security group Executive is assigned WRITE access to all elements of the Employee dimension. Using element security, the security group Executive is assigned WRITE access to only 1 element, July, and READ access to all other elements in the Time dimension. A user of the security group Executive will have which access level when viewing the Salary cube?

Back 60

Read access to all cells