I am sure if you post more details, folks here will be able to come up with effecient queries. I am alluding ot the structure of your tables.
Also, you mentioned OLAP/SSAS - are you working on a cube, and you are struggling with MDX queries? Again, please post the details of your backend schemas.