How to build a multiselect prompt in Tabular SQL

Technote (troubleshooting)


Problem(Abstract)

How to build a multiselect prompt in Tabular SQL

Resolving the problem


Use the promptmany function within the Tabular SQL

For example:

select distinct "PRODUCT_LINE"."PRODUCT_LINE_EN" AS "Product_line"
from "PRODUCT_LINE" "PRODUCT_LINE"
where "PRODUCT_LINE"."PRODUCT_LINE_EN" in (#promptmany('PL')#)

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

Historical Number

1030343

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Cognos ReportNet
ReportNet

Software version:

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

Operating system(s):

All, Linuxi386, Win, Windows

Reference #:

1374642

Modified date:

2008-07-10

Translate my page

Machine Translation

Content navigation