I've found 4 fields which cause the Conversion overflow.

1 example: "TotalRevenueLCY".

The total sum value in SQL: 858376803445.19000000000000000000

Min value: -2243974.89000000000000000000

Max value: 429080429080.00000000000000000000

When I put this field as only measure in the...

I updated the fields used in the aggregate with convert(decimal(38,15),decimalfield) in the facttable.

Then processed the dimensions, and then the cube.

But I get the same error.

Shouldn't this fix the issue if...

All the measures are SUM aggregates from the fact table.

These are all Decimal(38,20) fields.

There is 1 count measure.

xmla command to process the cube:

<Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<Object>

<DatabaseID>AS_Intrion</DatabaseID>

<CubeID>ABIQS Opportunity</CubeID>

</Object>

<Type>ProcessFull</Type>

<WriteBackTableCreation>UseExisting</WriteBackTableCreation>

</Process>

Return value:

<return xmlns="urn:schemas-microsoft-com:xml-analysis">

<results xmlns="http://schemas.microsoft.com/analysisservices/2003/xmla-multipleresults">

...

I seem to get no warning messages in Visual Studio.

Only the warning that the number of errors exceeded the max number of errors.

I have processed all the dimensions individually, and then each cube.

I get an error on 2 measure groups.

Same conversion overflow. error.

For the measure group which causes the problem, alle measures...

I'm doing a full process of the cubes.

<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

<Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100">

<Object>

<DatabaseID>AS_Intrion</DatabaseID>

</Object>

...

The profiler when the failing measure group processes.