Sorry for the late response. Hopefully you have't been too held up.

In general, you need to carefully check your referential integrity in your data model. Run SQL scripts to generate...

Leave it as a fact table. You can implement character fields in MSAS. (Different reporting engines may treat the information differently). Some notes:

- to get to the data, the user...

Actually, you don't need to do that. I use this configuration routinely. You seem to have covered all the bases, but I suspect you've missed something small. Here's my checklist:

-...

Ambreen: Are you sure that "General Ledger Transaction" should be a "dimension" (as opposed to a data table)? If you can post your data model, I may be able to...

Ok, some additional:

Running a cube with 500 million rows on a single core (or data base for that matter) is fairly aggressive or you don't mind the wait. Running it...

Ok, first, you have to understand that an incremental load may or may not be a potential solution. Incremental loads typicaly only work when you have very slowly changing dimensions....

Actually you should just check your format statement. Use "#0" instead of "#" and "£#0.00".

Yes, you're probably stuck creating a separate report. You don't say what your data source is or how the data is formatted, but here's another idea:

Instead of pulling all that...

Actually, in SQL 2000 you could store DTS packages to files as well, but I digress.

With Stored Procedures, you're working with Transact SQL statements. It has all of the capabilities...

Basically, you have to understand the which process is running the SSIS package (which machine) and is the authentication set up correctly. If you've installed SQL Server locally on your...

The previous response actually brings up the topic that wasn't mentioned:

The real question is when do you want the email generated? When the cube is processed (as in the previous...

Backup your cube (just in case) and try doing a fresh deployment.

P.S. What service pack are you on? I remember some old bugs with some early versions, but that's...

Just for the record, I'd note that the RS SQL Statement had the index hint, while the MS SQL Statement did not.

sp_executesql generates a query plan "more likely to be...

You're right, that may be the error / problem they caused:

When you "tell" MSAS (via the dimension definition) that there is a strict hierachy (i.e. date rolls up to week,...

I'd concentrate on controling either the visibility of the rows (cells) or trying to filter the data (less likely to work).

NB. If you're still stuck, post a sample. Perhaps there's...