Skip to Content
Author's profile photo Former Member

How to use new Dynamic Default Value for Universe (UNX) Prompts feature

First of all, I want to thank SAP team for listening to its customers and making possible the so long-awaited feature of Dynamic Default Values for Universe Prompts.

I’ve just tested it from SAP Business Intelligence 4.1 SP6 and let me tell you, this new feature works like a charm.

Let´s see how it works.

1. Suppose you have a report with the following query and you want it to automatically bring yesterday’s date as first parameter and tomorrow’s date as last parameter:


You could transform the date values in standard prompts but you’ll have to type the dates manually.

Or you could transform them in the new dynamic prompts.

2. To achieve this, open Information Design Tool, open your universe and go to Parameters options.

Create the following parameters: MyStartDate and MyEndDate


2.1 Configure MyStartDate:


As you can see we have a formula like CurrentDate()-1 in Default Values area.  We were able to insert this formula because when you press the button

ScreenShot003.jpg a new Formula Editor window is displayed. This Formula Editor comes with a wide range of predefined functions that certainly will help you save a lot of time creating formulas.


Press Ok. Then, uncheck “Keep Last values” checkbox, because we don’t want the same static value every single time, we want it to change when we refresh our report.


Apply following settings to the other parameter


Create your formula with the formula editor and uncheck this option:


5.Save and publish universe

6.Open your webi report

7. Select Prompt:


Select following option to configure our first prompt:


Select “Parameter from universe” option, then choose “MyStartDate”.



8. Repeat step 7 for the second prompt, just that you have to choose “MyEndDate”.


Then our query will look like this:


10. Execute. You will see that by default Parameter 1 brings yesterday, and Parameter 2 bring tomorrow’s date, without losing the ability of introducing other dates if you want to do that.


11. Save your report.

This is it. Now you are ready to Schedule your report.

With the right formula you will be able to say goodbye to that boring situation when you have to change the dates manually every single month.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Krishna Reddy
      Krishna Reddy


      May I know which version / patch you are using to create this. We are unable to see 'Formula' option under 'Default Values' to set the default values in IDT.




      Author's profile photo Andreas Sbrzesny
      Andreas Sbrzesny


      it is a new feature in SAP Business Intelligence 4.1 SP6.



      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Yep,  SAP Business Intelligence 4.1 SP6.

      If you can´t upgrade to this version then you could use Dave Rathbun's workaround to generate dynamic prompts


      There are others workarounds, too, like creating a table in your database which will contain all possible date ranges like yesterday, last month, last year , etc using SQL date operation sto pre-generate those values daily in your db before 8 am having previously added that table in your universe, of course, and use it to get values, but I think Dave's workaround is the easier one.

      Author's profile photo Neil Mitchell-Goodson
      Neil Mitchell-Goodson
      Author's profile photo Former Member
      Former Member

      Hi Erika,

      nice post.

      However, I've got one question. I use SAP HANA input parameters with an expression. When I create a Universe, these expression (dynamic) input parameters seem to be stored as a Constant Value. How can I use dynamic HANA input parameters in BO with a prompt?

      Author's profile photo Carsten Heim
      Carsten Heim


      I think there is still no dynamic value for HANA input parameters. Promote my idea for this 🙂

      Author's profile photo Former Member
      Former Member

      Hi Erika,

      Thanks for the post, very helpful...

      I have very similar requirement except that user wants to see on the Webi Prompt as below:

      Begin Date: [Date selected though calender]:11:00:00 PM

      End Date: [Date Selected]: 10:59:59 AM

      So, i thought of using RelativeDate(CurrentDatetime();0.4583333333333333) the formula

      results are strange

      I thought the system should CurrenDate (which is lets say 5/4/2016 12:00:00 AM) + 11 Hrs/24

      but CurrentDateTime has varied timing so, never produce 11:00:00 PM.

      Any ideas...while I am playing with it.

      Thanks in advance!

      Author's profile photo Pedro Soares
      Pedro Soares

      Is there any way to use more than the functions on the formula? For instance, your example uses a system function, but what about using external information from somewhere else? Is that possible?

      Author's profile photo Guillaume Benlliure
      Guillaume Benlliure


      Thank you for this post. I know it's quite old, but it seems like it's the only one wich deals with this subject.

      I use this feature a lot, and always for date Data Type. But now, I have a new challenge, and I need to define a multi-value default value for a prompt. Data type is Numeric this time (or String, is the same behaviour).

      I tried to set the formula with a lot of syntax, but without success :

      • "1; 2"
      • "1"; "2"
      • "1, 2"
      • "1", "2"
      • {1 : 2}
      • {"1" : "2"}
      • ...

      Has anyone ever managed to set a multi-value default ?

      Thank you in advance !