We'd like to update a dimension that has 200K members. We do not have Excel 2007. Is there a way to process the members beyond the 65,000 row excel limitation? For Example can I export a dim file from sql to notepad, save the notepad file as a .dim file, and place it on the server and process?
Any body have any solutions?