Forum Discussion
filter on import data from ssas
1) Get data - Analysis Services
2) enter your servers name etc
3) Assuming you're importing data (not live connection): Select your timedimension and simply load it all.
4) Edit Queries and filter the year to this year for example.
5) On your right in Query settings under Applied Steps - click on the gear sign right to "Added Item" and simply add the dimensions you need and Load them each time. Filter as much as you can each time as well.
For me this works better than loading all in one which either takes way too long or doesnt work at all.
This is something that we need to be able to pre-filter before loading IMO.
Hope this helps
Hi Anonymous
I've just seen your comment on the OP's issue and thought this looked like a great solution, however when I try this the filters are removed when adding fields so it doesn't make any impact. The reason being is that when clicking the 'cog' you're effectively going back a step to the pre-filter view.
Am I missing something?
Thank you
Chris
Hi
I wondered if you found a solution to your problem?
I have the same issue...i need to filter data from the SSAS cube at source as there are far too many rows to pull into PBI
