prompt problems

building semantic layer
1

trying to get a prompt to work so that when user selects a dimension object they are prompted to select only one of the items from that dimension

prompt parses ok, but when try to use it in webi it produces a cannot connect to server message,

i tried recreating it in islands universe on a separate BO install and am getting the same result

code is

selecting resort_country.country

and have put this prompt in the where section

resort_country.country = @prompt(‘select country’,‘A’,‘Resort\Country’,‘MONO’,‘CONSTRAINED’)

am i doing something wrong or is it not possible to put a restriction on values from a dimension in this way?

johnwxyz (BOB member since 2008-01-26)

2

Use below code.

resort_country.country = @prompt('select country','A','Resort\Country',MONO,CONSTRAINED)

Rakesh_K :india: (BOB member since 2007-12-11)

3

still get the web intelligence report panel cannot connect to server message

johnwxyz (BOB member since 2008-01-26)

4

You appear to be providing a prompt for an object in the where clause, and then referencing the same object in the LOV. That is not going to work. You can’t show values for the LOV without the prompt, and you can’t pick from the prompt without getting a prompt… it’s an infinite loop.

In order to do this you need two objects. One will have the where clause, and the other will not. The LOV reference in the prompt will point to the version without the where clause.

Dave Rathbun :us: (BOB member since 2002-06-06)

5

works great, thanks

johnwxyz (BOB member since 2008-01-26)