Cannot make cube measure working - error due to null values

The error message is actually pointing to the root cause:

"Allocation failed, reference measure has no value for this cell. You can only allocate where the reference measure has an existing value."

This usually means the allocation is trying to write to a cell where the reference measure is blank (NULL) rather than zero.

A few things to check:

Verify that your reference measure returns a value for every intersection of the dimensions you're allocating to. Even one missing combination can trigger this error.

Check whether the source data contains NULL/blank values instead of 0. If so, consider replacing NULLs with 0 where appropriate before building the cube.

Ensure that all required dimension members (Year, Version, Cost Center, Account, etc.) exist for the target cells.

Validate that your allocation reference measure is evaluated at the same granularity as the allocation target. A mismatch in dimensionality can also result in blank cells.

If you're still unable to identify the issue, it would be helpful if you could share:

The definition of the reference measure.

The allocation rule.

A small sample of the source data.

That will make it much easier to determine whether the issue is caused by missing data, the measure logic, or the allocation configuration itself.