|
Home > Archive > MS SQL Server OLAP > April 2005 > identical querry with same data, but different results.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
identical querry with same data, but different results.
|
|
|
| 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.
| |
| Muhammad Mansoor 2005-04-25, 7:23 am |
| 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.
|
|
|
|
|