Forum Discussion

AndyTrezise's avatar
AndyTrezise
Advocate IV
8 years ago

SSAS Import with Filter

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...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi AndyTrezise,

 

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

SSAS_Import_with_Filter

 

 

Best Regards,

Dale

AndyTrezise's avatar
AndyTrezise
Advocate IV
8 years ago

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's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi AndyTrezise,

     

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

    SSAS_Import_with_Filter2

     

    Best Regards,

    Dale