Not sure if it's covered off int he Market Basket Analysis info but you could try an alternate Distinct Count (e.g. as a calc measure) that may provide the outcome...

It's been a while since looking at AS2K, so best use a test environment to check this but...

I think the datadirectory is a property of the server (either through right...

Are you using Perspectives, and if so, did you 'lock down' the visibility within these?

Are you able to query just that attribute through a hand written MDX query in SQL...

Can you post the MDX that you're using to generate the dataset?

Seriously, is it that hard for you to google (or dare i say it, use Live Search) the Msft site for this info?  Even going straight to Microsoft.com has the...

Is it the *build* thats taking 45min + or the *query* times?

If it's the query time(s), then see if you can log the mdx (in most cases with AS2K this...

The guides arent in BOL but are viewable on the msft site -> performance and Operations.

I'm not sure why you'd want (need) to create indexes on your columns...

I know it's a pain but I would be temtped to run profiler (or tool of choice) when processing to try and catch the exact cuplrits (holder of the lock...

If you have the correct edition of AS, ensure that the data is partitioned, then you could load the partitions in parallel.

Depending on your data sizing, 5 years in 45...

Start at the source....  http://support.microsoft.com/gp/cp_dst 

One thing that jumps at me out of that is the change from encrypting with the user key.  If the info is/was encrypted with a user key but then a...

Have you got processing logging turned on on the AS server?  Possibly it may give you a little more detail than what DTS is capturing.  Have you also checked the...

Something yet nothing

Because the document is XML it refers to a namespace (which can be used by the app [Analysis Services] to ensure...

Note also that SSIS has quite good suport for reprocessing AS objects too. 

reference is not quite true - doesn't this refer to how you want...

It's been a while bu tthe way I read the error message is that the dimension Client Code of the cube (ARM_Comm....) has no source data.  Have you tried manually...