I am able to drillthrough in BIDS, in excel i receive the following error
"the query did not run or the database table could not be opened"
I then asked my colleague to perform the same drillthrough in Excel, it worked for him on his machine
On comparing the connection strings that excel automatically builds for us there is a slight difference
I have Provider=MSOLAP.4 he has Provider=MSOLAP.3
I tried editing the connection string to match his however I still have the same issue
I then asked him to log onto my machine and perform the same drillthrough, he receives then receives the same error.
It points toward an issue with my machine, maybe a setting somewhere? Can anyone help?
Profiler shows the following error:
XML for Analysis parser: The LocaleIdentifier property is not overwritable and cannot be assigned a new value.
DRILLTHROUGH MAXROWS 1000 SELECT FROM [x86] WHERE ([Measures].[Value],[Test].[Fruit].&[Apple])
View Complete Post