Which of the following are dimensional objects?

A. Sets and query calculation

B. Query subject andrelationship cardinality

C. Slicer and string function

D. Level and member

A report author is working with an OLAP data source. The reportauthor creates a query that uses a caption function on a member and applies a string function.

What is a possible consequence of this action?

A. Using these dimensional methods will not work with an OLAP data source.

B. The mapped string values willnot pass through to the target report.

C. There is nothing wrong with this approach.

D. Mixing dimensional styles and relational styles in a single query can create unexpected results.

A report author can use a slicer to dowhat?

A. Make the report database smaller and efficient

B. Provide context to intersection values

C. Reduce the number of members on the edge of the crosstab.

D. Generate a zero suppression filter in the rows

When the report consumer drills through from a dimensional member to a relational data item, what data type is passed?

A. Category code

B. Caption value

C. Member unique name

D. Business key

A report author creates a report with a drill-through definition. In the target report the parameter expression is "->?P?".

What type of data must be passed to the parameter?

A. A member from the level

B. Any member from the hierarchy

C. A value

D. A business key from the level

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])'.

A report author creates an expression usingthe 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 the lastPeriods(1,[Month]) expression currently in the report.

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

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.

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

1) -> ??

2) in (??)

3) = ??

4) set( -> ??)

A. 1 and 4

B. 1 and 2

C. 2 and 3

D. 3 and 4

Which of the following statements is correct about the order function?

A. The currentMeasure function must be used with the orderfunction as the sort by criterion.

B. It arranges members of all sets in the report by ascending or descending values.

C. Optional parameters allow the author to order the members of a hierarchy without regard of their level.

D. It arranges members of a set alphabetically by ascending or descending captions.

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.