COGNOS BI0-145 Exam - BestSheet.com

Free BI0-145 Sample Questions:

1. To create a report from the data source shown, what entities will the report author use?

A. Members
B. Values
C. Levels
D. MUNs
Answer: B

2. In the data source shown, what dimensional component is selected?

A. Dimension
B. Hierarchy
C. Namespace
D. Level
Answer: B

3. A report author creates a crosstab as shown. What is the default measure of the report?

A. Mountaineering Equipment
B. Camping Equipment
C. Gross profit
D. Revenue
Answer: D

4. Based on the diagram, if the expression firstSibling([2006 Q 1]) is used in the report, what item will be returned?

A. 2005 Q 1
B. 2006 Q 4
C. 2006 Q 1
D. Nothing, because the return value equals the parameter
Answer: C

5. 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])'.
Answer: D