Re use SQL queries in AX2009

Hi,
I create sql views on sql server to read AX 2009 data from excel.
What is the easiest way to re use theses queries into AX ? Is it possible to copy and paste queries into AOT
to create reports ?
Thanks