title: Web front-end for SQL Server data warehouse
body: <p>Need a easy to set-up and flexible web front-end for a data warehouse built in SQL Server 2008. I'd like to be able to expose both SSRS reports and SSAS cubes for browsing.  </p>
  
  <p>Seems like Microsoft wants us all to use Sharepoint for this, but I want something I can expose to internal users as well as customers, so I don't think Sharepoint will work (right?).   </p>
  
  <p>The other big approach people take seems to be coding up a custom ASP.NET app, which I have no desire to do.</p>
  
  <p>Basically just want something like Cognos or Business Objects, but as a front end to SSRS and SSAS, not some proprietary data structure.</p>
  
  <p>Why is this so hard to find - seems like it would be a common need. Why doesn't Microsoft make this?</p>
  
  <p>Only one I've found so far is Report Portal (www.reportportal.com), which seems pretty good, but not stellar.  As far as the big guys go, it looks like MicroStrategy (microstrategy.com) can work with native SSAS cubes, but for general reporting has it's own structures.  Graphs and interface look good though, so would appreciate hearing from anyone with experience integrating Microstrategy and SQL Server as well.</p>
  
  <p>Thanks!</p>