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

A. Members

B. Values

C. Attributes

D. MUNs

A crosstab report has product lines in the rows, years in the columns, and revenue as the measure. In Query Explorer, from the source tree, the report author drags the order method Telephone to the Slicer pane.

Why does the report author do this?

A. To help to set the context.

B. To create an ordered set.

C. To return only one tuple.

D. To aggregate the telephone member.

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

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

To display all individual campaigns in a crosstabreport, a report author could use the expression set([TrailChef Campaign],[EverGlow Campaign],[Course Pro Campaign]). Instead, the report author decides to use the parent member of the campaigns in the set expression "children([All Campaigns])".

Which statement is true about the method that was used?

A. In the future, when a campaign is deleted or new ones are added, the report author must modify the expression.

B. In the future, when a campaign is deleted or new ones are added, the unmodified expression will be valid.

C. The report author should not have used the method chosen, as the first method is best in this situation.

D. To be accurate, the report author should avoid using a set expression.