Hi all,

When I start the processing of my cube in Analysis Services 2000 (SP3a), I
get the following error when the measures are processed: 'CANTCONVERTDATA'.

When I look in the facttable in SQL (via Query analyser), the value of the
measure is ".000000". Before the dot, no zero is displayed. When I change
the value in e.g. ".01", the same error occurs. Only when there is a figure
in front of the dot, processing is ok. The zero-figure is always replaced by
a dot.

Is the display format the problem, like Analysis Services can't handle the
format where there's no number before the dot ? If yes, how can I correct
this? I thought zero should not be a problem.

Kind regards,

Jeroen db

Hi Jeroen,

I have seen this problem several times and this was alway related to
locals. For example if you where processing with a User (Dutch locals)
against an Analysis server installed with (Eng US locals). Resolution is
making sure that both locals are the same. Keep in account that if you
installed Analysis with the local system account that it's using the
default system locals and if you are running it under a user account that
it's using those locals. I you schedule the processing make sure that the
account used for scheduling (fe sqlagent account) is the same.

HTH,
Bas

"This posting is provided "AS IS" with no warranties, and confers no
rights."

I have the exact same problem both when processing manually and using DTS
packages scheduled in SQL Agent. The Analysis Server, SQL Server and SQL
Agent all run using the same account. And my jobs have been working flawless
for many months.



How could I verify that the settings are correct?



Thanks in advance.

Hans S



By the way,

Why is there now KB article from MS support about this problem?





""Bas Kersten [MSFT]"" <bask (AT) online (DOT) microsoft.com> wrote

The problem goes away if I change the data type of the measure to Currency
(from Double/Decimal/.).

How come?



Some time ago I read an article comparing the data types (max values,
resolution etc) in Analysis Services. Now I can't find it again. Anyone
know?



Thanks

Hans S



""Bas Kersten [MSFT]"" <bask (AT) online (DOT) microsoft.com> wrote