BusinessObjects Board

Setting 'ALL' in the prompt

building reports desktopintelligence
#1

Hi,

I don’t have access to Designer so I was trying to do it at the report level. The user wants ‘ALL’ as one of the option when he runs the report prompts. I know we can set it at the universe level by editing the LOVs. Can we do the same at the report level when we give the prompts?

Any ideas will be appreciated!
Thanks!

seemazr (BOB member since 2005-05-11)

#2

I think we can do it at Reporter level using union operator in the query panel.
Here is the link, which might help you https://bobj-board.org/t/15227/9

Pratibha (BOB member since 2003-11-19)

#3

Your universe designer would need to set up the *ALL value in the universe, then you’d be able to do the union query in Reporter as suggested.

ngosz :us: (BOB member since 2003-09-25)

#4

As far as I am aware all these solutions do require a predefined condition and a customized LOV, both of which can only be created in Designer.

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

#5

You’re right. I didn’t mention the predefined condition. But setting the ALL does indeed need to be done in the universe, regardless.

ngosz :us: (BOB member since 2003-09-25)

#6

Hi

I looked at the FAQ and other posts. But all are explaining with Oracle database.
How I can acheive this using SQL Server 2000?
My DBA is not willing to create a Dummy (DUAL) table, like we have in Oracle, in the database.

I’m using BO 6.5.1, SQL Server 2000.

Please give me some inputs.

Thanks,

Sree Konduri (BOB member since 2005-07-14)

#7

Is your DBA the universe designer?

I did this w/ SQL Server 2000 and created a dummy object within the universe, not in the database. Point the dummy object to a table and create a union query with (example Department in one query and ALL in the second query).

After that - create your pre-defined condition as suggested. There are examples in BOB for SQL Server I believe.

Look at this post
https://bobj-board.org/t/46757

ngosz :us: (BOB member since 2003-09-25)

#8

Thanks for the quick response.

My DBA is not a designer.

I followed the posts and created one object, when i try to parse it i’m getting an error "Parse Failed: Incorrect Syntax near the keyword ‘IN’.State;42000 "

Please find my syntax below and let me know where i’m going wrong

(@Select(ABC\Facility) IN @Prompt('Select a val or Enter * for All ','a','ABC\Facility',multi,free) OR '*' IN @Prompt('Select a val or Enter * for All ','a','ABC\Facility',multi,free))

thanks,

Sree Konduri (BOB member since 2005-07-14)

#9

Try this - gives you an illustrated walk through.

[url]http://homepage.mac.com/rmetzk/PDF_Files/Prompt_ALL.pdf

Found this doing a search within the Semantic Layer (Designer) area[/url]

ngosz :us: (BOB member since 2003-09-25)

#10

Oops…here’s the direct link

http://homepage.mac.com/rmetzk/PDF_Files/Prompt_ALL.pdf

ngosz :us: (BOB member since 2003-09-25)

#11

Thanks a lot !!!

It worked.

Sree Konduri (BOB member since 2005-07-14)