Deserialization Failed - Microsoft Analysis Service

---

Hi Everyone,

I'm using Microsoft Analysis Service-2005. When I'm trying to open the database which contains 4 cubes and 10 dimensions, I'm getting the following error.

Deserialization Failed - Property not accessible because 'Parent columns
and Child columns don't have type -matching columns'.(Microsoft Analysis Service)

The system is not allowing me to open the cube so I'm unable to fix the issue.

All your suggestions would be highly appreciated.

Thanks,

Selva

Hello. Have you successfully built a parent-child dimension in BIDS that is processed and browsable? Both the parent column and the child-column have the same data types?

If this is the case you have either a problem with the join between the parent-child table and the fact table in the data source view or the join in the dimension usages tab in the cube editor.

Have you made a collection of the parent key(more than one column as the key) och child key in the dimension editor in an existing parent-child dimension? If so you would have to make a change in the dimension usage tab(where you join dimensions and measure groups), in the cube editor to reflect that?

Check this and return if the problem is not solved.

HTH

Thomas Ivarsson