You could also do exactly what was said, add parameters for the columns they can enable or disable and toggle the visibility of the columns with the parameters.

Even a bit...

When SSIS determines the data types from your spreadsheet (barring having true data types in the worksheet) it samples the data. It does a pretty poor job of this....

You do not "have" to, but I would recommend it. There are some significant improvements over RTM and sp1.

You are on 64 bit, so don't worry about AWE.

By default, SQL server will dynamically allocate memory. This is configurable to a window of dynamic memory (set a min...

Actually, the DT_DBTIMESTAMP in SSIS really is DATETIME in SQL Server, not TIMESTAMP. MS has been wonderfully consistent here.

This is a good place to start though as the data...

Excel and Proclarity both use PTS (Pivot Table Services) for access to the AS cube. I would suggest you download the OLAP PivotTable Extensions add-in for Excel:

http://www.codeplex.com/OlapPivotTableExtend

This will allow...

DBCC INPUTBUFFER

At http://www.sqlis.com/23.aspx there is a file watcher task that will do the same thing with a bit less confusion.

Watch out for this task and the use of the WMI event...

The Users in a database and the Logins at a server level are mapped together by SID, not by user name. So, if you restore a user database onto...

As far as performance, I do not think you will see a significant difference if both are written correctly. I would recommend you test both ways.

I also agree that...

I tend to put cascading deletes into the same bucket as deferred constraints (in Oracle), the NOLOCK query hint, and most triggers. They are there to be used in...

If it is a specific client number, I would add a trigger that errors on delete of that client number and wait for an application to error - or if...

It sounds to me like you just need a "Rating" dimension.

Yes, you can create stored procedures in Analysis Services:

http://msdn.microsoft.com/en-us/library/ms176113.aspx

No, you cannot "trigger" them based on data changes. If your cube is real-time, you will need to do something on...

Analysis Services can get complicated, I would suggest you get a book or take a class.

As for your questions, you can have multiple facts tables in a single cube. ...