Custom sql in webi

building reports webintelligence
1

Its an example:

I have article_id and label on which i have created the cascading prompt.

Enter article_id
Then it will ask enter article_label.

I want enter article_id to be hard coded by me and user should have option only to select article_label

I want to hard code the id say article_id=1 at the report end not at the universe level what changes do i need to make in the below sql.

SELECT

Article_lookup.Article_label,

Article_lookup.Article_id
FROM
Article_lookup
WHERE

Article_lookup.Article_label In @prompt(‘Enter value(s) for SKU desc:’,‘A’,‘Product\SKU desc’,Multi,Free,Persistent,User:0)

thanks

itchel (BOB member since 2010-05-26)

2

Any suggestons…

itchel (BOB member since 2010-05-26)

3

Add this to your where clause "and article_id=1 "

sowmyabatchu (BOB member since 2009-10-14)

4

Moderator Note:
Please do not bump your post until at least one business day has passed.

Marek Chladny :slovakia: (BOB member since 2003-11-27)