A different query per login account?

If I create a dash app, using api from a database (tm1 cognos). Is it possible, using the auth user, to define a different query of the database per user login ?

I mean, each user can have access to the same page layout, however the charts will have different datas per user.