BPC Dimension Members and Office Version

To specify which version of Excel is used when working with Dimension members look at the tblDefaults table with the row containing KeyID MEMBERSHEET_VERSION.

You can change this to 2007 or 2003

Make sure to install MS Data Connectivity Components on the application server as well. See Note: 1289927 and this link: http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8

Leave a Reply

Your email address will not be published. Required fields are marked *