I have a working SSAS 2005 cube running against a small SS2005 database and successfully deployed so that it can be seen across the internet, and Excel 2002 or 2003 with the correct OLEDB provider installed can view the cube in a pivot table.
I want to be able to demonstrate that the cube dynamically updates when the underlying data changes.
I have therefore changed the measure partition to ROLAP, and now realise that I need to change the dimensions to ROLAP too. I have changed all except one of them successfully. Trying to change the last one causes SSAS2005 to crash during deployment, apparently with no explanation.
On some occasions, deploying the cube reports error:
Internal error: An unexpected error occurred (file 'mdhierarchy.cpp', line 3142, function 'MDUnmaterializedHierIter::Init'). 0 0
rather than killing SSAS2005.
If I try to specify Proactive Caching for this dimension, it gets very confused, because it reports it as a MOLAP dimension, when it isn't.
The dimension it is getting upset about accesses the database through a view.
Has anyone else run into this? If so, what can be done about it? It looks like I have found a bug in SSAS2005.
Have you tried installing SQL Server 2005 service pack 1 to see if you still get the same problem there? http://www.microsoft.com/downloads/details.aspx?familyid=cb6c71ea-d649-47ff-9176-e7cac58fd4bc&displaylang=en
If this is not working, please try and contact Customer Support to report the problem.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights
Dear Edward,
Thanks for the suggestions.
The problem has shown up after upgrading to SP1, so I will have to take up your suggestion of contacting Customer Support.
