Ubiq also supports user level dashboard and dynamic filters, to help you filter data for each user. In your SQL queries, enter the string [user_email] to substitute your user's email id in query during run time. For example,


select * from sales_data
WHERE manager='[user_email]'
GROUP BY manager

If your user's ubiq account's email id is steve@apple.com then the query will become during run time,


select * from sales_data
WHERE manager='steve@apple.com'
GROUP BY manager  

Now when the user steve@apple.com logs in to view his dashboard/reports, then they will be populated with only his data