Forum Discussion
thiagozaiden
10 years agoMicrosoft Employee
Filter Analysis Services before Importing Data
Hello guys, I have a very big cube that has data from all over the world, but I only need one specific country. I could import everything and then filter it, but since its too big, I keep gettin...
- 10 years ago
Use "Advanced options" when creating your query and paste in your MDX to filter the data at the time of query.
thiagozaiden
10 years agoMicrosoft Employee
It worked! Thanks
Anonymous
8 years agoNot applicable
What's the MDX code to filter it?
- dkay84_PowerBI8 years agoMicrosoft EmployeeYou need to research mdx based in your use case and requirements. No one here is a mind reader