IBM C1000-065 Exam With Confidence Using Practice Dumps

To modify a prompt in a relational sourced report to support multi-select functionality, make the following changes:

Change Prompt Property Usage to Select-many:

Edit the Prompt: Select the prompt object in the report.

Property Panel: In the properties panel, change the "Usage" property from "Select-one" to "Select-many". This allows users to select multiple values in the prompt.

Update Filter Expression:

Edit Query: Open the query associated with the prompt.

Change Filter Expression: Modify the filter expression from using "=" to "in". This change ensures that the filter can handle multiple values selected by the user.

These modifications enable the prompt to accept multiple selections and apply the filter accordingly in the report.

To create a Layout Component Reference in a report in IBM Cognos Analytics V11.1.x, you need to provide the "Name" property. Here are the steps:

Define Component: Identify the component you want to reference in your report layout.

Set Name Property: Assign a unique name to the component in its properties. This name will be used to reference the component.

Create Layout Component Reference: In the report where you want to use the component, add a Layout Component Reference and specify the name of the original component.

Reference the Component: The referenced component will be displayed in the new location, allowing you to reuse layout elements across multiple reports.

Using the "Name" property ensures that components can be easily referenced and maintained.

Query Performance: Enhancing query performance involves various optimization techniques.

Avoid Functions in Filters: Using functions in filters can lead to slower query performance because functions often require additional computation and can prevent the database from using indexes efficiently.

Best Practices: It is recommended to simplify filters and avoid complex functions to ensure queries run faster.

Reference: IBM Cognos Analytics V11.1.x documentation suggests avoiding the use of functions in filters as a best practice for improving query performance.