October 20, 2007 at 8:59 pm
Our OLAP system is currently based on SQL Server 2000 and Analysis Server 2000 and working fine.
We are considering to migrating the system to SQL Server 2005 and Analysis Server 2005.
RDBMS part is already done, we are stuck with Cube migration.
We will really appreciate if someone can suggest some contact point which can be helpful in this
regards.
Thanks and Best Regards,
October 22, 2007 at 5:37 am
The cube migration is a bit ugly. Since the structural differences in how you "should" build a cube in AS2005 is so different, even when the migration wizard works, you get something that is nearly unusable.
On the other hand, if you intend to keep your data mart as-is and it is pretty close to a classic star schema, building a new cube structure should not take you long.
If you have not worked with AS2005, get a book or take a class right away. It is not the same product as AS2000. They look alike on the outside, but you have some design consideration to do now that really does not translate. If you disregard this advice, at least look at the sections of books online about multiple fact tables in a single cube (if you use virtual cubes you will want to look at this) as well as the attribute hierarchy section (many AS2000 users mess up this piece in AS2005).
October 23, 2007 at 6:18 am
I would recommend build a new cube from scratch for several reasons.
When we tried migrating, there were quite a few things that we had to fix as they did not migrate right.
You will need to be there anyways to take advantage of the new architecture. There were many things that we considered fixes.
You likely can take advantage of 1 cube and manage perspectives. Yes the model can get very large, but it is one place to maintain the relationships.
Finding a one week course would probably be a good way to get familiar with some of the new concepts.
Greg E
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply