How to display content of query filter in WEBI Report
I have one Query Filter in the WEBI reports. The prompt appears for the user, but when no date is entered, I have added a query to select a default start & end date.
Now I need to display those dates in the Report.
I tried using UserResponse() but as the User has not entered any dates it doesn't give any output.
Any help is appreciated.
Please see the snapshot attached
Amit Kumar replied
As per my understanding this is the easiest solution to display User entered date or static date in the webi without creating additional objects in the universe.
I don't think so you can do by webi pre-defined functions.You can get the values by ReportFilterSummary() but again there you need to remove all text with the help of replace function.
If you need to display either user entered date or static dates in the single cell then you can use below steps.
V Start date=userresponse("Start date")
V End date=userresponse("End date")
=If(isnull(V Start date)) then [Start Date] + "To" + [End Date] else [V Start Date] + "To" + [V End Date]