Default value in @prompt

building semantic layer
1

I am working with BOXI and creating reports in Infoview. I need to put a self join in my universe prompting for a date, and I need to assign a default value to it.

It works if my default value is hard coded.

(fact_service.billing_change_date = @Prompt('Billing Change From Date','d',,mono,free,Not_Persistent,{'01/01/1900'},User:6,)

I need to change my default value to pick from an Object in the universe instead. Say Measures/Object1. This value has a max(date) as the SQL derivation and hence when it is used stand-alone, it will return only a single value.

I tried giving the following, but it does not work

(fact_service.billing_change_date = @Prompt('Billing Change From Date','d',,mono,free,Not_Persistent,{'Measures/Object1'},User:6,)

nithya_raj (BOB member since 2007-02-03)

2

I do like :
@prompt(‘Enter value(s) for Year:’,‘A’,‘Time period\Year’,Multi,Free,Persistent,{‘Measure\MaxYr’},User:0)

is ok!

lu_huayong (BOB member since 2006-06-11)

3

Thanks lu_huayong for that! But the problem now is it is displaying Measure\MaxYr as a text itself as the default value and not the value corresponding to it! :slight_smile:

nithya_raj (BOB member since 2007-02-03)

4

At this time you cannot provide a variable value as a default for a prompt. You can provide a variable value for a default for a condition, but not a prompt. There have been many topics on this very question over the past two weeks, including this fairly long one:

Default value in @prompt (Date) - BOXIR2

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

5

Thanks Dave. That helped!

nithya_raj (BOB member since 2007-02-03)