I may have missed a reply here but it sounds like the only discussion is around the use of Surrogate Keys in transactional models, which as someone that cares about...

It's actually more work...

Would this work if the SQL Database Engine was not installed on the same box as SSIS? To my knowledge SSIS packages can only be called locally and in a...

The workaround suggested by MS can be found here - http://blogs.msdn.com/sqldev/archive/2008/10/22/msjet-4-0-in-64-bit-environment.aspx

It's not elegant at all but will work. I don't know of any issue installing the Oracle client...

With the RB2.0 you do not need report models any longer. Create your reports using queries directly from your cube similar to BIDS.

Are you on 2005 SP2 or 3? If so I would recommend using the Report Builder 2.0 and scraping those Report Models...

Yes you will need the MOSS front end on your SSRS box. Also, when installing the SSRS 2008 add-in you might run into an issue that requires a command line...

Use Jaspers tool to reverse engineer the reports and have it create the solution file for you...

http://sqldbatips.com/showarticle.asp?ID=62

I've experienced this before. In my situation I took the calls being shown in the Profiler trace and ran them manually. What I found was that there was an error...

You have two options

1. Go to the properties of the report and click 'Edit' then save the RDL file. Open visual studio, create a new Report Server project and add...

Is it running? Try logging in with the service account it's running under...

Yep, be careful on that though, in my experience the OLEDB source object doesn't play well with parameters in sub queries.

Here's what I suggest. My understanding of your requirements might be slightly off but here goes -

1. Include all the measures in one large fact table

2. Create perspectives...

Are you unable to use the 'Parameters' option in the OLEDB Reader source component? Alternatively, you may use an 'Execute SQL Task' and send the results to a record set...

I would recommend never building a cube, or almost* any reporting solution on top of your live OLTP database. You will need, at the very least, to create an Operational...