Hi Vincent,

I did a migration in the last months, too.

Very good is the decision to keeo the dts packages running as they are in SQL 2005 and migrate...

Hi FP,

AMO (Analysis Management Object) is the new object model in SSAS 2005.

Check this for introduction and google for examples.

http://asptoday.com/Content.aspx?id=2351 

Best regards,

Stefan

Hi James,

of course I meant that you have to use TAB when exporting the data from your source system. It makes no sense to use comma as column seperator...

Hi,

first of all - use TAB as seperator in flat files, most systems do not allow TABs in data fields, thus this causes not as much problems as comma....

Hi,

the way I usually do this is to do a lookup for the PK of the target table saving the value of an ID (autoincrement value). Then I do...

Hi Matt,

you need a customer dimension and a facttable (your transaction table). The customer dimension you could build by using customer data from your legacy system or you can...

Hi Prakash,

I made the same experiences tho months ago.

Try to reorg/recreate your indexes and your stored procedures.

Did you change the compatibility level of your database to 90...

Hi,

good idea. What would you use?

I heard from a tool called SQLIO. Any experiences, other ideas?

Best regards,

Stefan

Hi,

the server has 16 GByte RAM, 6,5 GByte is used for SQL Server DBMS. The rest is used for other components we use. (SSAS, SSRS, IIS) Do you think...

The time needed for the Full Backup on the new system is 6 hours compared to 2 hours on the old system.

I tried to do a differential backup the...

Hi Steve,

the attribute relationships are set up correctly, the aggregations design worked the last time and they are build every day. I read the sources. I tried some other...

Hi Antonela,

it works but what about security? Do you want to allow anyone to see the data in the cubes? Don't you have different groups of users with different...

Hi,

my advice - forget the migration wizard and build up your cubes from scratch. I did a big migration of a datawarehouse (20 Cubes, 30 dimensions) this year and...

Hi antonela,

Analysis Services needs Windows Authentification to work. When accessing cubes with excel basic authentification is used. This means that simply the user and the password of the current...

Hi data,

as I understand you use an OLTP DB as data source for your cube. You imported the mentioned tables to your Data Source View. Now you want to create a...