Date Range Input Parameters with future dates - Working Functionality Required
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