IBM C1000-065 Dumps Questions Answers

Filter Expression: The filter expression[Product Group] = # sq( prompt( 'productgroups', 'token', 'Clothes' ) )#uses a prompt macro.

Default Text: The string 'Clothes' acts as the default value for the prompt. If the user does not provide a value at runtime, 'Clothes' will be used in the generated query.

Macro Function: Thepromptfunction retrieves the value provided by the user or defaults to 'Clothes' if no value is supplied.

Reference: IBM Cognos Analytics V11.1.x documentation provides detailed information on using macros and prompt functions, including the use of default values in filter expressions.

In IBM Cognos Analytics V11.1.x, when formatting text in a dashboard crosstab or table, the following statement is true:

Table Summary Row Formatting:

Customization: You can format the table summary row with a different color. This allows for visual differentiation between the summary row and other rows in the table or crosstab.

Implementation: Select the summary row, access the formatting options, and apply the desired color.

Additional Formatting Capabilities:

Column Titles: Although column titles can be formatted individually in terms of font, color, and size, this is a general capability and not specific to summary rows.

Text Wrapping: By default, the object does not wrap text, but this option can be enabled if needed.

Applying specific formatting to the summary row enhances the readability and visual appeal of the data presentation.

Creating a context filter for a crosstab report using a dimensional data source in IBM Cognos Analytics V11.1.x involves filtering measure values without affecting the items in the rows and columns. Here is how it works:

Open Crosstab Report: Open the crosstab report in Cognos Analytics Report Studio.

Select Measure: Identify the measure you want to filter.

Add Context Filter: Apply the context filter to the measure. This filter will affect only the measure values and not the dimensional items in the rows and columns.

Filter Configuration: Configure the filter criteria as needed to refine the measure values displayed in the crosstab.

Using context filters in this manner allows for precise control over the data being analyzed without altering the structure of the crosstab.