A report author has applied one style in specific cells, and another style for the overall report.

Which style will be applied?

A. The style on the specific cell is applied.

B. The style on the overall report is applied.

C. The last style in the Conditional styles property is applied.

D. The first style in the Conditional styles property is applied.

The sales department has requested the report author to build a report which combines a list with a chart. The list must contain product lines and the chart should show details for each product line. The report author decided to use a Master detail relationship to build this report.

Which statement about Master detail relationships is true?

A. Calculations across Master detail queries can be performed.

B. Parent data in the child frame or child data in the parent frame can be displayed.

C. Master detail relationships must appear in nested frames to produce the correct results.

D. When working with an SAP BW Data source, a data item from the master query that contains non-ASCII values can be used.

A report author has the following filter in a report:

[Product line] in ?pline?

The report author adds a Value prompt based on the existing parameter `pline'. After adding the prompt,

the Auto-submit property is defaulted to `No' and cannot be changed to `Yes'. What is the cause of this?

A. Default selections are missing in the Value prompt.

B. The Value prompt created based on the filter is a Multi-select prompt.

C. A prompt based on an existing parameter as Auto-submit cannot be made.

D. Auto-submit is a property that is only available for select and search prompts.

A report author needs to create an offline interactive report that can be filtered by clicking on a list of values. For example, by clicking on Region "A" the List will display only the details from Region "A".

Which Reaction behavior should be selected?

A. Enable a control.

B. Filter an item in a control.

C. Select an item in a control.

D. Create a report expression and use it in filters.

A user is creating a join relationship in a Data module. What benefit can be expected from setting a filter join?

A. The performance on the join could be improved.

B. The result set from the join would return less rows.

C. The result set from the join would return more rows.

D. The join relationship would work on multiple fields in each table.

A company would like to implement their own corporate style across all reports using a single Report as a reference. A requirement is to display the year of the data selected in the report in the header. The year is not being resolved correctly as shown below: How can the problem with this report be resolved?

A. The component reference has to be overwritten with a new defined "My Header Title" inside the new report.

B. The component reference has to be overwritten with a new defined "MyYear Singleton" inside the new report.

C. A component reference cannot contain a Singleton. The "Corporate Layout Reference" report has to be changed.

D. A component reference cannot contain a Singleton. The reference cannot be used and the header has to be created manually.

A report author wants to create an Active Report with a Data deck that only prompts for Product line and Year. For each card created, the Order method type broken down by revenue should be shown.

What needs to be done to ensure the data on each card reflects the correct year and Product line?

A. Use a Repeater table in the Card deck.

B. Each card should have a separate query.

C. Filters should be copied from the Data deck to the cards.

D. Use a Master detail relationship between the cards and the Data deck.

Which statement is true about adding columns from the source package after modifying a query?

A. Columns cannot be added from the source package to a report after adding an SQL object.

B. Columns can be added from the source package to a report after modifying an SQL object.

C. Columns cannot be added from the source package to a report after deleting an SQL object.

D. Columns can be added from the source package to a report only before adding an SQL object.

An author wants to include new data in an existing Dashboard.

Which type of Data source can be used?

A. Pivot tables

B. Data Modules

C. Published packages

D. Framework Manager models

A report author was asked to create a report that displays Order method data within a List with a guide pointing to each Order method.

How can this be accomplished?

A. By creating a grouped list by Order method.

B. By creating data decks with lists filtering Order method.

C. By creating page breaks based on a data item and defining a grouping structure for the page set.

D. By adding a table of contents and a table of contents entry next to the order within the List.