Hi:
If I have a measure for example "count" that is decimal number and I performed a 'sum' aggregation function in the cube. When I go to the all levels in all dimension the total count is smaller than if I go to the db and query the sum(count) from table1.
count in olap (sum of count at all levels) = 36,874
count form the query (sum(count))= 42,974
Do you think this difference is cause for the decimal places
in the table up to 28 decimal places
in the cube the measure is type double
Or do you think something else is wrong
If I start doing drill down and compare the values of count from olap to the ones from the query the results are ok. It is only at all level the issues
If I have a measure for example "count" that is decimal number and I performed a 'sum' aggregation function in the cube. When I go to the all levels in all dimension the total count is smaller than if I go to the db and query the sum(count) from table1.
count in olap (sum of count at all levels) = 36,874
count form the query (sum(count))= 42,974
Do you think this difference is cause for the decimal places
in the table up to 28 decimal places
in the cube the measure is type double
Or do you think something else is wrong
If I start doing drill down and compare the values of count from olap to the ones from the query the results are ok. It is only at all level the issues