Unable to open a report based on a Text Blob from Report Studio.

Technote (troubleshooting)

Problem(Abstract)

QE-DEF-0357 Using the blob column [vw_subject].[Note] in this query, requires that the query subject must have either a key or a unique index.

Resolving the problem

Ensure that you have a key for the table in the database. In Framework Manager, right click on the table and select Specify Dimension Information. Once the window is open, drag the unique id from the Available items window to the Levels window. Select the Unique Key check box.

An example of this can be illustrated using the Request String in the Native Queries table from the IBM Cognos ReportNet Audit database. To create a report using this field it is necessary to designate a unique key in the framework manager model. Set the request id as the unique level and you will be able to create a report that includes this field.