Dashboard not returning any data

SUGGESTED

Hello,

I have an issue where I created a query that returns the data as I want it to return it.

When I link the query and create a gadget and then place it into the dashboard, it returns no data.

I worked it out as why. There is a custom filed created in the AUTILIS table, it stores the default site.

My view pulls the data based upon the site as well.

Idea is that I link the global variable GUSER to the AUTILIS table using following link  [F:AUS]USR=GUSER

This works great in the query itself but when dashboard is refreshed, it returns no data, as soon as I remove this selection, it work fine but it does not do any filtering on data based upon the current user logged in.

Anyone had similar issues?

Thanks

Ranko