Date Prompt Validation

[Former Member]

Hello,

I am working on webi 4.0. I need help

I am using date as a prompt that is between start date and end date. when user selects end date less than start date need to display a message box that date is not valid instead of running and wasting user time.

Please help me

thank you

[saurabh_sonawane]

Hi

try this work around condition

after selection of prompt by user we can check that end date is greater or not if it is less than start date then we can display one BIG MESSAGE to then that

message = "PLEASE select the END date greater than START DATE"

"CLICK HERE TO DO THE SELECTION AGAIN."

steps to do this

1st create a BLANK cell

2nd write a message in that blank cell.("PLEASE select the END date greater than START DATE")

3rd right click on the blank cell.

4th In general tab there is HIDE WHEN FOLLOWING FORMULA TRUE

write formula this formula

UserResponse("START DATE ") < UserResponse("END DATE")

STEPS TO REFRESH THE WEBI AND AGAIN for selection of PROMPT.

5th create a another blank variable

6th  right click on that blank cell

7th select the LINKING -> ADD hyperlink

8th past the DOCUMENT LINK THERE and press PARSE

9th the target window showed be current window

after this edit the formula

"<a href=\"http://server/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=M1OC7FYACK2AAREAsAAAWWID...\" title=\"\" target=\"_parent\" nav=\"web\">CLICK HERE TO REFESH THE WEBI AGAIN</a>"

final output

as

[Former Member]

Hi Saurabh,

Thank you so much for the reply.... I willl try it and..... Is there any way while selecting at query level only that not to take if end is not valid, because the user dont want to wait.... (my report is taking long time to give the result) so if the date is not valid it should display immediately

Thank you in advance

[saurabh_sonawane]

NO there is NO way

[Former Member]

okay Saurabh

thanks... I will try as u said... And I have one more question

I am taking ReadDateTime(Date+time) on x axis Line chart, so on X-Axis the ReadDateTime is Secondwise(Ex 10/9/2013 12.00.01, 10/9/2013 12.00.03..... etc)

I need to see on graph as 5 minutes wise(how to round up this date key on xaxis) and if i take for 10 days the graph is going out of pages so how to  adjust X-axis automatic to set to graph/page... So if user export to PDF or other he/she can see in one page..

Please help me

Thank you

[saurabh_sonawane]

Hi

your problem had solve or not???

[Former Member]

Hello Saurabh,

It didnt solve but we r restricting user to select from calender. And we r taking 1 minute band on Xaxis. 

Thanks

[Former Member]

Hi Rajitha,

I think you are concatenating Date+time to display as ReadDateTime() right?

Do you have [Time] as separate dimension?

you can format or truncate to get only till HH:MM

Then concatenate Date+Time and use it on x-axis and manage the scaling form chart/Graph properties

[Former Member]

It isn't possible. Perhaps clearer labelling of the prompts is needed or making them display start date first and end date second?