VCEdump

C2090-645 IBM Cognos 10 BI Multidimensional Author

PDF question preview Back to product

Reading controls

Reader tools

Free demo

9 of 56 questions

Purchase the full version to unlock every question and answer.

View the full question set

Preview tools

Try Web TestEngine

Question formats

Single choice9

IBM · C2090-645

Free C2090-645 Exam Dumps Preview

Preview real exam questions, verified answers and available explanations before choosing a study plan.

Question 1

Single choice

A report author uses the following expression: lastPeriods(3,[2007/Mar]).

What data will be returned when the report is run?

A
The last 3 months before 2007/Mar
B
3 months, including 2007/Mar and the preceeding 2 months
C
The total of currentMeasure for 3 months including 2007/Mar and the preceeding 2 months
D
The month March of each of the 3 years 2005, 2006, and 2007

Reveal answer details Close answer details

Correct answerB

Question 2

Single choice

If the syntax for thehead function is head(set_exp[,index_exp]),then which of the following expressions is correct?

A
head(members([sales_and_marketing].[Products].[Products].[Product line]),2)
B
head(([sales_and_marketing].[Products].[Products].[Product line])[,2])
C
head(order([sales_and_marketing].[Products].[Products].[Product line])2)
D
head(members([sales_and_marketing].[Products].[Products].[Product line],2))

Reveal answer details Close answer details

Correct answerA

Question 3

Single choice

What is the default behavior when drilling down on an edge in a crosstab report?

A
The level drilled on is replaced with the entire level below it.
B
The edge expression is replaced with the children of the item drilled on.
C
All edge expressions of the crosstab are replaced with their children.
D
The edge expression is changed to another item in the query.

Reveal answer details Close answer details

Correct answerB

Question 4

Single choice

The following expression is used to focus OLAP data in the rows of a report:
filter([sales_and_marketing].[Order method].[Order method].[Order method type], [Revenue]>150000000).

Which of the following statements describes the purpose of the expression?

A
To return the set of members whose revenue is less than150000000 for any year.
B
To return the set of members whose revenue is greater than 150000000 for the sum of the opposite edge.
C
To filter the cell values by subtracting 150000000 from the revenue for each year and order method type.
D
To filter the years to show those having revenues greater than 150000000 by order method type.

Reveal answer details Close answer details

Correct answerB

Question 5

Single choice

The report author creates a query where two items (TopThree and Retailer country) exist in the same member set. The expression for TopThree is: topCount([Retailer country],3,[Revenue]).

What drill behavior should the report author set in order to display the top three children instead of all children on drill down?

A
Configure TopThree to Change Expression, and configureRetailer country to Preserve.
B
Configure TopThree to Preserve, and configure Retailer country to Preserve.
C
Configure TopThree to Preserve, and configure Retailer country to Replace Expression.
D
Configure TopThree to Ancestor, and configure Retailercountry to Change Expression.

Reveal answer details Close answer details

Correct answerC

Question 6

Single choice

A reportauthor creates a crosstab as shown.

What is the default measure of the report?

A
Mountaineering Equipment
B
Camping Equipment
C
Gross profit
D
Revenue

Reveal answer details Close answer details

Correct answerD

Question 7

Single choice

In a crosstab, Campaign is in the rows area, Order method type is in the columns area, and Quantity is the measure. Campaign and Order method type are specified in the query. The report runs, displaying quantity valuesfor all years.

Why does this happen?

A
The dimension member from that dimension is implied.
B
The order method member from that dimension is implied.
C
The aggregate member from that dimension is implied.
D
The default member from that dimensionis implied.

Reveal answer details Close answer details

Correct answerD

Question 8

Single choice

Why would a report author consider overriding the default drill behavior?

A
To maintain the behavior of a complex edge expression after drilling, such as one which returns the top 5 members of a set.
B
To replace all members within a hierarchy when drilling through to a report with more detail.
C
To drill down to the lowest level of the hierarchy and then drill down again to display only one member.
D
To drill down on a member and have its children display as details and have the member drilled on display as summary.

Reveal answer details Close answer details

Correct answerA

Question 9

Single choice

The dialog box shown appears when a report is run.

What should the report author do to correct the situation?

A
Ask the modeler to rename the hierarchy to '[sales_and_marketing].[Products].[Products].[Products]', and to republish the package.
B
Modify the expression to change the 'currentMember' function to 'currentLevel'.
C
Modify the expression to change the 'currentMember' function to 'currentHierarchy'.
D
Modify the expression to 'currentMember([sales_and_marketing].[Products].[Products])'.

Reveal answer details Close answer details

Correct answerD

Free C2090-645 Exam Dumps Preview

IBM Cognos 10 BI Multidimensional Author

PREVIEW CONTENTS · 1 VOLUME

QUESTION 1

QUESTION 2

QUESTION 3

QUESTION 4

QUESTION 5

QUESTION 6

QUESTION 7

QUESTION 8

QUESTION 9