Does anyone have an idea of the issue i posted , either a yes or no answer because i have seen many views but no one replied
Well.. thing here that it's pretty impossible to tell what's going in on here.
For starters, you are comparing data from two different sources and there's always a chance of data mismatch there.
Second, you are comparing relational data with cube data - are you familiar with cube's configuration as to how it aggregates its data?
And last, you wrote your SQL query (joins, grouping, filters) by hand so there's not not a lot of room for Tableau to screw anything up.
My advice is to unroll this quite complex workbook and start with basics, i.e. is SUM([Sales Amount (Actual)]) correct (227,390,962)? If not - then SQL query needs to be fixed.
And there's blending as well!
p.s. this is definitely not a topic for newbie section - you are a pro!
I agree with Dmitry. Right now, it is really difficult to dissect where the issue might be occurring.
1. Run your custom sql query in a third party SQL tool and see what the Sum([Sales Amount(Actual)] is.
2. If the answer is the same as the one Tableau has, then it is either something wrong with the query OR it is something wrong with the underlying data that your Cube isn't catching
3. If the answer is NOT the same as the one Tableau has, then there is probably something going on with the driver or the way Tableau is writing the query - Open a support case
As a side note, it looks like your Custom SQL query can be handled by adding data source filters and using a traditional connection in Tableau. I'm not a SQL expert by any means, but maybe you can elucidate why using the data pane does not work for your needs?