Skip to Content
author's profile photo Former Member
Former Member

Can a prompt in webi report be restricted to enter date diff only two days?

Hi All,

I have a date field(dev_date) coming from the universe(ABC)

I have created a webi report based on the above universe(ABC) and created a range prompt based on the dev_date field.

Now user was able to enter the date range happily, however user wants the data to be displayed for only two days.

For example, if the date range is between 10/21/2012 to 10/30/2012, then user wants to display only the date range of 10/28/2012 to 10/30/2012.

Thats means 10/30/2012-2 days, so my question is how to capture the date and how is it possible in webi report or in universe level.

I tried to do it through custom SQL, no luck, however user dont want to use custom function.

Can any one help me...

Thanks in Advance...

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Oct 17, 2012 at 10:09 AM

    Rupa,

    You need to create a 3 different objects at universe level and utilize them in your report.

    1. dev_date(max) = This the maximum of dev_date i.e. 10/30/2012.

    2. dev_date1 = dev_date(max) -1

    2. dev_date2 = dev_date(max) -2

    Regards,

    Mani

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      In case your users provide some date to the prompt you can get that also: -

      maximum_date =If (IsPromptAnswered("Dev_Date"))Then(UserResponse("Dev_Date")) Else......

      You can put another calcaulation or a constant date in Else.

      If you have another conditions make use of "ElseIF"

      Thanks,

      Vivek

  • Posted on Oct 19, 2012 at 09:21 AM

    Hello,

    You can use the user responce function to get the date entered by User.

    If user enters 10/21/2012 to 10/30/2012 then you can read the to date i.e 10/30/2012 and restrict the report to get the data from 10/28/2012 to 10/30/2012.

    You can do it at the universe level or you can restrict the webi report too(restrict the webi report).

    Thanks,

    Vinay

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 07, 2015 at 12:03 PM

    Dear Vivek,

    Could you plz,give more details about how using maximum_date =If (IsPromptAnswered("Dev_Date"))Then(UserResponse("Dev_Date")).

    I as understood this will be after entering the dates from the user,so the query will be running on the Database,isnt't ?

    and dev_date range will be from date to Date(Between)

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.