Sample Questions:

You want to force the calculation context of a variable in a table so that its values do not change when a dimension is added to the table. Which of the following statements is correct?

You include the dimension using the input context.

You exclude the dimension using the input context

You include the dimension using the output context.

You exclude the dimension using the output context.

You open a Web Intelligence document (WID) with tracked data changes. You wish to change the color of the tracked dat

You however cannot change the format of the tracked data. What should you do to enable formatting of the tracked data?

Contact the system administrator.

Edit the document in tracking mode.

Open the document in tracking mode.

Resave the document with data tracking formats enabled.

Which two are benefits of creating queries from existing queries? (Choose two.)

Improved query security

Accurate duplication of query parameters

Improved performance of query execution

Reduced creation time for complex reports

Which statement is true about calculation contexts?

They allow manipulation of reports to change the way the data is displayed.

They allow manipulation of variables to change the way the data is aggregated

They allow manipulation of universe objects to change the way the data is displayed.

They allow manipulation of universe contexts to change the way the data is aggregated

Which three statements about the If() function are correct? (Choose three.)

Values within the function must be in quotes.

The function can be used to create a variable

The function can contain an aggregate function.

Then and Else keywords can be used within the function instead of the semicolon.

Which two statements describe reasons for using the Format Date() function? (Choose two.)

You want to convert a string object into a date object.

You want to convert a date object into a string object.

You want to format a date so that it is displayed as a string when it is concatenated with another string

You want to modify the format of a string object into a non-standard date format