There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
ExecuteDrillthroughAndFixColumns fails for money fields
I am trying to use ExecuteDrillthroughAndFixColumns for an Action against an Adventureworks cube. As soon as a Money measure is included in the result set of the Drillthrough command, it fails a message "OLE DB was unable to convert a value to the
data type requested for column x", which, I believe, is due to the fact that in the DataTable, fields with type money have type "Object".
Of course, changing the datatype of such fields solves the Problem, but that is hardly acceptable.
the Problem can be easily reproduced by calling ExecuteDrillthroughAndFixColumns from SSMS.