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?
i have checked it. There is no aggregation or group by clause.
Are the numbers correct when you look at the cube data at top nodes ?
Are there any duplicate records in your source fact table?
Edited by: Nasar on Dec 13, 2012 1:48 PM