Are you using T-SQL or MDX for your datasets? There will be different approaches based on different SQL services.