SAP Community Migration News!
Important Dates! SAP Community will be READ-ONLY from January 16 â January 23 for the technical migration.
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?
Help to improve this question by adding a comment
If you have an answer for this question, then please use the Your Answer form at the bottom of the page instead.
You already have an active moderator alert for this content.
Oracle 10g
Help to improve this answer by adding a comment
If you have a different answer for this question, then please use the Your Answer form at the bottom of the page instead.
You already have an active moderator alert for this content.
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
Hi
which version of BOBJ are you using?
Regards,
Stratos
Help to improve this answer by adding a comment
If you have a different answer for this question, then please use the Your Answer form at the bottom of the page instead.
You already have an active moderator alert for this content.
BOBJ XI (12.1.0)
Help to improve this answer by adding a comment
If you have a different answer for this question, then please use the Your Answer form at the bottom of the page instead.
You already have an active moderator alert for this content.
Hi
which kind of database do you use?
Regards,
Stratos