Error in log "ERROR BatchLoader$Batch:1432 - AggGen failed"

[Sparkles]

Everytime Mondrian is queried about a fact table, the following message is logged:

WARN AggGen:279 - Init: For fact table "FACT_IP_ADDRESS", could not get column name for RolapStar.Column: Fact Count (22): count(null)
ERROR BatchLoader$Batch:1432 - AggGen failed

Why is this the case?

The database tables do not have a column named "FACT_COUNT", instead they have a column named "VALUE".

How to resolve this problem? Everything seems to work fine, but the error continues to be logged.

[madland]

I'm suffering from same problem..
if you solved them, could you let me know how solved?
thank you in advance..T^T

[Sparkles]

Found no solution or support to the problem. Scrapped entire Mondrian OLAP server and replaced with Microsoft's SSAS. That was how I solved it.

[gutlez]

You need to have a count of the facts to be able to work out things like averages.

Think for a moment that you have facts:
Dim1 | Dim2 | Fact | Unique
1 | 1 | 1 | 1
1 | 1 | 1 | 2
1 | 1 | 1 | 3

When you aggregate it, you get:
Dim1 | Dim2 | Value
1 | 1 | 3

So... What's the average? Is this total of 3 better than a block that has a value of 8?
What if the AGG table looks like:
Dim1 | Dim2 | Value | Fact_Count
1 | 1 | 3 | 3
1 | 2 | 8 | 16

Now what information can you determine?