I don't think you'll have much success with that approach. From what I remember you need to use the InfoBright file loader (ASCII files, or binary files if you have...

For Excel 2007 to use the FORMAT_STRING setting correctly, you may also need to set the LANGUAGE property for the calculated member - see this blog post;

http://bisqlserver.blogspot.com/2008/12/ssas-calculated-member-currency-format.html

Thanks to the poster above, changing the data source provider to System.Data.SqlClient also solved this problem for me. cheers! 🙂

I work for a large (12000 staff) organisation and our national IT manager is 3 organisation levels below the the CEO, and I can tell you now it makes life...