BusinessObjects Board

Missing Right paranthesis error while parsing

building semantic layer
#1

I am looking at this post in Designer FAQ

I am trying to adapt the following to my object:

(@Select(Sales Geography\Country Group) IN @Prompt('Select Country Group or 
enter * for all groups','a','Sales Geography\Country Group',multi,free) ) OR 
('*' in @Prompt('Select Country Group or enter * for all groups','a','Sales 
Geography\Country Group',multi,free))

so my object’s select looks like:

(@Select(Product\Product Group) IN @Prompt('Select Product Group or enter % for all groups','a','Product\Product Group',multi,free) ) OR ('%' in @Prompt('Select Product Group or enter % for all groups','a','Product\Product Group',multi,free))

But when I try to Parse the statement, it gives me an error “Missing Right Parenthesis”. I have tried putting everything in paranthesis, but it still gives an error.

The SQL generated if I want to use this object in a report is :

  (( DM.DM_PRODUCT_DIMENSION.PRODUCT_GROUP ) IN @Prompt('Select Product Group or enter % for all groups','a','Product\Product Group',multi,free) ) OR ('%' in @Prompt('Select Product Group or enter % for all groups','a','Product\Product Group',multi,free))

I am unable to figure out what I am doing wrong…

Please help…

Thanks

chiragk :us: (BOB member since 2003-10-22)

#2

Look at the pure SQL code, then remove the unnecessary parenthesis’.

Andreas :de: (BOB member since 2002-06-20)

#3

I have updated my previous post with SQL… I have been looking at the sql too, but nothing so far…

Any ideas?

chiragk :us: (BOB member since 2003-10-22)

#4

Try this:

DM.DM_PRODUCT_DIMENSION.PRODUCT_GROUP IN @Prompt('Select Product Group or enter % for all groups','a','Product\Product Group',multi,free) OR '%' in @Prompt('Select Product Group or enter % for all groups','a','Product\Product Group',multi,free)

Andreas :de: (BOB member since 2002-06-20)

#5

I get

ORA-00923 - FROM keyword not found where expected

I am on Oracle, does that make a difference?

chiragk :us: (BOB member since 2003-10-22)

#6

PS. Does this statement have to be in Select clause or Where condition?

chiragk :us: (BOB member since 2003-10-22)

#7

Looks like a predefined condition or a where clause. I would make it a predefined condition.

Scott Bowers :us: (BOB member since 2002-09-30)

#8

OK. Got it to work…

Here is the solution in designer:

Object Name:

"Product_Group Prompt"

Select Statement:

@Select(Product\Product Group)

Where Clause:

(@Select(Product\Product Group) IN @Prompt('Select Product Group or enter % for all groups','a','Product\Product Group',multi,free) ) OR ('%' in @Prompt('Select Product Group or enter % for all groups','a','Product\Product Group',multi,free))

Thanks all.

chiragk :us: (BOB member since 2003-10-22)