I came across this freebie from Microsoft a while back--  Microsoft Business Intelligence Portal. 

http://www.microsoft.com/downloads/details.aspx?FamilyID=154d2d31-ac55-4595-866f-267606f94f88&displaylang=en

I got it up and running quickly, but we haven't had the need to pursue it...

Chris is on the money on the permissions issues.  The first question that comes to mind is "WHY?".  I'm guessing that you do not have enough disk space on the box. ...

Believe it or not, we use Excel.  Later versions of Excel have built-in OLAP connectivity, which works remarkably well.  It automatically builds pivot tables with drag n' drop dimensions and...