Hello - I am using an excel 2007 odc file to connect to an analysis services 2005 cube (on windows server 2003 R2 OS). I receive the following error message
"Excel was unable to get necessary information about this cube. The cube might have been reorganized or changed on the server"
Have already attempted the following fixes but running out of ideas now
1. Added localeIdentifier to ODC file
<odc:ConnectionString>Provider=MSOLAP.3;Integrated Security=SSPI;Persist Security Info=True;Data Source=bisql;Initial Catalog=SLAM ACT BUD; LocaleIdentifier = 1033 </odc:ConnectionString>
2. Ensured that all dimensional attributes which are used in MDX calculations (named sets, calculated members) are set to "AttributeHierarchyEnabled = True"
Running out of steam so any help is greatly appreciated.
View Complete Post