HI All,

Take a look at the following querries,

SELECT NON EMPTY { [Measures].[Commission] } ON COLUMNS , NON EMPTY {
[Time].[Financial Year].[All Time] } ON ROWS FROM [Commission]

SELECT NON EMPTY { [Measures].[Commission] } ON COLUMNS , NON EMPTY {
[Time].[Financial Year].[All Time] } ON ROWS FROM [Sales]

these are for 2 different cubes. Sales and Commission. In Sales 'Commission'
is stored against "Invoice" and in 'Commission' cube it's against customers.

If I check the sum in sql database from both the tables, it's same (as it
should b), but the querry returns different results. The Commission cube is
right (same as sql querry) but sales cube returns very small amount.

Any idea y's this happening ?

regards,

kshitij.

The dimensions will be diffrent for both the cubes, thats the reason
you may be getting diffrent results. You will need to join your result
with the other Dimension's Tables in order to get the correct result.