Hi, 😀
I have an SSRS report to show the order count per YEAR - Quarter.
But, the total order counts is not the same in SSAS cube browser and in SSRS report.
Explanation:
I have a simple time dimension: [Year - Quarter - Month - Date], and want to count orders. ( source is a SSAS CUBE)
1) IF in the SSRS DataSet Query Designer I drop the [YEAR]
On the level [Year] (2009) I get : [2009] 16256 (this is correct)
2) IF in the SSRS DataSet Query Designer I drop the [Year - Quarter] (2009, Q1, Q2, Q3) I get:
[Y2009] [Q1] : 6993 (is correct)
[Y2009] [Q2] : 7558 (is correct)
[Y2009] [Q3] : 1782 (is correct)
But, 6993+7558+1782=16333 and not 16256,
and in my report the auto generated total field shows also: 16333
but this is not correct, it should be 16256.
If I Check in SSAS cube browser,I get correct values:
Y2009 Q1 6993
Y2009 Q2 7558
Y2009 Q3 1782
Total 16256
Grand Total 16256
This is when order lines have more then one delivery dates.( I group on the deliver dates)
So, getting data via cube browser is correct, but via SSRS is not correct.
Regards,