An assembly is written in .Net, so any .Net language would apply. MDX is the "data access language" (much like SQL).

Cases for an assembly vary, and it's still an emerging...

No need to go the DTSX route (nor is it advisable).

Simply change the threads on your process job to 1, and they'll process one at a time. (Then, you can...

Most likely, you didn't set the connection for the task.

You shouldn't be seeing a different performance profile running it via the designer vs running it in batch, so there's something fundamentally different between the two senarios:

- How many threads...

First, you need to understand that "Actions" are simply "meta concept" in a MSAS cube. There's no "engine" ready and able to execute the action. In a way, it's only...

[CandidateInfo].[DaysToScreening] can't have ".Children". It's an attribute, not a member.

NB. Two things:

Take the quotes off the expression definition. You'll then get inline syntax checking from most of he tools.

Don't know...

I doubt the asnwer has much to do with the relative mathematical speeds, and more to do with the overall I/O, Network, etc.

In general, I'd expect that overall it would...

To help you with the diagnosis, I suggest you post the following information:

The following counts:

- records per dimension

- attributes per dimension

- records in the fact table (or records per partition)

As...

There's a number of third party design tools which'll reverse engineer your database into a data model and help you start organizing and documenting the design. The problem space is...

I'll have to concur with the previous comment that 20 dimensions are "alot". I'd go as far as saying it's huge.

Examine your dimensions, and determine if any of them are...

Sounds like you're having a problem with your cube design.

Check the Dimension Usage tab. Make sure that the cube has your time reference.

Ok, based on that information, that's a hefty cube. 10 Million rows isn a dimension isn't a trivial dimension, plus with 10 dimensions, the calculation space is huge. How many...

It's hard to tell from your post, exactly what you're trying to accomplish. However, some general guidelines:

a) you need to carefully evaluate the data you're loading into the cube and...

Check the throughput on your database. In general, is you're not approaching 100% CPU utilization on your MSAS box, you probabaly can do better. Plus, better to separate your MSAS...

First, yes do the upgrade. There's important fixes in SP2.

Second. You don't mention how big your cubs are. Also, what does your partition and aggregation design look like? (How many...