This content has been marked as final. Show 3 replies
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?