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 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

Need Help

3 Replies

  • 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