I'm using SQL Server 2005 for my cubes. When I refresh the data source view, I get an error that is show below

Question

There were changes in the tables. Whenever I press refresh again or try to process any cube, it's ignored an the message
"Property not accessible because 'Parent Columns and Child Columns don't have type-matching columns" appears. I reviewed all the tables, I saw what are the changes in fields, most of them are from double to decimal, I don't this might affect the design. Any Help?

Answer 1

Hey try this you will find the answer yourself

http://www.microsoft.com/technet/prodtechnol/sql/2005/UsingRSwithSAPNetWeaver.mspx