Optional prompt issue-Error: WIS 00027

[system]

Hi, I have created two optional objects in the universe and when i used these objects in the report query and trying to run it i am getting this error:
“Removing skipped prompts from the query will introduce new prompts. This introduces complexities that cannot be supported. (Error: WIS 00027)”

Here are the object definitions in the universe:
Object1->concat(@Prompt(‘Enter either Name:’,‘A’,‘Reporting\LName name’,Mono,Free,not_Persistent,User:0,optional),’%’)

Object2->concat(@Prompt(‘Or enter Number:’,‘A’,‘Reporting\LNumber’,Mono,Free,Not_Persistent,User:0,optional),’%’)

If i create optional prompts in the report they work fine but i need to create these objects in the universe so that whatever user enters it will take that value and add wildcard(%) at the end, so that users no need to enter wildcard in the report prompt.

Please help me in resolving this issue OR let me know if there is any workaround to this.

---

tsr_bo (BOB member since 2008-06-13)

[system]

Even though you can use the same syntax of the optional prompt in a universe defined prompt, it doesn’t parse but also gives the error you described if it is not answered.

I had the exact same issue as you and managed to convince users to type the % themselves, thus report based optional prompt, but then they decided they want me to turn the entered value to upper case which put me back at using universe based ones again but now not optional so I default them to a value of % in case they don’t want to answer.

It’s a real bummer that optional prompt don’t work when created via universe.

---

Nniixx (BOB member since 2009-09-02)

[system]

@Nniixx

It’s a real bummer that optional prompt don’t work when created via universe.

Agreed. Major bummer.

---

CSGDrew (BOB member since 2008-02-12)

[system]

Hi there. Did anyone ever get anywhere with this? I am facing the same error.

I saw the following post though, so I was hoping that there might be a work around now.

How can we define a optional prompt in universe BO XI 3.1?

How can we define a optional prompt in universe? I am using the last versione of BO XI 3.1 (included fix pack 1.2) The syntax should be --> @Select(Batch Type\Batch Type Code) = @Prompt(’Batch Type’,'a’,'Batch Type\Batch Type Code’,mono,constrained,Persistent,{},User:1,Optional) This should be the syntax that Webi uses when I create an optional filter from webi. I tried to use this syntax into the univers designer and it does not work. This is the errore message: Query 1 - RDM - Inventory…

Thanks,

Jen.

---

Jenm1 (BOB member since 2007-07-06)

[system]

Hello Jenm1,
Did you managed to get the solution? I have the same situation for my report now, cracking my head how to solve this as i received the same error (WIS00027) when tried to used this optional @prompt created from the Universe.
Thanks.

---

Didy (BOB member since 2009-05-07)

[system]

Hi Didy,

in the end I had to make do with autopopulating a ‘’ in the prompt that I wanted to be optional- so if the user did not want to use the prompt they keep the '’ and everything is returned, but if they did want to use the prompt then they would remove the star then select what they want from the LOV.

I set it up in the universe like this:
@Prompt(‘Select Item’,‘A’,‘Reporting\LName name’, MULTI,FREE,Persistent,{’*’},)

Hope this might be of help to you.
Jen.

---

Jenm1 (BOB member since 2007-07-06)

[system]

Thanks Jenm1.
But just to confirm if user select a value will this overright *? Because in my case the user wont see the prompt window as user will select an opendoc link with data being passed. So in case the user select that hyperlink with default value = *, but actually passing some parameter, will that work (parameter override *)?

---

Didy (BOB member since 2009-05-07)

[system]

Hi Didy,

Hmm I am not sure if it will work for you then. In my case the user has to actually remove the star from the selection, then choose what they want.

Might just be worth giving it a try and see what happens?

---

Jenm1 (BOB member since 2007-07-06)

[system]

Finally, I got the solution for this. I am able to create optional prompts in the Universe.

Here is the syntax …

to_date(CASE WHEN @Prompt(‘Enter Date:’,‘A’,‘T Date Dim Dat\Day Date Dt’,mono,free,Not_Persistent,{’ ‘},optional) = ‘’ THEN to_char(SYSDATE,‘dd/mm/yyyy’)
ELSE @Prompt(‘Enter Date:’,‘A’,‘T Date Dim Dat\Day Date Dt’,mono,free,Not_Persistent,{’ '},optional)
END)

It’s working…

Thanks,
Vijayakrishna

---

vijayakrishna.bos (BOB member since 2007-08-29)

[system]

Hi Vijayakrishna,

i try your code and it doesn’t work (oracle database)

Cheers

JM

---

mich7 (BOB member since 2007-07-19)

[system]

Hi vijayakrishna.bos,

I cant understand what’s the usage or the purpose of this code. I think that you try to give a constant value to your prompt cause you don’t want your prompt to be null. But i need no value. I just want to be optional, that means that if i don’t give a value to my prompt, the prompt is gone.

Am i right? Thanx anyway.

I think that the optional prompt in universe is an unsolved problem.

---

Ernest_Everhard (BOB member since 2013-08-29)

[system]

The purpose of the above code is, If user does not enter any date then it will take Sysdate as date value. Otherwise query will ignore the date prompt.

Thanks,
Vijay

---

vijayakrishna.bos (BOB member since 2007-08-29)