Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

SSAS query filter

Dear all,    I am facing very long data loading time when trying to connect to SSAS leading to server timeout error.  I want to filter the date in the query. This will avoid to load my whole data ...
Interesting Links
  • ImkeF's avatar
    ImkeF
    9 years ago

    When using member-filters, you have to select the full string of the element. So it's fast, but not flexible.

    For searches like "Starts with..." you have to use Text filters, but then you pay the performance penalty. So try to reduce the imported data by using member filters first and continue with text filters (who will often not fold back).

ImkeF's avatar
ImkeF
Community Champion
9 years ago

When using member-filters, you have to select the full string of the element. So it's fast, but not flexible.

For searches like "Starts with..." you have to use Text filters, but then you pay the performance penalty. So try to reduce the imported data by using member filters first and continue with text filters (who will often not fold back).

mjohnston0209's avatar
mjohnston0209
Regular Visitor
3 years ago

Is it possible to to use a member filter for a list of values located on a worksheet? I found the proper coding when referring to a specific cell, but am having difficulty for a list of values. The list is variable, meaning it could range from 1-20 items. The list is housed in a table.