[Free] 2018(Jan) EnsurePass Testking IBM C2020-645 Dumps with VCE and PDF 21-30

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released C2020-645
100% Free Download! 100% Pass Guaranteed!

IBM Cognos 10 BI Multidimensional Author

Question No: 21

A report author creates a report with a drill-through definition. In the target report the parameter expression is quot;lt;Level expressiongt;-gt;?P?quot;. What type of data must be passed to the parameter?

  1. A member from the level

  2. Any member from the hierarchy

  3. A value

  4. A business key from the level

Answer: A

Question No: 22

The report author creates a source report that containsvalues from quot;Productsquot; on which the report consumer will drill through for details. The report author has created a target report which expects a member from the source. Is this a supported drill-through combination?

  1. Yes, this value-to-member drill-through is a supported combination.

  2. No, this value-to-member drill-through is not a supported combination.

  3. No, this member-to-value drill-through is not a supported combination.

  4. Yes, this member-to-value drill-through is a supported combination.

Answer: B

Question No: 23

A report author uses the following expression: lastPeriods(3,[2007/Mar]). What data will be returned when the report is run?

  1. The last 3 months before 2007/Mar

  2. 3 months, including 2007/Mar and the preceeding 2 months

  3. The total of currentMeasure for 3 months including 2007/Mar and the preceeding 2 months

  4. The month March of each of the 3 years 2005, 2006, and 2007

Answer: B

Question No: 24

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]gt;150000000).

Ensurepass 2018 PDF and VCE

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

  1. To return the set of members whose revenue is less than150000000 for any year.

  2. To return the set of members whose revenue is greater than 150000000 for the sum of the opposite edge.

  3. To filter the cell values by subtracting 150000000 from the revenue for each year and order method type.

  4. To filter the years to show those having revenues greater than 150000000 by order method type.

Answer: B

Question No: 25

Consumers want a report to compare the revenue and quantity sold for all product lines in a selected quarter, to the same quarter for the previousyear. They also want to see the total for periods, up to and including the quarter selected.

Ensurepass 2018 PDF and VCE

Which of the following dimensional functions could the report author use to create this report?

  1. Ancestor, currentMember, lead, total

  2. OpeningPeriod, order, quarter, Firstsibling

  3. Cousin, tuple, closingPeriod, aggregate

  4. ParallelPeriod, tuple, periodsToDate, aggregate

Answer: D

Question No: 26

What functionality will allow the report consumer to focus the report each time it is run?

  1. Filter a MUN

  2. Use a prompt

  3. Build a slicer

  4. Use a dimensional function

Answer: B

Question No: 27

When must a report author use the caption function?

  1. As the first parameter of the roleValue function.

  2. To return the display name for thespecified business key.

  3. To see the string display name for the specified element.

  4. To pass the returned value to a drill-through target report, this expects a matching string as a parameter value.

Answer: D

Question No: 28

What dimensional function is used to return the members on the level below the Product line level?

  1. Set

  2. Children

  3. Descendants

  4. members

Answer: C

Question No: 29

A report author uses an OLAP cube to create a crosstab with Revenue as a measure, the Product linelevel 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?

  1. Determine MUNs for the years 2005 and 2006, and then create an expressionusing the MUNs.

  2. Create a new column as a query calculation, and create the expression [2006]-[2005].

  3. Create a set of the 2005 and 2006 members and aggregate it.

  4. Ask the modeler to create a calculated category in Transformer and then use it directly.

Answer: B

Question No: 30

What type of prompt would a report author use to return a set of members from a hierarchy?

  1. Select and Search Prompt

  2. Value prompt

  3. Tree prompt

  4. Prompt Page

Answer: C

100% Ensurepass Free Download!
Download Free Demo:C2020-645 Demo PDF
100% Ensurepass Free Guaranteed!
C2020-645 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.