I have a report where the aggregation is done locally.. as in xsums, xmins etc...Native sql doesnt have the corresponding sum, etc. This is effecting performance.
How can i send it to Native sql, any clues?
There's a setting in query properties called "rollup processing". In Query Explorer select your query, then in properties pane change "rollup processing" to "Database" (Default is "Extended"). See if this helps.
Tried it out and it didnt help.