Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to display content of query filter in WEBI Report

Hi All,

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

Many Thanks,

Shrutika

replied

Hi,

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.

Start Date=RelativeDate(RelativeDate(CurrentDate();-DayNumberOfMonth(CurrentDate()));1)


End Date=RelativeDate(CurrentDate();-1)


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]


Amit



0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question