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

Technote (troubleshooting)


Problem(Abstract)

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

Error Message -

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.

Related Documents -

KB# 1002637

Cross Reference information
Segment Product Component Platform Version Edition
Business Analytics Cognos 8 Business Intelligence Framework Manager
Business Analytics Cognos 8 Business Intelligence Install and Config
Business Analytics Cognos 8 Business Intelligence Report Studio
Business Analytics Cognos ReportNet ReportNet

Historical Number

1007185

Rate this page:

(0 users)Average rating

Document information


More support for:

Cognos ReportNet
ReportNet

Software version:

Cognos 8 BI Framework Manager 8.1, Cognos 8 BI Install and Config 8.1, Cognos 8 BI Report Studio 8.1, Cognos 8 BI Report Studio 8.2, Cognos ReportNet 1.1, Cognos ReportNet 1.1MR1, Cognos ReportNet 1.1MR2, Cognos ReportNet 1.1MR3

Operating system(s):

All, Solaris, Win, Windows

Reference #:

1344133

Modified date:

2007-09-20

Translate my page

Machine Translation

Content navigation