It really depends on what you're attempting to do with the results. In both cases you could store / process this information, the question is should you?

Business intellegence is about...

What help are you looking for? Have you tried the migration wizard?

The SQL Server migration should be realtively straight forward. For MSAS, there's significant changes and advancements, so plan on...

Try putting the table into another control (like the rectangle) then settign the left to 0 for the outer control and then spacing the table within rectangle.

Yes, it's generally quite straight forward. However, remember that security in MSAS is based either on the dimensional characteritcs or on item data. (As opposed to a hieararchy definition).

You'll first...

I believe you're talking about doing this in MSRS or a similiar tool. As well, you haven't specified any conditions / contstraints on the selections, so I'll guess a little...

Thanks for your post Sam, but no, that's not what this post is all about. (I'm very aware of sorting diemnsion members.)

What thsi involves is sort the SQL statement sent...

Correct. MSRS isn't really "OLAP" aware, but can use / consume OLAP data. Hopefully, the RS team will work more closely with the AS team in the future.

It's a little unclear exactly what you're doing. Consider "Unprocessing" the partition, then processing it full.

If you're trying to update previously process (and assumed complete) partitions, then unprocess those partitions...

I believe access to the dimension properties is dependent on the tool being used. I haven't found that SSMS pulls them up.

The real question, is how you're using / accessing...

Given what your code appears to be doing (looping through the table, 10 Million rows at a time, looking for records to delete), an alterternative approach might help:

• Consider partitioning the...

Given what your code appears to be doing (looping through the table, 10 Million rows at a time, looking for records to delete), an alterternative approach might help:

• Consider partitioning the...

There's a "KeepTogether" property for the matrix (in layout). Check that setting.

Also, make sure you don't have spacing (blank areas) above and below your matrix in the body. It could...

The usage based optimization will only use log entries created from the last time you save the cube. That make sense, since you may have changed the dimensional structure(s), which...

Great points Steve.

Additional: on the relationships mentioned, make sure that your data adheres to these relationships / specifications. For example, if you specify that a city has one and only...

Here goes:

1) Manual partitions. Agreed. The best option is still to go up a version and use partitions. Since you seem to have 400,000 items, that's where you need to...