A table contains a dimension [CITY] and a measure [SALES]. You insert a column to display the formula AVERAGE([SALES]). Which operator do you add to the formula so that it displays the average for the table in every row? Note: There are 2 correct Answers to this question.

• A.In Block
• B.In Body
• C.ForAll ([CITY])
• D.ForEach ([CITY])

Comment: *

Name: *

Email: *

Verification: *

Identify from the following options which ensure that the data displays on the page in a way that is easy to view and interpret?
Please choose the correct answer.
Response:

• A.The Padding options at single level of your document
• B.The Page break options at various levels of your document
• C.The Format options at various levels of your document
• D.The Format options at single level of your document

Comment: *

Name: *

Email: *

Verification: *

Explain the different types of data changes that Web Intelligence can highlight with the data tracking feature?
There are 2 correct answers to this question
Response:

• A.Duplicate data
• B.Multiple data
• C.Removed data
• D.Modified data

Comment: *

Name: *

Email: *

Verification: *

What can you do with a scope of analysis? Note: There are 2 correct Answers to this question.

• A.Provide further detail on data.
• B.Perform a calculation.
• C.Restrict the data retrieved from the database only to the objects on the report.
• D.Request the data from the database for drilling.

Comment: *

Name: *

Email: *

Verification: *

Where is a predefined query filter created?

• A.In the Input Controls pane
• B.In the query panel
• C.In the universe
• D.In the filter bar

Comment: *

Name: *

Email: *

Verification: *