Hi All,
I am using SQL Server 2000, Analysis Server for OLAP Cubes. I am facing
one problem while using the OLAP Cube through Pivot Table of Excel.
When I put 3-4 dimensions in left column, either I face the error
message "An unexpected internal error has occured." or, sometimes, data
(measure value) go away without giving any error msg, leaving the
format (made through dimensions).

Please help me and give me your valuable suggestions in this regard.

Thanks,

Sanjeev Sharma
( DARC-Hisar )

Hello. Maybe if you can specify more your problem we can understand.

I had this kind of problems when my system resources can´t held retrieval
values. Sometimes when using incorrect MDX formulas that crashed Excel, or
maybe wrong Custom Rollup Formulas.


--
Message posted via http://www.sqlmonster.com