Skip to Content

@prompt not functioning in where clause

I have attempted to use the following in a where clause of a dimension object:

ORGANIZATION_DIM.ORGANIZATION_ID = @Prompt('Which Organization?','A','Cash Receipts\Organization ID',mono,constrained,not_persistent,{'ORG0001'})

When I use the object in a WebI query, the following SQL is generated:

SELECT

ORGANIZATION_DIM.ORGANIZATION_ID

FROM

ORGANIZATION_DIM

WHERE

( ( ORGANIZATION_DIM.ORGANIZATION_ID = @Prompt('Which Organization?','A','Cash Receipts\Organization ID',mono,constrained,not_persistent,{'ORG0001'}) ) )

When I run the query, the "query in process" pop up appears briefly and then nothing but a windows hourglass.

If I use the same @prompt in the where clause of a filter object and use the filter object in my WebI query, the same SQL is generated. When I run the query using the filter, the prompt appears as expected and the query runs successfully.

Any thoughts on what may be happening here?

0
Add a comment
10|10000 characters needed characters exceeded

author's profile photo Former Member
Former Member Dec 01, 2009 at 07:55 PM

0

25

Actions

3 Answers

Best Answer
author's profile photo Former Member
Former Member Dec 02, 2009 at 09:50 PM
2

Oracle 10g

Add a comment
10|10000 characters needed characters exceeded

Efstratios Karaivazoglou
Dec 01, 2009 at 08:13 PM
0

Hi

which version of BOBJ are you using?

Regards,

Stratos

Add a comment
10|10000 characters needed characters exceeded

author's profile photo Former Member
Former Member Dec 01, 2009 at 10:40 PM
0

BOBJ XI (12.1.0)

Add a comment
10|10000 characters needed characters exceeded