Skip to Content
Former Member
Aug 17, 2005 at 08:37 PM

Restrict Query Data based on Date range and Users


Hi All,

I have a few web reports that I need do restrict data based on Users.

In all the queries i have an infoobject 0CALDAY, and a User Entry range variable on it. Because of performance issues I need to restrict the range of dates a User can see. Typically most of users could go to a max date range of 1 month back. But some others would need the ability to see data for much bigger range of dates.

Pls suggest how should i go about with this. Should I have to enforce this at Variable level(user exit).... but then i might have to maintain a table for the users.. Is there any other way of doing it.