SSAS Import with Filter

[AndyTrezise]

Hi

I am trying to load data (via Import) out of my SSAS cube into tables (so I can add further measures etc.) but there are 100's thousands of rows so performance is very poor.

Is there a way to filter the data server side before it is downloaded?

I am not particularly technical so wondered if anyone had any simple step by step instructions as to how this could be done.

Any help much appreciated

[v-jiascu-msft]

Hi @AndyTrezise,

There is a quite simple way you can try. In the Query editor, do "Keep rows" before loading or refreshing. 

Best Regards,

Dale

[AndyTrezise]

Thanks for the suggestion

Keep rows - as far as I can see - only allows me to filter out / keep a specific number of rows...

I need to be more specific and filter basic on column data within the cube - i.e. transaction_date >= 01/01/2018 thus eliminating the need to import all the data before the start of 2018

[v-jiascu-msft]

Hi @AndyTrezise,

Since it's a cube, I would suggest you try to customize the query with MDX at the beginning.

Best Regards,

Dale