AWM is adding just 4 lack rows in the cube. While there are above 10 billion rows in fact table. Even I have applied no aggregation rule at any dimension in cube. And number of rejected records is zero.I am confused what could be the possible reason
Take a look at the SQL query generated by OLAP during cube load.
You can look at it in AWM cube mapping, OR in the CUBE_BUILD_LOG table.
Maybe a SUM..GROUP BY ... is happening during cube load and that is why 1 billion rows are becoming 400,000 rows.
Are the numbers correct when you look at the data at top nodes?