Default Derived prompt value in Webi

building reports webintelligence
1

Hi,

Env:BOXi R2 and oracle.

We have a Field “Fiscal Periodweek” with value format FY2007P12W05 used as a prompt in the universe(@prompt).
The requirement is to have the current Fiscal value as a default value as a prompt in the @prompt function.We have derived the current fiscal value in the universe and is readilly avialible to use but unable to get the desired default to come up when the report is prompted.

in the @prompt we either get a blank default or the full text of the object we have given in

@prompt('User text','A','Databasefield',mono,free,{derived default object})

Thanks in Advance.

sasi70 (BOB member since 2007-01-10)

2

I had raised this earlier and dont think it is possible. :expressionless:
You could check this thread.
https://bobj-board.org/t/89961

nithya_raj (BOB member since 2007-02-03)

3

Thanks .

sasi70 (BOB member since 2007-01-10)

4

You can’t do it “directly” but couldn’t you set the default to CURRENTPERIOD and then code it…

PERIOD = CASE WHEN @Prompt('Select Period','A',MONO,FREE,'list of values',{'CURRENTPERIOD'},user:0) = 'CURRENTPERIOD' THEN (select current_period from somewhere) ELSE CASE WHEN @Prompt('Select Period','A',MONO,FREE,'list of values',{'CURRENTPERIOD'},user:0) END

charliebrown :us: (BOB member since 2002-09-03)