No data in Simple SQL Server 2005 Analysis Services Cube

Dec 29, 2008 at 7:03 PM

I installed, deployed & processed the cube on my live CRM system as discussed in the documentation.  At no point in this process do I receive any error.  From within the Visual Studio Microsoft CRM MSCRM data source view, I can open the tables & run the queries to see data.  The problem arises when I try to access the data via Excel.  I’ve added fields to the Row, Labels, Column Labels & Values sections, but I can’t get any data to display.    I have plenty of data in my CRM system, but may have the wrong combinations of fields.  Sorry if I’m missing the obvious, but this is my first data cube.  Can someone point me in the right direction?  Thanks for reading.

Feb 23, 2009 at 2:18 PM
I have the same problem.

Why no data is shoed in Excel? Do you solve the problem?

Oct 20, 2009 at 3:31 PM

I'm having the same issue - was there ever a resolution?