How to Create ALL Option in Prompt?

[system]

Hi,

Could U please Guide me to create ALL option in prompt for the following details…

BO : 6.5
Database : Oracle 9i
User : Scott
Table Name:EMP

I created universe for EMP table. I followed all the steps given in (businessobjects_advanced.pdf page No :54) technical support site.

step 1 ->I created dummy table and i included one column values “ALL” …
step 2 ->I created one object(name ALL), In the select column i referred the column in dummy table .
step 3 ->In the Ename list of values ALL is displaying along with other Enames by using union operator.
step 4 ->With reference to document again i created one object(name enameprompt)

• In the select column i gave SCOTT.EMP.ENAME
• In the where clause i got the following error : Parse failed :Invalid Definition(UNV0023)

This is my where clause query

SCOTT.EMP.ENAME IN (select case @Prompt(‘choose a Ename or Enames’,‘a’,’ Emp\Ename’,multi,constrained) when ‘ALL’ then SCOTT.EMP.ENAME else @Variable(‘choose a empname’) end)

Could u please modify the above query based on my requirement…

…
Thanks & Regards,
Kumaresh Gopalsamy

---

bown (BOB member since 2007-07-10)

[system]

please remove the …select… from the definition.

---

shikharnathsil (BOB member since 2006-11-01)

[system]

Hi shikharnathsil,

I tried by removing select in the definition again the same problem occurs… plz guide me…

---

bown (BOB member since 2007-07-10)

[system]

Plz help me to solve this issue…

---

bown (BOB member since 2007-07-10)

[system]

Go through this

"ALL" as Default Value in Prompt created in Univer

Hello, I am having trouble select Specific value while I use “ALL” in Prompt. We have 3 prompts in one report and 1 they need Specific value and another 2 prompts they need User to select / Type “ALL” in prompt or select Specific Value from LOV. While I am typing ALL its giving me data but while I am using specific value it gives me No data fetch. How can I resolve this problem ? Also I am unable to Insert ALL in LOV value. Can anybody explain step by step how to insert ALL in LOV as well as…

---

haider (BOB member since 2005-07-18)

[system]

Hey kumareshgopal,
This is my where clause query

SCOTT.EMP.ENAME IN (select case @Prompt(‘choose a Ename or Enames’,‘a’,’ Emp\Ename’,multi,constrained) when ‘ALL’ then SCOTT.EMP.ENAME else @Variable(‘choose a empname’) end)

I think your problem is in defining Where Clause.
It should be like this: SCOTT.EMP.ENAME IN @Prompt(‘choose a Ename or Enames’,‘a’,’ Emp\Ename’,multi,constrained) OR ‘ALL’ IN @Prompt(‘choose a Ename or Enames’,‘a’,’ Emp\Ename’,multi,constrained)

Follow this we definitely get correct results. Reply back if you have any doubts regarding this one.

Thanks

---

MightyBO (BOB member since 2007-06-28)

[system]

Hi kevvukeka,

Again Parsing is failed… could u help me to solve this issue…

Thanks,

---

bown (BOB member since 2007-07-10)

[system]

What is the final syntax of the expression which is giving parsing error.

And hopefully this is not for interview question again :x

Cheers

---

haider (BOB member since 2005-07-18)

[system]

Hi .

select statement : SCOTT.EMP.ENAME

This is the where clause query for an object ENAME:

SCOTT.EMP.ENAME IN @Prompt(‘choose a Ename or Enames’,‘a’,’ Emp\Ename’,multi,constrained) OR ‘ALL’ IN @Prompt(‘choose a Ename or Enames’,‘a’,’ Emp\Ename’,multi,constrained)

while parsing it shows an error

Parse Failed: invalid Definition (UNV0023)

thanks,

---

bown (BOB member since 2007-07-10)

[system]

Hi,
SCOTT.EMP.ENAME IN @Prompt(‘choose a Ename or Enames’,‘a’,’ Emp\Ename’,multi,constrained) OR ‘ALL’ IN @Prompt(‘choose a Ename or Enames’,‘a’,’ Emp\Ename’,multi,constrained)

a should be A

---

MightyBO (BOB member since 2007-06-28)

[system]

Hi,

I checked already, that too give the same error…

Thanks…

---

bown (BOB member since 2007-07-10)

[system]

SCOTT.EMP.ENAME IN @Prompt('choose a Ename or Enames','a','Emp\Ename',multi,constrained) OR 'ALL' IN @Prompt('choose a Ename or Enames','a','Emp\Ename',multi,constrained) 

There was a space before the Emp\Ename in both places.
Removing it should parse the condition.

Cheers

---

haider (BOB member since 2005-07-18)

[system]

Hi haider,

I tried… again the same error…

Thanks,

---

bown (BOB member since 2007-07-10)

[system]

Just a thought
Change the prompt message having Ename/Enames as text to name.
Since Ename is the name of column in Emp table.
Though it shouldnt matter as it is enclosed in quotes but still change that and see

---

haider (BOB member since 2005-07-18)

[system]

Hi haider,

thanks for ur fast reply…

again the same error…

Regards,
Kumaresh Gopalsamy

---

bown (BOB member since 2007-07-10)

[system]

Do one thing which I also follow when the expression is little long.
Recreate the formula again.
Try to parse with only first part without or.
Leave the LOV object blank.
Then gradually add other part after or. Go step by step

---

haider (BOB member since 2005-07-18)

[system]

Hai Haider,

Thanks for your valuable idea. I traced part by part … now it is working …

This is my where clause query…

SCOTT.EMP.ENAME IN @Prompt('choose a name ',‘A’,‘Scott Emp\Ename’,multi,constrained) OR ‘ALL’ IN @Prompt(‘name’,‘A’,‘Scott Emp\Ename’,multi,constrained)

And also i thank all those guided me from the beginning…

"Knowledge is power "

Regards,
Kumaresh Gopalsamy

---

bown (BOB member since 2007-07-10)