BEx query data

Hi friends,

I have a query which gives me the data as of yesterday.I want to run this query daily to give me the status as of yesterday.Now my problem is, can i populate the query with data everyday without hitting the database?If so what is the option to be used.kindly help me.

Thanks in advance

Kiran