I am getting the error "Input string was not in a correct format." with some
MDX queries (not all the queries).

Anyone know what I need to change to get rid of this error ?

Thanks,
Sam

Hello,

I installed the SQL Server and the Analysis Services, and am trying to see the cubes data and dimensions data in the Foodmart 2000 example. Buth an error is returned instead.
In Cubes data portion the error is :

"Provider cannot be found. It may not be properly installed"

In editing Dimension when i see data following error occurs

"Unable to browse the dimension 'Category'. Unspecified error"

Can any one tell me please what is the problem and what am I doing wrong ?

Please

regards

Kashif Zia
Pakistan Internation Airline

Hello,

Have you install SP3 of Analysis Service? if no you can download it from
http://www.microsoft.com/sql/downloads/2000/sp3.asp

If you got the error on a client computer, you can install PTSFULL.EXE . You
will find it in the PTS directory of the unpack sp3

Best Regards,

Patrice

"Kashif Zia" <Kashif Zia (AT) discussions (DOT) microsoft.com> a écrit dans le message
de news:0A208077-438A-4905-BD18-FCEE87825E26 (AT) microsoft (DOT) com...
error is returned instead.

I have resolved the same problem in this situation:

Original formula: [Measures].[A]/[Measures].[b]

When [Measures][b] = 0 I have the error.

Correct formula: IIF([Measures].[b] <> 0,[Measures].[A]/[Measures].[b],NULL)



"Samir Bencoscos" wrote: