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

[Former Member]

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...

[former_member182521 · Accepted solution]

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

[Former Member · Accepted solution]

Hi,

What you said is correct but my maximum date can be anything from the database, I am not suppose to hard code and the user can enter any value from the database in the webi report.

If i have my max date in the database is 12/31/2012  but if user want to enter only 10/30/2012, how can it be the maximum date. once user enters it the data should be from 10/28/2012 to 10/30/2012.

Thank you,

Saritha

[Former Member · Accepted solution]

Can any one please help me....

[Former Member · Accepted solution]

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

[Former Member]

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)

[vinay_lohakare5]

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

[Former Member]

Hi Vinay,

Thanks for your response.

My requirement is not to restrict the data in between 10/28/2012 to 10/30/2012, however want the data in between.

The user may or may not have the dates of 10/29/2012, if he have he should get both 29 and 30 else he should get only 10/30/2012. that means the user have to get two previous dates from the database.

Thank you,

Rupa.

[vinay_lohakare5]

Hello Rupa,

By using the user responce you can get the date 10/30/2012(user input to date).

Store it a variable; say VAR1

From above date you can get the date -1 i.e 10/29/2012 using the relative date function in WEBi.

Store it in variable; say VAR2

Now you have From (10/29/2012) and To Date (10/30/2012).

You can restrict the WEBi report to get the data for the 2 dates only.

Even if user enters From:10/20/2012 To:10/30/2012 he will always get the data for 10/30/2012 and 10/29/2012. also if user enters From:11/1/2012 To: 11/10/2012 he will get the data for 11/9/2012 and 11/10/2012; as you have restrict the report to show the data for only the From date entered by

the user and date -1 i.e VAR1 and VAR2.

I hope i am clear.

Thanks,

Vinay

[former_member188911]

for the sake of spelling it is UserResponse not UserResponce in case anybody is trying the latter