IBM Cognos 8 BI Multidimensional
my contribution to the brain dumps. For this exam I used
www.exams.ws guide and I got cleared the paper.
QUESTION NO: 1
A report runs,
and is 433 pages long, with 19,010 rows. Many of the
rows are blank. The report author uses a filter function
to filter nulls, and runs the report again. The result
is 143 pages, with
6273 rows, and none of
the rows are blank. What filtering style did the report
author decide to use?
QUESTION NO: 2
What is a key
difference between the total function and the aggregate
A. The aggregate
function can only summarize within a set, and the total
function can accept
B. The aggregate
function is dimensional, and the total function is
C. The aggregate
function will summarize only thecurrentMeasure, and the
total function will
summarize any specified
D. The aggregate
function follows the rollup rules of the measure defined
in the data source, and
the total function adds
the total of the specified measure.
QUESTION NO: 3
A report author
uses an OLAP cube to create a crosstab with Revenue as a
measure, the Product line level in the rows, and the
year members (2004-2007) in the columns. How can the
report author efficiently determine the difference in
revenue between the years 2005 and 2006?
A. Determine MUNs
for the years 2005 and 2006, and then create an
expression using the MUNs.
B. Create a new
column as a query calculation, and create the
dimensional expression -.
C. Create a set of
the 2005 and 2006 members and aggregate it.
D. Ask the modeler
to create a calculated category in Transformer and then
use it directly.
QUESTION NO: 4
functionality will allow the report consumer to focus
the report each time it is run?
A. Filter a MUN
B. Use a prompt
C. Determine a
D. Calculate the
QUESTION NO: 5
function is used to return the members on the level
below the Product line level?
QUESTION NO: 6
When must a
report author use the caption function?
A. As the first
parameter of theroleValue function.
B. To return the
display name for the specified business key.
C. To see the
string display name for the specified element.
D. To pass the
returned value to a drill-through target report,which
expects a matching string as a parameter value
QUESTION NO: 7
Of the following
prompt syntax expressions, which two are considered to
-> ?<prompt name>?
in ?<prompt name>?
= ?<prompt name>?
set(<expression> -> ?<prompt name>?)
A. 1 and 4
B. 1 and 2
C. 2 and 3
D. 3 and 4
QUESTION NO: 8
A report author
creates an expression using the closingPeriod function
to return the latest month found in the data source, and
names the expression "Current Month". What can the
report author do with "Current Month"?
A. Use it to
replace thelastPeriods(1,[Month]) expression currently
in the report.
B. Add it to an
expression to find the current member for the Month
C. Use it to
determine the current quarter:parent([Current Month]).
D. Use it as a
report expression to display the current month in the
page header of the report.
QUESTION NO: 9
prompting the user to select any countries in Europe,
the report author wants to constrain the user to select
one or more countries from the Northern Europe region.
What kind of prompt should be used and how can this be
A. This is not
possible because a prompt must always be populated with
all members of a level.
B. Create a
multi-select value prompt. Populate it using an
expression on the [Northern Europe] member to retrieve
its children on the country level.
C. Generate a
prompt by creating an expression with a parameter on the
crosstab edge: children ([Northern Europe]->?Country?
D. Create a tree
prompt, and populate it using an expression on the
[Northern Europe] member to retrieve its children at the
QUESTION NO: 10
What type of
prompt would a report author use to return a set of
members from a hierarchy?
A. Level prompt
B. Value prompt
C. Tree prompt
D. Page prompt
QUESTION NO: 11
What does the
following expression do: "generate([Product
A. Returns the top
two products by revenue for each product line.
B. Finds the top
two members by revenue at the product level and returns
their respective ancestors at the product line level.
C. Calculates the
top two product lines for each product.
D. Goes two levels
up from products and returns the top members by revenue
at that level.
QUESTION NO: 12
Which of the
following is true if a report author nests members in a
A. Nested members
are also known as complex members.
B. The inner member
must be on the level immediately below the outer member.
C. Nested members
must be members of hierarchies, not of the Measures
D. It is possible
to nest members from different dimensions.
QUESTION NO: 13
If the syntax
for the head function is head(set_exp[,index_exp]), then
which of the following expressions is correct?