
I have a created a Sales Data Cube which contains all the sales related information under one roof. I am trying to access the data cube from MS Excel for reporting and analysis purposes through Analysis Services. The problem is that I am able to pull only 10-11 fields. As I go on adding more and more fields the processing becomes slow and finally, gives the error message as “File system error: a FileStore error from WriteFile occurred”. Please, guide me through this.
*This post is locked for comments
I have the same question (0)I was trying to re-use the out of the box sales cube but it looks like I might have to go this route. Can you share the XPO so that I can help out.