We have a SSAS 2005 Cube already created for Sales Executives. As of now, I
can see reports for all of them as an admin. I would like to restrict reports
viewed by a Sharepoint (MOSS 2007) user. Basically I would like to show a
Sales Executive, reports that they are supposed to see. I believe there are
many experts over here who can help me out.

What are the technologies involved? Any links or links to documents that I
can follow to achieve this task will be well appreciated.