10 Replies Latest reply: Jul 3, 2015 9:38 AM by babji m RSS

@Prompt function at Universe

Currently Being Moderated

Dear Experts...

 

I need to know how exactly @prompt function works for the filter purpose at universe level. I need different scenarios wherein @prompt fuction is used.

 

Thanks in advance.

  • Re: @Prompt function at Universe
    Pramod Kumar
    Currently Being Moderated

    Hi,

     

    @Prompts are useful when you want to force a restriction in the inferred SQL

    but do not want to preset the value of the condition. But the syntax will allows you to preset  the the values .

    Following is the syntax for the function.

    @Prompt('message','type',[lov],Mono|Multi,free|constrained|primary_key,persistent|not_persistent,[default_values])

     

     

    The following are simple examples of @Prompt syntax.

    Minimal use of the @Prompt function:

    @Prompt('Displayed text ','A',,,)

     

    Using the @Prompt with a LOV without default values:

    @Prompt('Displayed text ','A',{'Paris','London','Madrid'},,)

     

    Using the @Prompt with a LOV and one default value:

    @Prompt('Displayed text ','A',{'Paris','London','Madrid'},,,,{'Paris'})

     

    Just  go through the universe designer pdf from page#523 in the following link

    http://help.sap.com/businessobject/product_guides/boexir31SP3/en/xi31_sp3_designer_en.pdf

     

    Thanks,

    Pramod.

  • Re: @Prompt function at Universe
    Sravan Sabbineni
    Currently Being Moderated

    Hi,

     

    In BO there is a function called as @PROMPT to create Dynamic Filter.

     

    Type the below parameters for @Prompt(1,2,3,4,5)

     

    1 = 'Prompt Text Message'

     

    2 = 'Prompt Type'  (i.e. A,N,D,U)

    where A= Character, N= Number, D= Date, U= Unit.

     

    3 = 'Class Name/ Object Name'

     

    4 = 'Multi/ Mono'

    Multi means Multiple ( Example = 2004,2005,2011)

    Mono means Single ( Example = 2012)

     

    5 = Free/Constrain (Type value or select value in LOV/ Select Value)

     

    Example for creating a @prompt filter is below

     

    @Prompt('enter year','A','time period/year', Multi', Free)

     

    Hope it helps.

     

    Regards,

    Sravan.

  • Re: @Prompt function at Universe
    Currently Being Moderated

    @prompt function is used to prompt user for a value will be used during report run. For example if you want to run a monthly report against a specific month, you have to prompt the user to enter the Month or even select it from the list of value displayed.

     

    Syntax:

    @prompt ('prompt text ', 'type ', 'list of values', 'mono/multi', 'free/constrained')

Actions