# [Free] 2018(Jan) EnsurePass Dumpsleader IBM C2020-645 Dumps with VCE and PDF 31-40

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released C2020-645
http://www.EnsurePass.com/C2020-645.html

IBM Cognos 10 BI Multidimensional Author

#### Question No: 31

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

#### Question No: 32

Which of the following family functions is most similar to the relativetime function parallelPeriod?

1. Cousin

2. PrevMember

3. Siblings

4. OpeningPeriod

#### Question No: 33

What does the following expression do: quot;generate([Productline],topCount(descendants(currentMember([sales_and_marketing].[Pro ducts].[Products]),[sales_and_marketing].[Products].[Products].[Product]),2,[Revenue]))quot;?

1. Returns the top two products by revenue for each product line.

2. Finds the top two members by revenue at the product level and returns their respective ancestors at the product line level.

3. Calculates the top two product lines for each product.

4. Goes two levels up from products and returns the top members by revenue at that level.

#### Question No: 34

What is a key difference between the total function and the aggregate function?

1. The aggregate function can only summarize within a set, and the total function can accept separate members.

2. The aggregate function isdimensional, and the total function is relational.

3. The aggregate function will summarize only the currentMeasure, and the total function will summarize any specified measure.

4. 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: 35

The dialog box shown appears when a report is run.

What should the report author do to correct the situation?

1. Ask the modeler to rename the hierarchy to #39;[sales_and_marketing].[Products].[Products].[Products]#39;, and to republish the package.

2. Modify the expression to change the #39;currentMember#39; function to #39;currentLevel#39;.

3. Modify the expression to change the #39;currentMember#39; function to #39;currentHierarchy#39;.

4. Modify the expression to #39;currentMember([sales_and_marketing].[Products].[Products])#39;.

#### Question No: 36

Based on the crosstab displayed, the report author creates a singleton using the tuple function as follows: tuple([Camping Equipment],[Revenue],[2006]).

Which of the following will appear in the singleton when the report is run?

A. Camping Equipment, 500,382,422.83, 2006

B. 500,382,422.83

1. Camping Equipment, Revenue, 2006

2. Nothing, singletons are notdimensional objects.

#### Question No: 37

In a crosstab report, the report author wants a column to display a percentage of overall revenue that a particular product contributed to.

Which of the following is a valid dimensional expression forthis purpose?

1. tuple([Revenue]/[Products]*[Revenue])

2. [Revenue]/([Revenue]*[Products])

3. [Revenue]/tuple([Revenue],[Products])

4. [Revenue]/total([Revenue]for[Products])

#### Question No: 38

A report author creates an expression usingthe closingPeriod function to return the latest month found in the data source, and names the expression quot;Current Monthquot;. What can the report author do with quot;Current Monthquot;?

1. Use it to replace the lastPeriods(1,[Month]) expression currently in the report.

2. Add it to an expression to find the current member for the Month level.

3. Use it to determine the current quarter: parent([Current Month]).

4. Use it as a report expression to display the current month in the page header of the report.

#### Question No: 39

Can a prompt be used in the expression of a slicer?

1. Yes, if the correct syntax is used.

2. No, the slicer syntax is not compatible with prompt syntax.

3. Yes, if the slicer is a hierarchy.

4. No, the slicer must be manually created by the report author.

#### Question No: 40

Of the following prompt syntax expressions, which two are considered to be dimensional?

1. lt;expressiongt; -gt; ?lt;prompt namegt;?

2. lt;expressiongt; in (?lt;prompt namegt;?)

3. lt;expressiongt; = ?lt;prompt namegt;?

4. set(lt;expressiongt; -gt; ?lt;prompt namegt;?)

1. 1 and 4

2. 1 and 2

3. 2 and 3

4. 3 and 4