@prompt not functioning in where clause

[Former Member]

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?

[Former Member · Accepted solution]

Oracle 10g

[former_member142702 · Accepted solution]

Hi

two more question:

1) Does 'Cash Receipts\Organization ID' appear before or after the dimension object you are talking about in the object browser in your universe?

2) Can you consider installing the latest Fix PAck (1.9)?

Regards,

Stratos

[Former Member]

BOBJ XI (12.1.0)

[former_member142702]

Hi

which kind of database do you use?

Regards,

Stratos

[former_member142702]

Hi

which version of BOBJ are you using?

Regards,

Stratos