After migrating SSAS 2k to 2005

#1

has anyone run into the problem after migrating the olap databases to 2005,
some of the dimension tables relationships are not working anymore? The
migration has changed the data types to system.string.

Any ideas?

frederick · #2

Hi,

I had the same problem sometime ago when I migrated a cube.

To solve the prb I think I changed the dimension tables to named queries (by right clicking the table). And then created new relationships between the tables...

/Frederick

#3

Thanks, that helped. I'm getting this error and not sure why. The data types
are the same.

Property not accessible because 'Parent Columns and Child Columns don't have
type-matching columns.'. (Microsoft Visual Studio)

"frederick" wrote:

Quote:

Hi,

I had the same problem sometime ago when I migrated a cube.

To solve the prb I think I changed the dimension tables to named
queries (by right clicking the table). And then created new
relationships between the tables...

/Frederick

--
frederick

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

After migrating SSAS 2k to 2005

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

After migrating SSAS 2k to 2005 - 08-14-2006 , 02:34 PM

Re: After migrating SSAS 2k to 2005 - 08-16-2006 , 12:49 AM

Re: After migrating SSAS 2k to 2005 - 08-18-2006 , 12:04 PM