Wednesday, March 21, 2012

Excel 2002 loose track of its source .cub

I Use Excel 2002SP2 to read a ".cub" file.

I've no problem to import data and manipulate the cube.

But, If I try to "refresh", I've got the following message

"Cannot instantiate the MSOLAP80UI.DLL prompt dialog component."

Installing "ptsfull.exe" from Sql Server SP3a, shift but doesn't solve the problem :

a window appears asking for the source of the pivot table, and lock itself if I point again on the ".cub" file.

This problem doesn't seems to be on support.microsoft.com, as the ".cub" file as less than 9 dimensions.
(http://support.microsoft.com/default.aspx?scid=kb;fr;287080)

Have you an idea or an hint of what I've do wrong ?

Excel 2002 seems to generate a temporary .cub when I do my work. Is it related to my problem ?I found the solution : I used a complementary tool to generate the local cubes.

Doing it directly by DTS "CREATE Global Cube" solved my incompatibility problem with the last Version of Microsoft tools.

No comments:

Post a Comment