MS SQL Server OLAP - unexpected error in OLAP Cube

Author

unexpected error in OLAP Cube

Sanju via SQLMonster.com

2005-09-27, 3:24 am

Hi All,

I am facing a problem while using OLAP Cube in excel sheet. I am using SQL
Server 2000 and Service Pack 4.

When I put 3 - 4 dimensions on left side (left blue line area of pivot table),
this give me error message 'unexpected error occure' and some times, values
of measures (used for the purpose) go away.

Due to this unexpected error, i m not able to design any complex report and i
cant use more than 3 dimensions in the same report.

Anyone, who can help me, is requested to mail me at sanjeev.sharma.darc@gmail.
com directly or reply this message.

Thanx

Saneev Kumar

Darren Gosbell

2005-09-28, 3:24 am

Could be the version of MDAC/PTS on the client.

Try running the PTSFull.exe that should have come as part of SP4 on the
client computer. This will install the latest MDAC/PTS components on the
client.

--
Regards
Darren Gosbell [MCSD]
< dgosbell_at_yahoo_do
t_com>
Blog: http://www.geekswithblogs.net/darrengosbell

Sponsored Links