Skip to Content

Date Range Input Parameters with future dates - Working Functionality Required

Hi Experts,

we are using webi with BEx Queries, we have the date Range as Input Parameters in some of the reports,

we have the requirement like user don't want and should not allowed to enter the future dates in the Input Prompt date range parameters,

if they enter then Ok/Run Query option should be disabled,  can we achieve this requirement in Webi 4.x?

I tried and noticed in our webi report like  "if Start Date is Greater(2016) and End Date(2013) is lesser then only the Run Query/OK button is disabled, (not referring the date is future date or not)

If we give in date range in the future date (for ex: From Date in 2016 and To Date in 2017) then ok button is enabled and some reports we
can able to run and the output as "No data to retrieve" and for some reports we will receive" internal process command Error" or" bex cube related error" in the output.

we are handled this inputs parameters in the Bex level,how we can able to achieve? this is possible in Webi ? or Bex level?

kindly share your inputs

Regards,

Balaji

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 15, 2015 at 12:27 PM

    Any Experts any to Guide/Help here?

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Amit,

      Thanks for your time,

      It is not like there is no future date allowed in the prompt, just want to disable the Execute option in the Webi level if user trying to enter the future date, we already tried the option (the same shared by swati) , it is working in Bex level,but we are not able to in-corporate the same into Webi

      I will try to apply your suggestions and update the results.

      does your info-provider contain data for future date's as well ? - Ans is "NO"

      Regards,

      Balaji


  • Oct 19, 2015 at 11:54 AM

    Hi Balaji ,

    There is no such option exist to hide /disable the OK button on demand .

    After execution as you know it'll throw processDPCommandsEx .

    We can raise Idea in Idea Place if we think this is a must need feature !!

    Add comment
    10|10000 characters needed characters exceeded