BusinessObjects Board

@Prompt Default Value

building semantic layer
#1

I am trying to use a default value say the last closed quarter from my dimension table DIM_PERIOD. I have a flag based on which I had created an object ‘As at Date’ in the universe which stores the last closed Quarter. How can I use this object as my default prompt value. I tried this below but there is no default value getting displayed although the prompt is working fine when I select refresh list in LOV.

@Select(Transaction Period\Quarter End Dt) <= @Prompt(‘As At Date’,‘D’,‘Transaction Period\Quarter End Dt’,Mono,Constrained,Persistent,Transaction Period\As At Date,User:2)

I have tried using @Select(Transaction Period\As At Date) , that too is not working.

Thanks

arindam_bhattach :india: (BOB member since 2006-08-15)

#2

I believe the default value for a prompt must be provided as a constant, and cannot reference another object or table, etc.

See also this FAQ entry.

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

#3

Check Dave’s blog on this subject.

Jansi :india: (BOB member since 2008-05-12)