Date Prompt

[Former Member]

Hi
I have to create a Date prompt like this:

Whatever user selects , I need data for next 5 working days (excluding saturday , Sundays)
If He selects some Monday date ,data should be Tuesday ,Wed,Thursday, Friday, Next Monday(Saturday , Sunday excluded)

If He selects Tuesday date , I need Data for Wed , Thr , Friday , Next Mon , Next Tues


and so on...
Any suggestions ??

[Former Member · Accepted solution]

Hello Saurav,

You can try this: Add the 0WEEKDAY1 characteristic to your query. That will turn the numbers of days of  weeks. For Monday it returns 1 , for tuesday it returns 2 etc.

Filter out the query results for that characteristic for the values "6,7". This way you will never get saturdays and sundays.

Create a measure like it "= Count(0WEEKDAY1; ALL) " ,and after use that in report filter as:

"= Count(0WEEKDAY1; ALL)  equal 6"

And finally a prompt for the users to select the day. Make a prompt like:  "0calday greater or equal the date selected"

Hope that works.

Regards,

Onur

[Former Member · Accepted solution]

Hi Onur

Thanks for the response

Could you please elaborate on what to do .....I am not able to implement by the way you explaines

[Former Member · Accepted solution]

Hi Saurav,

Sure i will try to explain more clear. First you should add the "0weekday1" characteristic to your data source. You said it was bo universe, so assuming you made the universe from a bex query or an infocube; just add that characteristic to your infocube at BW side.

Now at your webi report, create a measure variable. You can use "= Count(0WEEKDAY1; ALL) " for the formula and let the name be "Filter1". That measure will count all days in report if you leave it like that but we will use it to make sure that the date stays between 1 week range. Like if you start monday, it shouldn't pass  next monday.

After that, edit your webi query which includes that data source, and make 2 filters and 1 prompt like this:

1.filter=   "[Filter1]  equal 6"

So that one will count 6 days and will ensure that the date is in desired range.

Like: Monday Tuesday Wednesday Thursday Friday Monday

                1         2              3             4          5          6             

2.filter =   0WEEKDAY1 not in list       6;7

so saturdays and sundays will be filtered out.

Prompt= [Your prompt date dimension] greater or equal

You can use 0calday here or the one which you use to prompt.

So basically you will prompt users, they will select a day; and the query should return 6 days greater or equal from that day where saturday and sunday are excluded.

Hope i could help.

Regards,

Onur

[Former Member]

Hi Saurav,

Why don't you use two query filters on the same date object:

one to prompt user to select a range of date with operator "between" that encludes the 5 days to display

and the other prompt with operator "not in list" to exclude Saturday and Sunday

Thanks and Regards,

Rabeb

[Former Member]

HI Sourav,

Could you please elaborate your requirement..

Regards

Subbarao M

[Former Member]

There will be a date prompt.

User select a DATE ,based on users selection i need to show data for next 5 working days (Excluding selected date , Saturday, Sunday)

Like:

1)If user selects 20th Jan 2013 , I need to show data for 21,22,23,24,27 Jan 2013

2) If User Selects 21th Jan 2013 , I need to show data for 22,23,24,27, 28 Jan 2013

and so on for all selection . I need data for next 5 working days in which saturday and sundays are not counted

Thanks

[Former Member]

Hi Saurav,

What is your data source? Is your report on top of Universe or Bics?

Regards

Sunil

[Former Member]

Its on BO Universe